Installing OLAP for SQL Server Cube database

Important

This step is only required for an installation of Nectari under Microsoft SQL server.

Oracle does not use a separate NectariCube database. If you are installing Nectari in Oracle, skip this step and go directly to Installing the Nectari Server (Basic) or Installing the Nectari Server (Advanced).

To install the Nectari OLAP Cube database, use the Nectari OLAP for SQL Server.exe installation package. Some steps will be required later to complete the Cube setup and to refresh it.

  1. Run the application Nectari OLAP for SQL Server.exe and click Next.

  2. In the License Agreement screen, click I accept the terms in the license agreement and click Next.

  3. Select the Database Server on which to install the NectariCube Database on and specify the connection information.

    • Leave the Use the Server Collation checkbox ticked to use the collation of the server for the database. Otherwise, untick it and type the desired collation in the field that appears.

    • Ticking the The Cube will be hosted by an SQL Server Remote Instance checkbox will allow you to create the NectariCube database in an SQL remote instance such as an RDS architecture, and you will not have the option to change database files path.

  4. Change the Location of the OLAP Cube Database files if necessary and then click Next.

  5. Click Install.

  6. Click Finish.