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.
Application + Database Server
ERP Application
Database Server (ERPDB + NectariDatabase + BI License Database + Cube Database + DataSync Database) [1*]
Dedicated BI Server Application
Nectari Server (complete installation)
Web Central Point Configurator
Microsoft Excel (* in case you are using Excel Add-In into the Distribution)
[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"/>
All BI databases can be separated (on Dedicated BI Server Application or Dedicated BI Database Server).