Importing Data into the Data Warehouse

For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.

You use the Commerce Server import Data Transformation Services (DTS) tasks to import data into the Data Warehouse. Import data into the Data Warehouse in the following order, so that fact data is imported first and then dimension data:

• Web log file data

• Transaction data

• Catalog data

• Profile data

• Marketing data

You can manually configure the Commerce Server DTS tasks to import data, or you can use the Data Warehouse Import Wizard.

In This Section

• How to Run an Import DTS Package

• How to Start the Data Warehouse Import Wizard

• How to Select Transaction Properties for Import

• How to Configure the Default Web Site Properties for Import

• How to Specify the Location of a Log File to the Data Warehouse