Overview of the SQL Script Generation Use Case

The SQL script generation feature is explained with the help of a use case, that uses a sample workflow codegen_workflow and a demo database table INSUR_CUST_LTV_SAMPLE.

The use case demonstrates how to:

• Import, run, and deploy the workflow codegen_workflow

• Generate SQL script from the workflow codegen_workflow

• Schedule SQL scripts to run on the database using:

  • Oracle SQL Developer

  • Oracle Enterprise Manager

• Deploy the generated SQL scripts on a Target or Production Database

• Premise of the SQL Script Generation Use Case
  The SQL Script Generation use case described in this section is based on the following premises:
• About the Sample Workflow
  The sample workflow codegen_workflow, demonstrates data modelling and data scoring.
• Performing Prerequisite Tasks
  Before deploying a workflow, there are certain tasks which must be performed.
• Importing and Running a Workflow
  You can import a predefined workflow into a project.