7 Generating and Deploying SQL Scripts

SQL Script Generation is a feature that is available in Oracle Data Miner. This chapter provides and overview and a use case to illustrate this feature.

• Overview of the SQL Script Generation Feature
  Oracle Data Miner 4.1 provides the SQL script generation feature, using which you can generate SQL scripts for one or all nodes in a workflow. You can then integrate the SQL scripts into another application.
• 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.
• Generating SQL Script Files from the Workflow
  You must run the workflow before generating the SQL script from it.
• Scheduling Workflow Script Files
  All the generated SQL script files must be deployed to the target or production database where they are accessible by the database instance. The SQL script files must be stored together in the same directory.
• Deploying SQL Scripts on the Target Database
  Deploying the SQL scripts involves running the master script file from the base directory.