Data Warehouse Add On Configuration

The following configurations are for the optional data warehouse used by ATG Customer Intelligence. See more information about the data warehouse in the ATG Business Intelligence Installation and Configuration Guide.

SQL Files

The following SQL scripts create the data warehouse schema. You must run the scripts in the order they are listed.

  1. <ATG10dir>/Service10.1/Service/sql/install/vendor/
    service_framework_datawarehouse_all.sql

  2. <ATG10dir>/Service10.1/Service/sql/install/vendor/
    service_datawarehouse_all.sql

Note: if you have already created the data warehouse schema, you only need to create the tables that are specific to ATG Service. To create only ATG Service data warehouse tables, run:

<ATG10dir>/Service10.1/Service/sql/install/vendor/
service_datawarehouse.sql.