You can run a workflow to add tables to a database that is in the SQL plug-in inventory.

Prerequisites

  • Verify that you are logged in to the vRealize Orchestrator Client as an administrator.
  • Verify that you have a connection to a database from the Inventory view.

Procedure

  1. Navigate to Library > Workflows and enter the sql and configuration tags in the workflow search box.
  2. Locate the Add tables to a database workflow and click Run.
  3. Select a database to which to add tables.
  4. Select the tables that you want to add.
  5. Click Run.

Results

After the workflow runs successfully, the added database tables appear in the Inventory view of the vRealize Orchestrator Client.