You can run the SQL plug-in workflows to manage databases and database tables as well as to run SQL operations.
You can access the database configuration workflows from in the Workflows view of the Orchestrator client.
|
Add a database
|
Adds a database object to the plug-in's inventory.
|
|
Add tables to a database
|
Adds database tables to a database in the plug-in's inventory.
|
|
Remove a database
|
Removes a database object from the plug-in's inventory.
|
|
Remove a table from a database
|
Removes a database table from a database in the plug-in's inventory.
|
|
Update a database
|
Updates the configuration of a database object in the plug-in's inventory.
|
|
Validate a database
|
Validates a database in the plug-in's inventory.
|
You can access the SQL operations workflows from in the Workflows view of the Orchestrator client.
|
Execute a custom query on a database
|
Executes 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
|
Executes 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.
|