Integrating with the Data Warehouse
You must extend the following Data Warehouse components for use with a third-party product catalog:
Define Schema. The data schema must be defined appropriately by using the Commerce Server OLE database provider. For more information, see Extending the Data Warehouse.
Import Data. Catalog data is brought into the Data Warehouse by running the Catalog data import (Commerce Server) Data Transformation Service (DTS) task. You must create a custom script or application to import data from a third-party catalog into the Data Warehouse. For more information, see Importing Data into the Data Warehouse.
Prepare Data for Analysis. Before the data in the Data Warehouse can be analyzed it is exported to a Microsoft Online Analytical Processing (OLAP) Server to be stored in multidimensional cubes. For more info see** **Preparing Data for Analysis with OLAP Server
Modify or Create Reports. You will also need to modify or replace any reports that use product catalog data so that they can use third-party catalogs. For more information, see Creating Custom Reports.