Select Rows from a JDBC Table

You can run a workflow from the vRealize 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. Log in to the vRealize Orchestrator Client.
2. Navigate to Library > Workflows and enter the jdbc_examples tag in the workflow search box.
3. Locate the JDBC select from table example workflow and click Run.
4. On the Database connection tab, provide the required information.
   1. Type a database connection URL.
   2. Type a user name to access the database.
   3. Type a password to access the database.
5. On the SQL statement tab, type an SQL select statement similar to the following example.
   Example syntax is:

   SELECT * FROM "table_name"

6. Click Run.