A typical setup for Commerce Reporting involves three Oracle ATG Web Commerce environments:
An asset management environment running Oracle ATG Web Commerce Merchandising. This environment is used for maintaining the versioned site data, which it deploys to the production environment.
A production environment that runs the actual Oracle ATG Web Commerce site. This site logs data about customer activity.
A data loading environment that loads the data logged by the production environment into the Data Warehouse database tables.
This section describes how to set up these three environments. For additional information about installing database tables for Oracle ATG Web Commerce, see the Configuring and Populating a Production Database chapter.