You can run a workflow from the 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. Click the Workflows view in the Orchestrator client.
  2. In the workflows hierarchical list, expand 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.
    1. Type a password to access the database.
    2. Type a database connection URL.
    3. 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.