Create a Table by Using JDBC

You can run a workflow from the vRealize Orchestrator Client to create a database.

Prerequisites

Verify that the user account you are logged in with has the necessary permissions to run JDBC workflows.

Procedure

1. Log in to the vRealize Orchestrator Client.
2. Navigate to Library > Workflows and enter the jdbc_examples tag in the workflow search box.
3. Locate the JDBC create table example workflow and click Run.
4. Provide the required information, and click Next.
   1. Type a password to access the database.
   2. Type a database connection URL.
   3. Type a user name to access the database.
5. Enter an SQL create statement.
   Example syntax is:

   CREATE TABLE "table_name"
   ("column1" "data_type_for_column1",
   "column2" "data_type_for_column2")

6. Click Run.