Importing Transaction Data

You use the Transaction data import task to import transaction data. Before you import transaction data, you must synchronize your site configuration with the Data Warehouse by executing the Configuration synchronization task. After you import transaction data, you must run the Report preparation task, which organizes the imported data into designated online analytical processing (OLAP) cubes.

Note

• You must use the full load option and perform a full import the first time you import transaction data into the Data Warehouse. After you have imported transaction data, use the incremental load option to import only new data, created since you last imported transaction data.

To import transaction data into your Data Warehouse

1. Expand Microsoft SQL Server, expand SQL Server Group, and then expand the server on which your Data Warehouse is installed.

2. Right-click Data Transformation Services, and then click New Package.

   Alternatively, if you are changing an existing package, right-click Data Transformation Services, click All Tasks, and then select Open Package. Select the package you want to change, and then click Open.

3. On the Task menu, click Transaction data import (Commerce Server).

4. In the Transaction Import Properties dialog box, on the General tab, do the following:

   Use this	To do this
   Description	Type a description for this import task.
   Site name	Select from the drop-down list the site that contains the data you want to import.
   Incremental load	Select this option to import only new transaction data (based on a previous import).
   Full load	Select this option to import all transaction data.

5. Click OK.

6. On the Package menu, click Execute.

   The Executing Package dialog box appears, showing the progress of your import. When the import process is complete, the Package Execution Results dialog box informs you it completed successfully.

7. Click OK, and then click Done.

Transaction data is imported into the Data Warehouse. You must run the Report preparation task to organize the imported data into the designated OLAP cubes.

Note

• You can add multiple Data Transformation Services (DTS) tasks to a package, add sequencing or workflow information, and then run all the tasks in the package.

See Also

Data Warehouse Components

Importing Data into the Data Warehouse

Synchronizing Site Configuration with the Data Warehouse

Preparing to Create Reports

All rights reserved.