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

Before you begin

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.
    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.