4.2.1

c (Optional) Type a database port number.
If you do not specify a port number, the workflow uses a default port number.
d Type a user name to access the database.
e Type a password to access the database.
6 Click Submit to run the workflow.
Test a JDBC Connection
You can run a workflow from the Orchestrator client to test the connection to a database.
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
connection example workflow.
3 Right-click the JDBC connection example workflow and select Start workflow.
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 test the creation of a database.
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 create
table example workflow.
3 Right-click the JDBC create table example workflow and select Start workflow.
4 Provide the required information to create a table.
a Type a password to access the database.
b Type a JDBC connection URL.
Using VMware vCenter Orchestrator Plug-Ins
36 VMware, Inc.