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

Log in to the Orchestrator client as a user who can run JDBC workflows.

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.

a

Type a database connection URL.

b

Type a user name to access the database.

c

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.