4.2

4 Provide the required information to select rows from a table.
a Type a JDBC connection URL.
b Type a user name to access the database.
c Type a password to access the database.
d Type an SQL select statement.
An example syntax is:
SELECT * FROM "table_name"
5 Click Submit to run the workflow.
Delete an Entry from a JDBC Table
You can run a workflow from the Orchestrator client to test the deletion of an entry from a JDBC table.
Prerequisites
n
The Database plug-in must be enabled in the Orchestrator configuration interface.
n
You must be logged in to the Orchestrator client as a user who can run JDBC workflows.
Procedure
1 Click the Workflows view in the Orchestrator client.
2 In the workflows hierarchical list, open Library > JDBC > JDBC Examples to navigate to the JDBC delete
entry from table example workflow.
3 Right-click the JDBC delete entry from table example workflow and select Start workflow.
4 Provide the required information to delete an entry from a table.
a Type the first name of the user entry to be deleted.
b Type a user name to access the database.
c Type a JDBC connection URL.
d Type the last name of the user entry to be deleted.
e Type a password to access the database.
f Type an SQL delete statement.
An example syntax is:
DELETE FROM "table_name" where ("column1" = ?, "column2" = ?)
5 Click Submit to run the workflow.
Delete All Entries from a JDBC Table
You can run a workflow from the Orchestrator client to test the deletion of all entries from a JDBC table.
Prerequisites
n
The Database plug-in must be enabled in the Orchestrator configuration interface.
n
You must be logged in to the Orchestrator client as a user who can run JDBC workflows.
Procedure
1 Click the Workflows view in the Orchestrator client.
Using VMware vCenter Orchestrator Plug-Ins
36 VMware, Inc.