Share via


Commerce Server DTS Tasks

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

You use Commerce Server Data Transformation Services (DTS) tasks to import and change data in the Data Warehouse. The Commerce Server tasks are loaded into SQL Server when you unpack a site. You add the Commerce Server tasks to a SQL Server package and then run that package to make changes to the Data Warehouse. For detailed information about how the DTS tasks work, see ETL Processing for DTS Tasks.

DTS Tasks

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 UI.

The following table lists the tasks that Commerce Server provides for the Data Warehouse. The tasks are listed in the order in which they must be run. (The Data Deletion task is optional.)

Extract, Transform, and Load (ETL) DTS task

Description

ETL Process for the Configuration Synchronization DTS Task

Synchronizes the Data Warehouse with your Commerce Server application after you make changes to configuration settings. If the site configuration changes, this task should be performed before any other task.

ETL Process for the Web Server Log Import DTS Task

Imports Web log file data generated by your Web site. Web log file data is obtained when users visit your site and click links to site pages. The data includes the length of time that a user spent visiting your site, the referring site, ad clicks, ad reach, click frequency, and the "path" the user takes through the site, including entry and exit pages.

You use the Web Server Log Import task to provide information about what log file to import and where it is located. The Web log files must be in the World Wide Web Consortium (W3C) extended Web log file format.

ETL Process for the Transaction Data Import DTS Task

Defines and imports transaction data. Transaction data is created on your Web site when a user adds and removes items from a shopping cart, or makes a purchase. You can run reports to analyze transaction data.

ETL Process for the Catalog Data Import DTS Task

Imports product data from your catalogs. Importing product data provides your transaction reports with more descriptive product information than is available in transaction data. You can also run reports to analyze the sale of products.

ETL Process for the Profile Data Import DTS Task

Imports the following four types of profile data that Commerce Server collects when users visit your Web site:

  • User profile data.

  • Organization profile data.

  • Generic profile data.

  • Site terms.

ETL Process for the Campaign Data Import DTS Task

Imports data about campaigns. You use campaign data to analyze the success of your campaigns. You use the Campaign module in Commerce Server Marketing Manager to set up and run campaigns.

ETL Process for the Data Deletion DTS Task

Deletes data from the Data Warehouse. You can select to delete detailed log file data for a specified site or for all the sites in the Data Warehouse. You can also select to delete all data (detailed and summarized) in the Data Warehouse.

ETL Process for the Report Preparation DTS Task

Prepares data for Online Analytical Processing (OLAP) cube processing and SQL reporting, and updates the cubes after a deletion. This task must be performed after every import and delete task.

In addition to using the Commerce Server DTS tasks to import Commerce Server data into the Data Warehouse, you can extend the logical schema and the functionality of the Data Warehouse to import custom data.

For information about how to extend the logical schema of the Data Warehouse to import custom data into the Data Warehouse, see Extending the Data Warehouse.

For information about how to create new DTS tasks, see SQL Server Books Online.

See Also

Other Resources

How to Start the Data Warehouse Import Wizard

Specifying Data to be Imported into the Data Warehouse

What Are the Data Warehouse Analytics Components?