You can run the SQL plug-in workflows to manage databases and database tables and to run SQL operations.

You can access the database configuration workflows from Library > SQL > Configuration in the Workflows view of the Orchestrator client.

Workflow Name

Description

Add a database

Adds a database object to the plug-in inventory.

Add tables to a database

Adds database tables to a database in the plug-in inventory.

Remove a database

Removes a database object from the plug-in inventory.

Remove a table from a database

Removes a database table from a database in the plug-in inventory.

Update a database

Updates the configuration of a database object in the plug-in inventory.

Validate a database

Validates a database in the plug-in inventory.

You can access the SQL operations workflows from Library > SQL in the Workflows view of the Orchestrator client.

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.