You can run a workflow from the vRealize Orchestrator Client to test the deletion of an entry 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. Navigate to Library > Workflows and enter the jdbc_examples tag in the workflow search box.
  2. Locate the JDBC delete entry from table example workflow and click Run.
  3. Provide the required information.
    1. Enter the first name of the user entry to be deleted.
    2. Type a user name to access the database.
    3. Enter a JDBC connection URL.
    4. Enter the last name of the user entry to be deleted.
    5. Type a password to access the database.
  4. Enter an SQL delete statement similar to the following example syntax.
    DELETE FROM "table_name" where ("column1" = ?, "column2" = ?)
  5. Click Run.