5.1

4 Provide the required information, and click Next..
a Type a database connection URL.
b Type a user name to access the database.
c Type a password to access the database.
5 Type the values to be used as entries in the database.
6 Click Submit to run the workflow.
SQL Plug-In Workflow Library
You can run the SQL plug-in workflows to manage databases and database tables as well as to run SQL
operations.
You can access the database configuration workflows from Library > SQL > Configuration in the
Workflows view of the Orchestrator client.
Add a database
Adds a database object to the plug-in's inventory.
Add tables to a database
Adds database tables to a database in the plug-in's inventory.
Remove a database
Removes a database object from the plug-in's inventory.
Remove a table from a
database
Removes a database table from a database in the plug-in's inventory.
Update a database
Updates the configuration of a database object in the plug-in's inventory.
Validate a database
Validates a database in the plug-in's inventory.
You can access the SQL operations workflows from Library > SQL in the Workflows view of the Orchestrator
client.
Execute a custom query
on a database
Executes a custom query on a specified database and returns the number of
affected rows. You can run the workflow to update, delete, insert, and write
queries
Generate CRUD
workflows for a table
Generates Create, Read, Update and Delete workflows for a particular table.
Read a custom query
from a database
Executes a custom query on a specified database and returns the result in an
array of properties. You can run the workflow to select and read queries.
Using VMware vCenter Orchestrator Plug-Ins
42 VMware, Inc.