Commerce Server DTS Tasks
You use Commerce Server 2009 Data Transformation Services (DTS) tasks to import and change data in the Data Warehouse. The Commerce Server 2009 tasks are loaded into SQL Server when you unpack a site. You add the Commerce Server 2009 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 2009 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 2009 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 |
|---|---|
Synchronizes the Data Warehouse with your Commerce Server 2009 application after you make changes to configuration settings. If the site configuration changes, this task should be performed before any other 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. |
|
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. |
|
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. |
|
Imports the following four types of profile data that Commerce Server 2009 collects when users visit your Web site:
|
|
Imports data about campaigns. You use campaign data to analyze the success of your campaigns. You use the Campaign module in Marketing Manager to set up and run campaigns. |
|
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. |
|
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 2009 DTS tasks to import Commerce Server 2009 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