How to Unpack the Data Warehouse Resource
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 2009 may not delete the databases that you created during the unpacking process.
To unpack the Data Warehouse resource
Log on to the business management server as an administrator.
Click Start, point to Programs, point to MicrosoftCommerce Server 2009 , and then click Commerce Server Manager.
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.
Point to New, and then click Add Resource.
In the Add Resource From dialog box, select DW.pup, and then click Open.
Site Packager starts.
On the Select Resources page, in the Available resources box, select Data Warehouse, click Add, and then click Next.
On the Global Resource Pointers page, click Next.
On the Database Connection Strings page, click Modify.
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.
On the Database Connection Strings page, click Next.
On the Data Warehouse page, accept the default values, and then click OK.
In the Commerce Server Site Packager dialog box, click OK.
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