The data loading environment processes the data logged by the production environment and stores results in the Data Warehouse, where it can be used for running reports.
Create the Data Warehouse and data loader database tables by running these scripts:
<ATG2007.3dir>/ARF/DW/base/sql/db_components/db-vendor/arf_ddl.sql
<ATG2007.3dir>/ARF/DW/base/sql/db_components/db-vendor/arf_init.sql
<ATG2007.3dir>/DCS/DW/sql/db_components/db-vendor/arf_dcs_ddl.sql
<ATG2007.3dir>/DCS/DW/sql/db_components/db-vendor/arf_dcs_init.sql
<ATG2007.3dir>/ARF/base/sql/db_components/db-vendor/arf_loader_ddl.sql
<ATG2007.3dir>/ARF/base/sql/db_components/db-vendor/arf_id_generator.sql
When you assemble your EAR file for the loading environment, include the DCS.DW application module. (Including the DCS.DW module causes the ARF.DW.base and ARF.base modules to be included as well.)
Note that the data loading environments includes several repositories whose tables are part of the production environment. These repositories include the user profile repository, the product catalog, and the order repository. Make sure the datasources for these repositories are configured to point to the production database. For information about configuring datasources, see the ATG Installation and Configuration Guide.
