Configuring the Data Warehouse Resource
You must configure the Data Warehouse resource so your Data Warehouse works with Microsoft SQL Server. You can also configure the time zone and start day of the week that the Data Warehouse assigns to imported time data.
To connect your Data Warehouse to SQL Server, you set the connection string during the installation process. You can use Commerce Server Manager to change the user ID and password in the connection string at the global resource level. The Data Warehouse logs in to SQL Server with a user ID and a password.
Note
- You can change only the user ID and password in the Data Warehouse connection string. To change the entire connection string, you must unpack the site again. . For information about unpacking a site, see Unpacking a Site and Example B: Installing on a Three-Computer Non-clustered Configuration.
To change the connection string at the global resource level
To change the time zone and start day of the week
To change the connection string at the global resource level
Expand Commerce Server Manager, expand Global Resources, right-click Data Warehouse, and then click Properties.
On the Connection tab of the Data Warehouse Properties dialog box, do the following:
Use this To do this SQL Server Authentication Click to use a supplied user name and password to authenticate your login information. User ID Type the user ID to use for authentication when you log in. Password Type the password to use for authentication when you log in. To save your changes, click OK.
To change the time zone and start day of the week
Expand Commerce Server Manager, expand Global Resources, right-click Data Warehouse, and then click Properties.
On the Time tab of the Data Warehouse Properties dialog box, do the following:
Use this To do this Adjust timezone to Select the time zone from the drop-down list. Start day of the week Select the start day of the week from the drop-down list. To save your changes, click OK.
Note
- The SQL Server start day of the week is used in reports. The start day of the week you set in the Data Warehouse Properties dialog box is used to aggregate data imported from Web log files in weekly intervals.
The Data Warehouse resource is configured. You must configure Web log files for import and synchronize your site configuration with the Data Warehouse before importing data into the Data Warehouse.