5.5.2

4 Provide the required information to test a database connection.
a Type a user name to access the database.
b Type the URL to test.
c Type a password to access the database.
5 Click Submit to run the workflow.
Create a Table by Using JDBC
You can run a workflow from the Orchestrator client to create a database.
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
create table example workflow.
3 Right-click the JDBC create table example workflow and select Start workflow.
4 Provide the required information, and click Next.
a Type a password to access the database.
b Type a database connection URL.
c Type a user name to access the database.
5 Type an SQL create statement.
An example syntax is:
CREATE TABLE "table_name"
("column1" "data_type_for_column1",
"column2" "data_type_for_column2")
6 Click Submit to run the workflow.
Insert a Row into a JDBC Table
You can run a workflow from the Orchestrator client to test the insertion of a row into 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
insert into table example workflow.
3 Right-click the JDBC insert into table example workflow and select Start workflow.
Chapter 6 Using the SQL Plug-In
VMware, Inc. 51