You can run a workflow from the Orchestrator client to select rows from 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 select from table example workflow.
  3. Right-click the JDBC select from 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 select statement.

    An example syntax is:

    SELECT * FROM "table_name"
  6. Click Submit to run the workflow.