Skip to main content
Version: 2.2

Setup Planning

This page contains information about preparations that need to be done prior to installing b+s Reporting Interface and CCBI for CCE.

caution

Be aware that the Reporting Interface gets installed with the corresponding DB schema of the connected CCE system while doing the setup. If the CCE version has been upgraded in the meantime you need to re-setup the reporting interface to get the newest CCE version in place.

Setup Types​

The same software and installation instructions can be used to setup new systems or to upgrade previous versions of the reporting interface and CCBI for CCE.

Upgrades differ if the database needs to be moved onto another database server. Based on these options we differentiate between 3 types of setup within the workflow:

  • New System
  • Common Ground Upgrade (remaining on the same server)
  • Technology Refresh Upgrade (moving to new server infrastructure)

Components to install​

The Reporting Interface needs to be installed on all servers that are used as a primary or secondary (fallback) datasource of CUIC. The PBI database and the gateway are only needed on one side, if no cold standby setup is required.

Preparations​

Check System Requirements​

Make sure that all requirements of the dedicated database server for the Reporting Interface are fulfilled.

Specification of Configuration​

The following tasks (refer to the corresponding chapters in the Design chapter) need to be specified and implemented before data is loaded into the data mart:

Required User Accounts​

SQL Login for Setup​

An SQL login with the role "sysadmin" is required to run the installation on the database server.

SQL User on DAWs​

There must be an SQL login in place on all DAWs where the Reporting Interfaces will connect to. This user (normally named as "bsreporting") needs datareader permissions on AWDB and HDS.

Maintenance window​

For the setup of CCBI for CCE there is no need for a maintenance window. If you need to upgrade an existing b+s Reporting Interface, follow the corresponding recommendations.