You can use the SQL workflows to run SQL operations.
To access the SQL operations workflows in the vRealize Orchestrator Client, navigate to and enter the sql tag in the workflow search box.
|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.|