Multi-Tier: Dedicated BI Server + AppDB Server

Low/Medium volume and low/medium count of users:

All the databases of Nectari are installed on the ERP (database) Server. Everything else is installed from the dedicated server for Nectari.

Important

[1] This configuration is not optimized for Cube performance (more specifically for Load All and Refresh tasks) unless you do the following:

  • Disable the Job Service on the Dedicated BI Server Application
  • Install the BI Service and Job Service on the same server as the Cube Database
  • Edit the web.config file (located in C:\inetpub\wwwroot\WebClient ) on the Dedicated BI Server Application by replacing the Value "http://OLAPDBSERVER:4504" of the following Key with the Server Address on which you installed the BI Service and Job Service:
    <add key="jobServiceAddress" value="http://OLAPDBSERVER:4504"/>
Note

All BI databases can be separated (on Dedicated BI Server Application or Dedicated BI Database Server).