Synchronizing Site Configuration with the Data Warehouse

You use the Configuration synchronization task to synchronize your site configuration with the Data Warehouse, so that any changes you make to the site configuration are propagated to the Data Warehouse. You must run the synchronize task before you run the import or delete tasks.

To synchronize site configuration with the Data Warehouse

  1. Expand Microsoft SQL Servers, 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 Configuration synchronization (Commerce Server).

  4. In the Synchronize DW Properties dialog box, do the following:

    Use this To do this
    Description Type a description for the synchronize task.
    Site name Select from the drop-down list the site that you want to synchronize with the Data Warehouse.
  5. Click OK.

  6. On the Package menu, click Execute.

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

  7. Click OK, and then click Done.

The Data Warehouse is synchronized with your Commerce Server site configuration. You can now configure Web log file import properties and import data into the Data Warehouse.

See Also

Configuring Web Log Files for Import

Configuring a Web Server

Configuring an Application

Adding a Non-Commerce Application and Web Server


All rights reserved.