JDBC Process Definition Wizard
You can use the JDBC process definition Wizard to create JDBC process definitions. The wizard checks for the existence of a JDBC credential and allows you to select the one to use. It also allows you to construct the table query or procedure call. You specify either the schema or the catalog to retrieve the table name from the database. For example in Oracle databases, you can specify the dict catalog which will display all tables the connecting user can see.
Prerequisites
- A JDBC credential for the user specified in the Run As User field
- A JDBC process server in status Running connected to the target database
Procedure
Retrieving the contents of a table
- Navigate to "Definitions > Processes".
- Choose New Process Definition from the context-menu.
- Select JDBC as the definition type and choose Next.
- Select the user-process server combination and choose Next.
- Select Table Query in the Query Type drop-down.
- You can specify the schema of the table or a catalog to retrieve the table name, choose Next.
- Select the table from the drop-down and choose Next.
- A preview is shown of the table contents; choose Next.
- A process definition editor screen is displayed. Choose Save & Close.
Running a stored procedure
- Navigate to "Definitions > Processes".
- Choose New Process Definition from the context-menu.
- Select JDBC as the definition type and choose Next.
- Select the user-process server combination and choose Next.
- You can specify the schema of the procedure or a catalog to retrieve the procedure name, choose Next.
- Select the procedure from the drop-down and choose Next.
- A process definition editor screen is displayed. Enter a default value for the parameters of the procedure (if required) and choose Save & Close.