Running SQL Operations

You can use the SQL workflows to run SQL operations.

To access the SQL operations workflows in the vRealize Orchestrator Client, navigate to Library > Workflows and enter the sql tag in the workflow search box.

Workflow Name	Description
Execute a custom query on a database	Runs a custom query on a specified database and returns the number of affected rows. You can run the workflow to update, delete, insert, and write queries.
Generate CRUD workflows for a table	Generates Create, Read, Update, and Delete workflows for a particular table.
Read a custom query from a database	Runs a custom query on a specified database and returns the result in an array of properties. You can run the workflow to select and read queries.