Generate CRUD Workflows for a Table

You can run a workflow to generate Create, Read, Update, and Delete workflows for a particular table.

Prerequisites

■	Verify that you are logged in to the Orchestrator client as an administrator.
■	Verify that you have a connection to a database from the Inventory view.

Procedure

Click the Workflows view in the Orchestrator client.

In the workflows hierarchical list, select Library > SQL and navigate to the Generate CRUD workflows for a table workflow.

Right-click the Generate CRUD workflows for a table workflow and select Start workflow.

Select a table for which to generate the workflows.

Select the workflow folder in which to generate the workflows.

Select whether to overwrite any existing workflows.

Option	Description
Yes	The generated workflows overwrite existing workflows with the same name.
No	New workflows are not generated if workflows with the same name exist in the folder.

(Optional) Select columns that should not be populated.

You cannot edit the selected columns with the generated CRUD workflows.

Click Submit to run the workflow.

After the workflow runs successfully, the CRUD workflows appear in the selected workflow folder.

What to do next

You can run the generated workflows on the selected database table.