Configuring the Data Warehouse and Analysis Server

  • Article

The Data Warehouse and analysis server imports, transforms, and stores Web site data. You use the data that is stored in the Data Warehouse database to analyze user activity on your Web site.

Dd451853.alert_caution(en-us,CS.95).gifImportant Note:

The Data Warehouse and Analysis feature is not supported in a three-tier commerce deployment topology.

The Data Warehouse uses SQL Server Analysis Services to access the online analytical processing (OLAP) database. SQL Server Reporting Services is required for analysis reporting.

Note

The Data Warehouse does not support SQL Server or SQL Server Analysis Services installed on a named instance.

To configure the Data Warehouse and analysis server, follow these steps:

  1. Perform all pre-installation requirements:

    1. Install all prerequisite software. For more information, see Software Requirements for an Enterprise Commerce Deployment

    2. Enable Internet Information Services (IIS). IIS is required to support remote access to Commerce Server reports. Perform the same task as you do on the business management server. For more information, see How to Enable IIS on the Business Management Server.

    3. Configure the network adapters. For more information, see How to Configure the Network Adapter on the Data Warehouse Server.

    4. Join the Data Warehouse and analysis server to the domain. For more information, see Windows Server 2008 Help.

    5. Create the DTSImport account on the data tier domain controller. For more information, see What Are the Required Accounts and Groups?.

  2. Configure SQL Server Reporting Services. For more information, see https://go.microsoft.com/fwlink/?LinkId=178686.

  3. On the Business Management server, unpack the Data Warehouse resource and add it to the Web site that you previously unpacked. For more information, see How to Unpack the Data Warehouse Resource.

    For each Web site in which you want to mine data, repeat this step.

    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.

  4. Install the Data Warehouse reports. For more information, see How to Install the Data Warehouse Reports.

  5. On the Data Warehouse and analysis server, grant the necessary permissions:

    1. Add the DTSImport account to the Administrators group.

    2. Create a DTSImport account on the Data Warehouse database.

    3. Grant the DTSImport account access permissions to the following Data Warehouse databases:

      Database

      Permissions

      Msdb

      db_datareader, db_dtsadmin, db_dtsltduser, db_dtsoperator

      <sitename>_DataWarehouse

      db_datareader, db_datawriter, db_owner, db_ddladmin

    4. Create a Data Warehouse role and grant it access permissions to the OLAP cubes.

    For more information, see How to Grant Permissions for Data Import and How to Grant Permissions on the Data Warehouse Server.

  6. On the run-time production databases, grant the DTSImport account access to the Web site databases:

    1. Create a DTSImport account on the run-time production database.

    2. Grant the DTSImport account admin_reader_role permission for the MSCS_Admin database.

    3. For each Web site that you added the Data Warehouse resource to, grant the DTSImport account the following permissions to the associated databases:

      Database

      Permissions

      <sitename>_DataWarehouse

      db_datareader

      <sitename>_marketing

      db_datareader

      <sitename>_marketing_lists

      db_datareader

      <sitename>_productcatalog

      db_datareader

      <sitename>_profiles

      db_datareader, Profile_Schema_Reader

      <sitename>_transactionconfig

      db_datareader

      <sitename>_transactions

      db_datareader

      For more information, see How to Grant Permissions on the Runtime Site Databases.

In This Section