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 following scripts to create
the business rules tables with a compatible database client for your
installation. These
scripts are located in
SASHome\SASDecisionManagerCommonDataServer\3.2\Config\Deployment\dbscript\oracle.
Before you run these
scripts, replace @schema.name@ in each file
with the schema name for your database.
-
brm_create_table.sql
-
brm_create_sequence.sql
-
brm_create_constraint.sql
-
brm_create_view.sql
-
brm_required_inserts.sql
-
edm_workflow_interface_create_table.sql
-
edm_workflow_interface_create_sequence.sql
-
edm_workflow_interface_create_constraint.sql
-
edm_workflow_interface_create_trigger.sql
-
edm_workflow_interface_required_inserts.sql
-
edm_create_table.sql
-
edm_create_constraint.sql
-
edm_create_sequence.sql
-
edm_required_inserts.sql
-
dcb_create_table.sql
-
dcb_create_constraint.sql
-
dcb_required_inserts.sql
Note: The data model for all tables
is the same for SAS Business Rules Manager 3.1 and 3.2 except
for the business rules (brm) tables. The data model version for business
rules tables is version 3.2.