You can run a workflow from the Orchestrator client to test the deletion of an entry 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 to navigate to the JDBC delete entry from table example workflow. |
3 | Right-click the JDBC delete entry from table example workflow and select Start workflow. |
4 | Provide the required information, and click Next.
a |
Type the first name of the user entry to be deleted.
|
b |
Type a user name to access the database.
|
c | Type a JDBC connection URL. |
d |
Type the last name of the user entry to be deleted.
|
e |
Type a password to access the database.
|
|
5 | Type an SQL delete statement.
An example syntax is:
DELETE FROM "table_name" where ("column1" = ?, "column2" = ?)
|
6 | Click Submit to run the workflow. |