You can use the workflows included in the SQL plug-in and run them from the vRealize Orchestrator client to configure the SQL plug-in and to add, update, or remove a database.

The Configuration workflow category of the SQL plug-in contains workflows that allow you to manage databases and database tables.

To access these workflows in the vRealize Orchestrator Client, navigate to Library > Workflows and enter the sql and configuration tags in the workflow search box.

Workflow Name Description
Add a database Adds a database object to the SQL plug-in inventory.
Add tables to a database Adds database tables to a database in the SQL plug-in inventory.
Remove a database Removes a database object from the SQL plug-in inventory.
Remove a table from a database Removes a database table from a database in the SQL plug-in inventory.
Update a database Updates the configuration of a database object in the SQL plug-in inventory.
Validate a database Validates a database in the SQL plug-in inventory.