Insert a Row into a JDBC Table

You can run a workflow from the vRealize Orchestrator Client to test the insertion of a row into 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 insert into 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, enter an SQL insert statement similar to the following example.

   INSERT INTO "table_name" ("column1", "column2")
   VALUES ("value1", "value2")

6. On the Values to insert tab, enter the values to insert into the row.
7. Click Run.