Create Oracle Database Tables

When you ran the SAS Deployment Wizard, the Automatically create tables and load data check box was selected by default for the SAS Decision Manager database. (See Create and Load Tables through the SAS Deployment Wizard.) If you cleared the Automatically create tables and load data check box and you do not have an existing database instance, you must run the SQL scripts to create and load the tables.
Run the CreateMMTables.sql script in order to create and load the model tables. The script is located in SASHome\SASModelManagerMidTier\14.1\Config\Deployment\Content\dbscript\oracle\.
Run the following scripts to create the business rules tables with a compatible database client for your installation. These scripts are located in SASHome\SASDecisionManagerCommonMidTierforDecisionManager\3.1\Config\Deployment\dbscript\oracle.
Before you run these scripts, replace @schema.name@ in each file with the schema name for your database.
  1. brm_create_table.sql
  2. brm_create_sequence.sql
  3. brm_create_constraint.sql
  4. brm_create_view.sql
  5. brm_required_inserts.sql
  6. edm_workflow_interface_create_table.sql
  7. edm_workflow_interface_create_sequence.sql
  8. edm_workflow_interface_create_constraint.sql
  9. edm_workflow_interface_create_trigger.sql
  10. edm_workflow_interface_required_inserts.sql
  11. edm_create_table.sql
  12. edm_create_constraint.sql
  13. edm_create_sequence.sql
  14. edm_required_inserts.sql
  15. dcb_create_table.sql
  16. dcb_create_constraint.sql
  17. dcb_required_inserts.sql
Copyright © SAS Institute Inc. All Rights Reserved.
Last updated: February 22, 2017