You can run a workflow from the Orchestrator client to test the insertion of a row into a JDBC table.

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 insert into table example workflow.
  3. Right-click the JDBC insert into table example workflow and select Start workflow.
  4. Provide the required information, and click Next.
    1. Type a database connection URL.
    2. Type a user name to access the database.
    3. Type a password to access the database.
  5. Type an SQL insert statement, and click Next.

    An example syntax is:

    INSERT INTO "table_name" ("column1", "column2")
    VALUES ("value1", "value2")
  6. Type the values to insert into the row.
  7. Click Submit to run the workflow.