Web Server Configuration

If you plan to deploy the OLAP cube with the Blackbaud Data Warehouse, you must configure your web servers to enable OLAP options in Blackbaud CRM such as the OLAP Explorer and the OLAP database roles tab on the Blackbaud Data Warehouse page. Keep in mind that if you have multiple web servers, you must configure them all for the OLAP cube.

Tip: If you don't plan to use the OLAP cube, you do not need to configure your web servers for OLAP. When you deploy the data warehouse, you can set the Deploy OLAP cube setting on the Edit Advanced Data Mart Settings screen to "False" in order to improve the performance of the ETL process and remove the need for Analysis Server.

SQL Server 2019

SQL Server 2019 with the latest service pack is supported for Blackbaud CRM version 4.0.

  • Install the SQL Server 2019 version of ADOMD.NET.

  • Update the web.config file for binding redirect to access OLAP Explorer. Copy the entry from the web.config file on the database server and place it into the web.config files on your web servers.

    Within the <runtime> and <assemblyBindings> tags near the beginning of the web.config files on your web servers, add the following information within <dependentAssembly> tags:

    <dependentAssembly>
     <assemblyIdentity name="Microsoft.AnalysisServices.AdomdClient" publicKeyToken="89845dcd8080cc91" />
     <bindingRedirect oldVersion="9.0.0.0-11.0.0.0" newVersion="12.0.0.0" />
    </dependentAssembly>

    <dependentAssembly>
     <assemblyIdentity name="Microsoft.AnalysisServices" publicKeyToken="89845dcd8080cc91" />
     <bindingRedirect oldVersion="9.0.0.0-11.0.0.0" newVersion="12.0.0.0" />
    </dependentAssembly>

  • Install SQL Server 2019 Analysis Management Objects for OLAP database roles.