Importing Campaign Data

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

To import catalog 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 Campaign data import (Commerce Server).

4. In the Campaign Import Properties dialog box, 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.

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.

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