You can run a workflow from the Orchestrator client to select rows from a JDBC table.

Prerequisites

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