A typical setup for Core Commerce Reporting involves three Core Commerce environments:
An asset management environment running Oracle 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 Core 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 Core Commerce, see the Configuring and Populating a Production Database chapter.