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 vRealize Orchestrator Client as an administrator.
• Verify that you have a connection to a database from the Inventory view.

Procedure

1. Navigate to Library > Workflows and enter the sql tag in the workflow search box.
2. Locate the Generate CRUD workflows for a table workflow and click Run.
3. Select a table for which to generate the workflows.
4. Select the workflow folder in which to generate the workflows.
5. 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.

6. (Optional) On the Select read-only columns tab, select columns that should not be populated.
   You cannot edit the selected columns with the generated CRUD workflows.
7. Click Run.

Results

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.