Importing Data into the Data Warehouse

You use the Commerce Server import 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
• Product Catalog Data
• Profile Data

Campaign Data

You can manually configure the Commerce Server DTS tasks to import data, or you can use the Data Warehouse Import Wizard. For more information about the wizard, see Data Warehouse Import Wizard.

This section contains:

• Specifying Data to be Imported into the Data Warehouse
• Changing the Time Zone and Start Day of Week for Imported Data
• Configuring the Default Web Site Properties for Import
• Specifying the Location of a Log File to the Data Warehouse
• Configuring the Web Server Log Import DTS Task
• Running the Web Server Log Import DTS Task
• Running the Web Server Log Import DTS Task for a Large Site
• Running the Transaction Data Import DTS Task
• Running the Product Catalog Data Import DTS Task
• Running the Profile Data Import DTS Task
• Running the Campaign Data Import DTS Task
• Importing Multilingual and Multicurrency Data
• Importing Cookies
• Retrying a DTS Task

Copyright © 2005 Microsoft Corporation.
All rights reserved.