Share via


How to Unpack the Data Warehouse Resource

For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.

This topic provides steps for unpacking the Data Warehouse resource and adding it to the Web site that you unpacked on the business management server. The Data Warehouse resource is unpacked from the DW example PuP package (DW.pup).

Note

If you are using SQL Server 2005, you must install the SQL Server 2000 DTS Designer Components on the Business Management server before you unpack the Data Warehouse resource. You install the SQL Server 2000 DTS Designer Components on SQL Server 2005 only. For information about how to install the SQL Server 2000 DTS Designer Components, see How to Install SQL Server 2000 DTS Designer Components.

Note

If you cancel the unpacking process, Commerce Server may not delete the databases that you created during the unpacking process.

To unpack the Data Warehouse resource

  1. Log on to the business management server as an administrator.

  2. Click Start, point to Programs, point to MicrosoftCommerce Server 2007 , and then click Commerce Server Manager.

  3. In the Commerce Server Manager console, in the left pane, expand Commerce Server Manager, expand Commerce Sites, and then right-click the site to which you want to add the Data Warehouse resource.

  4. Point to New, and then click Add Resource.

  5. In the Add Resource From dialog box, select DW.pup, and then click Open.

    Commerce Server Site Packager starts.

  6. On the Select Resources page, in the Available resources box, select Data Warehouse, click Add, and then click Next.

  7. On the Global Resource Pointers page, click Next.

  8. On the Database Connection Strings page, click Modify.

  9. In the Data Link Properties dialog box, on the Connection tab, in the Select or enter a server name box, type the SQL Server name, and then click OK.

  10. On the Database Connection Strings page, click Next.

  11. On the Data Warehouse page, accept the default values, and then click OK.

  12. In the Commerce Server Site Packager dialog box, click OK.

  13. On the Unpacking is complete! page, click Finish.

Note

When unpacking the Data Warehouse PuP files, the time zone is typically inherited from the SQL Server settings. However, if this information is not set correctly or is not correct for the Data Warehouse instance that you are installing, you must set the time zone manually. To set the time zone manually for Data Warehouse, open the Properties tab in the Data Warehouse Global Resource, and then click the Time tab. You can then set the time zone and starting day of the week manually. Any changes to the time zone will be in effect only for new imports. Existing data is not affected. To update existing data with the new time zone information, you must import the data again.

See Also

Other Resources

How to Unpack the Data Warehouse Resource

Using Commerce Server Site Packager

Unpacking Commerce Server Sites and Resources