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

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