5.1

Table Of Contents

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

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, and click Next.

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.

5 Type an SQL delete statement.

An example syntax is:

DELETE FROM "

table_name

" where ("column1" = ?, "column2" = ?)

6 Click Submit to run the workflow.

Delete All Entries from a JDBC Table

You can run a workflow from the Orchestrator client to delete all entries from a JDBC table.

Prerequisites

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

all from table example workflow.

3 Right-click the JDBC delete all from table example workflow and select Start workflow.

Using VMware vCenter Orchestrator Plug-Ins

40 VMware, Inc.