5.5.2

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 an SQL insert statement, and click Next.
An example syntax is:
INSERT INTO "table_name" ("column1", "column2")
VALUES ("value1", "value2")
6 Type the values to insert into the row.
7 Click Submit to run the workflow.
Select Rows from a JDBC Table
You can run a workflow from the Orchestrator client to select rows from a JDBC table.
Prerequisites
Log 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
select from table example workflow.
3 Right-click the JDBC select from table example workflow and select Start workflow.
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 an SQL select statement.
An example syntax is:
SELECT * FROM "table_name"
6 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
Log 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.
Using VMware vCenter Orchestrator Plug-Ins
52 VMware, Inc.