Installation Requirements
Before you install Incorta, ensure your system meets the following requirements.
Operating System
The following Operating Systems (OS) support the Incorta Direct Data Platform :
- CentOS 7 and up (7.5 and up recommended)
- Ubuntu
- Redhat 8 (starting with release 5.2.3)
Requirements
Installation of the Incorta Direct Data Platform requires the following:
- A valid license key if you are installing Incorta 5.2.3 or later. To obtain your license key, please contact Incorta Support.
- At least 16 GB of RAM. This number could increase depending on the amount of data
- A temporary directory (/tmp folder) with at least 2 GB of available space
- Fast storage disk (e.g. SSD)
- NFS v4 shared storage disk, accessible by all the services within the same cluster (i.e. loader and analytic services). The shared disk will be used to store data files (if applicable), parquet files, and snapshot files used by the system. This is not required if you are installing Incorta on a single server (for example, on your laptop)
- Java Development Kit (JDK) 8u144, JDK 8u171 and up, Open JDK 11, or Oracle JDK 8. Incorta does not support Java SDK 1.8.0.151 (8u151) through 1.8.0.171 (8u171). Install Java and set the Java home path. For more on how to install Java, see Install Java
- A database to connect to Incorta. See Database Requirements
- Zookeeper 3.6.1, bundled with Incorta, but you can install it separately. For more information, see Set up a Zookeeper Cluster
- Spark 2.4.7 and Hadoop 3.2.0, bundled with Incorta, but you can install them separately. For more information, see About Spark
- Python 3.5, 3.6, or 3.7
- Font families installed on each server where Incorta will be installed: Lucida Grande, Lucida Sans Unicode, Verdana, Arial, Helvetica, Sans-serif
- (Incorta Excel Add-in only) Microsoft Excel 2013
- (Incorta Excel Add-in only) Microsoft Excel Plugin, Version 16.8.1
Database Requirements
The Incorta Direct Data Platform requires one of the following RDBMS for the Incorta metadata database:
- Derby (packaged for demos and not recommended for production environments)
- MySQL (8)
- Oracle 12c and 19c
Incorta is supporting Oracle 12c or 19c starting with the 5.2.5 release.
When you install the Incorta Direct Data Platform on an Oracle or MySQL database, the user needs to be granted certain privileges in order to complete the installation successfully. If these privileges are not granted, users can experience database authorization issues during the installation process. Refer to the following table for the minimum required privileges.
Oracle | MySQL |
---|---|
CONNECT | CONNECT |
ALTER TABLE | ALTER TABLE |
CREATE TABLE | CREATE TABLE |
INSERT | INSERT |
CREATE INDEX | CREATE INDEX |
CREATE OR REPLACE SYNONYM | DROP TABLE |
CREATE OR REPLACE TRIGGER |
Incorta currently uses 0000-00-00 00:00:00
as default creation date. This value is not permitted in the recent versions of MySQL.
You must disable the two modes: NO_ZERO_DATE
and NO_ZERO_IN_DATE
by adding the following line at the end of the mysql.cnf file:
sql-mode="ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
You must restart the MySQL service and re-log in to MySQL.
The time zones of the Incorta server and the metadata database server should be the same to avoid errors when creating or editing schema versions.
Browser Requirements
You can use Incorta on the following browsers:
- Chrome
- Safari
- Firefox
You can use the Incorta iOS Application with iOS Release 4.0.
Port Requirements
The following table is a list of the ports required by the Incorta Direct Data Platform at startup. Using these ports will significantly help avoid startup issues. You set up some of these ports during the installation process. Others are fixed values and cannot be changed. Using the recommended ports will significantly help avoid startup issues.
Certain ports must be open and reachable through the network, and these are indicated in the table below.
The table below references file names. You can find the catalina.properties file and the server.xml file at the path: <INSTALLATION_PATH>/IncortaNode/services/<SERVICE_FOLDER>/conf/. Other files mentioned in the table begin can be found under: <INSTALLATION_PATH>/IncortaNode/.
Port Number | Access Type | Purpose | Install Parameter? | Where to change it | Notes | |
---|---|---|---|---|---|---|
80 | Incoming/ Outgoing | HTTP traffic Apache Web Server (if installed) | N | Admin Task | If installing Apache, ports 80 and 443 should be open by default. | |
2181 | Internal | Zookeeper | N | /zookeeper/conf/zoo.cfg | DO NOT CHANGE. | Internal coordinator of High Availability (HA). Incoming and outgoing traffic goes through this port. Change this port only if you understand how Zookeeper interacts with Incorta. |
4040-4045 | Incoming/Outgoing | Job Detail Web ports | N/A | |||
4500 | Internal | Node Agent Port | Y | /nodeAgent/nodeAgent.cfg | Installed on each node to connect that node to the CMC | |
5442 | Internal | SQL Interface (SQLi) port | N | TMT/Cluster Management Console (CMC) | If the client (e.g., Tableau) exists on a remote server, this port must be open for remote access. | |
5436 | Incoming/ Outgoing | Incorta (memory) | N | TMT/Cluster Management Console (CMC) | If the client (e.g., Tableau) exists on a remote server, this port must be open for remote access. | |
8005 | Incoming/ Outgoing | Tomcat shutdown port | Y | /services/ <SERVICE_FOLDER>/conf | ||
8080 | Incoming/ Outgoing | Tomcat HTTP port | Y | server.xml | ||
8443 | Incoming/ Outgoing | HTTPS traffic, Tomcat HTTPS for SSL | Y | server.xml | ||
8009 | Incoming/ Outgoing | Tomcat AJP port | Y | server.xml | ||
6060 | Incoming/ Outgoing | HTTP Port | Y | catalina.properties | ||
6443 | Incoming/ Outgoing | HTTP/AJP redirect Port | Y | catalina.properties | ||
6005 | Incoming/ Outgoing | Server Port | Y | catalina.properties | ||
6009 | Incoming/ Outgoing | AJP Port | Y | catalina.properties | ||
7077 | Incoming/ Outgoing | Spark Master Port | N | Spark configuration | If Spark exists on a remote server, this port must be open for remote access. | |
7078 | Incoming/ Outgoing | Spark Worker Port | N | Spark configuration | If Spark exists on a remote server, this port must be open for remote access. | |
7777 | Incoming/ Outgoing | Accessed locally by the Incorta Analytics Server Phantom JS | N | /start-exportserver.sh | DO NOT CHANGE. | This port is currently hard-coded in the server. Any changes will break the send-dashboard-by-email feature. |
9091 | Incoming/ Outgoing | Spark Master Web UI Port | N | spark-env.sh | For Spark master, this port must be open for remote access to monitor the Spark jobs and logs. | |
9092 | Incoming/ Outgoing | Spark Worker Web UI Port | N | spark-env.sh | For Spark worker, this port must be open for remote access to monitor the Spark jobs and logs. | |
30000+ | Incoming/Outgoing | Job ports | N/A | Spark dynamically selects ports in the high range. See troubleshooting section for more information. |
Additional Considerations
- The Shutdown Port 8005 is the shutdown port for the Incorta Direct Data Platform, and it needs to be accessed by incoming and outgoing data. This port can be configured during the installation process, or changed in the
catalina.properties
file. - The HTTP Port 8080 can be configured during the installation process. If it is configured on the Incorta Direct Data Platform, then it should be made available at startup. You can change the value in the
catalina.properties
file. - The HTTPS Port 8443 can be configured during the installation process, or changed in the
server.xml
file. - The AJP Connector Port 8009 is the Apache Web Server port. It can be configured during the installation process, or changed in the
server.xml
file.