Share via


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.


All rights reserved.