PANORAMA

Panorama Software Support & Knowledge Base

Necto 16 Installation Preparation Guide  

In order to successfully install Necto the following preparations are required.

Important note – all the servers which take part in the Necto system need to be in the same Domain environment.

Supported Operating Systems

You can install Panorama Necto on server environments only. The following operating systems are supported:

  • Windows Server 2012 R2
  • Windows Server 2012
  • Windows Server 2008 R2

Up-to-date Service Packs and windows updates should be installed.

Installation Location

Best practice is to install Necto on dedicated server.

Necto and its components should not be installed on the same box as other mission critical servers.

Necto should not be installed on Domain Controller machine, to avoid security conflicts.

For a non-production environment the Necto application Server can be installed on the same server as the SharePoint server. However, it is not recommended as both tend to use many CPU and memory resources and may interrupt each other’s proper functionality.

The Necto Databases and the Necto In-memory engine cannot be installed on the same server as the SharePoint server.

For a production system it’s required to separate the Necto Application Server and the Necto Databases and In-Memory servers in to either 2 or 3 machines.

SQL databases Location

During the installation, Panorama creates 4 databases on the SQL server. Panorama will only work with the following:

  • SQL Server 2008 R2 or
  • SQL 2012 SP1 or
  • SQL 2014
  • SQL 2016

These are the SQL repositories for the internal databases. This does not relate to the data source, (i.e., the OLAP cubes or In-Memory Engine).

Necto can work either with local or remote SQL Server or SQL Express. In addition, it provides the option of installing local SQL Express 2012 if there is no SQL previously installed on the relevant machine.

Note:  SQL must be set to Mixed Authentication mode (for instruction go to  http://technet.microsoft.com/enus/library/ms144284.aspx ) and be set to be case insensitive (collation).

Necto In-Memory Server

 

When using the Necto In-Memory Engine, a dedicated Server is required, Necto Databases can be installed on this same server but it is not a requirement.

The server should include an installation of the 2010 Office ACE provider (64 bit version) that can be downloaded from http://www.microsoft.com/enus/download/details.aspx?id=13255 but is included in the Necto installation.

Permissions

Panorama will require a user account which will be used to run the Necto services. Please make sure prior to the installation that you have credentials of a single user which meets these demands:

  • The user must be a Domain account if the machine that Necto is to be installed upon is part of a Domain (If a Workgroup machine then account must be local admin). On the machine the account must be an administrator (My Computer -> Manage -> Local User and Groups -> Groups -> Administrators; add the user to this group).

 

  • A sysadmin on the SQL server used for the Necto In-Memory Engine and for the Necto DB’s

(This is only a requirement for the installation, once installed the privilege may be lowered)

 

  • An SQL 2012, 2014, 2016 Tabular administrator on the server used for the Necto In-Memory Engine if you have your own instance of SQL 2012, 2014, 2016 Tabular installed.

 

  • An OLAP/Tabular administrator on the OLAP/Tabular Server containing the company data

For the installation you must log in with the user running the Necto services or you must be logged in as an administrator on the machine with a user who also has the privileges listed above.

Ports

The following ports that should be opened:

  • Port 4444 – for Panorama web site (this is default by installation, but can be changed, though not recommended).Make sure port 4444 is not blocked by firewall or third-party software; if you are unable to open this port, please consult this article for changing the default port.
  • Port 2383 for connection to Analysis Services
  • Ports 9985, 9999, 9961 for IIS connection.
  • Port 1433 for SQL

 

HTTP Entry points

 

The following HTTP sites should be allowed outbound access if you wish to use the GIS component:

Software checklist

  • .NET Framework 4.6
  • On any SASS server that is employed for Necto In-Memory Engine (that is not the same as the Necto server) you need to install Microsoft Access Database Engine 2010 64-bit http://www.microsoft.com/enus/download/details.aspx?id=13255
  • Flash player latest version installed on the designated server
  • Windows Components

Install IIS  role, with the following components:

 

  • Admin user must have region format “English (United States)”

Installer Semantics

Simple Installation – this installation type is used mainly for testing and developing purposes, the installer will install ALL Necto and SQL components on the same machine.

Production Installation – This installation type is used mainly for production purposes, this should be installed on more than one server separating the SQL from the Necto application server, the installer will let you install either the Necto application server or the SQL server separately, which means that after you install one you should run the installer again on a different machine to complete the full Necto installation