Running the Configuration Synchronization DTS Task

You use the Configuration synchronization DTS task to import the site configuration data stored in the Administration database into the Data Warehouse. (This differs from the Synchronize Values button in the Application Properties dialog box. When you click this button, Commerce Server reads the values from the IIS metabase to the Administration database, and then from the Administration database to the Data Warehouse. For more information, see Configuring an Application.)

In addition to running the Configuration synchronization DTS task to import site configuration data into the Data Warehouse, you accomplish the same step when you do either of the following:

  • Configure the Data Warehouse resource.
  • Unpack a site.

The Data Warehouse stores the site configuration data, which includes site topology settings, instead of reading it from the Administration database.

You can choose to synchronize the Data Warehouse with a single site, or with all of the sites in the Data Warehouse. You must run the synchronize task before you run any import or delete tasks.

Ee797020.note(en-US,CS.20).gifNote

  • You cannot cancel this task after it is started. Although you can click Cancel, the task does not stop.

To synchronize a single site configuration with the Data Warehouse

To synchronize multiple site configurations with the Data Warehouse

To synchronize a single 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 click Open Package. In the Select File dialog box, click 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.
    Operation level Select from the drop-down list Site level to synchronize a site with the Data Warehouse.
    Site name Select from the drop-down list the site that you want to synchronize with the Data Warehouse.
  5. In the Retry Properties section, do the following:

    Use this To do this
    Number of retry attempts Type the number of times you want the task to retry connection failures to the Data Warehouse. The default number of retry attempts is 10.
    Time between attempts (seconds) Type the amount of time you want the task to wait between retry attempts. The default time interval is 30 seconds.
  6. Click OK.

  7. 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 that it completed successfully.

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

To synchronize multiple site configurations 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. In the Select File dialog box, click 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.
    Operation level Select from the drop-down list Data Warehouse level to synchronize all sites with the Data Warehouse.
    Data Warehouse name Select from the drop-down list the Data Warehouse that you want to synchronize with the sites.
  5. In the Retry Properties section, do the following:

    Use this To do this
    Number of retry attempts Type the number of times you want the task to retry connection failures to the Data Warehouse. The default number of retry attempts is 10.
    Time between attempts (seconds) Type the amount of time you want the task to wait between retry attempts. The default time interval is 30 seconds.
  6. Click OK.

  7. 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 that it completed successfully.

  8. Click OK, and then click Done.

The Data Warehouse is synchronized with your Commerce Server site configurations. You can now import data into the Data Warehouse.

See Also

Configuring the Default Web Site Properties for Import

Configuring the Web Server Log Import DTS Task

Configuring an Application

Adding a Non-Commerce Application to a Site

Extending the Data Warehouse

Data Warehouse Schema

Copyright © 2005 Microsoft Corporation.
All rights reserved.