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 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. |