Finish Installing Incorta with the CMC

After you run the installation procedure on Incorta for a single-node or multi-node installation, log into the CMC to complete setting up nodes and services.

  1. Follow the prompts to set up your database. You must have your database information, including location, username, and password. If you don't have an SQL or Oracle database, you can use Derby (included). If you choose Derby, Incorta sets the database up for you. See Database Integration.
  2. Create one loader service. For multi-server installations, create a loader service on one server on which you installed Incorta, but not on the same one on which you created an analytics service. See Create a Loader Service.
  3. Create an analytics service on the server on which you installed Incorta. See Create an Analytics Service.
  4. Create a cluster. See Create a Cluster.
  5. Create a tenant. See Create a Tenant.

Database Integration

When you log into the CMC for the first time on a node, you are prompted to enter information about your database.

Oracle Database

  • Ensure that the DML user can connect to the database and that the DDL user has the required privileges.
  • Ensure that the database port is open and accessible through the IP address.
  • In rst-node installations, the DDL user must have an empty database with no tables.
  • (Optional) Provide a second username and password for a DDL user.

Parameters in the CMC:

  • Database Type = Oracle
  • JDBC URL = format: jdbc:oracle:thin:@<HOST>:<PORT>:<SID>
  • User name = <ORACLE_USER_NAME>
  • Password = <ORACLE_USER_PASSWORD>

MySQL Database

  • Keep the default value for the database management system.
  • The database port must be open and accessible using the IP address.
  • Your MySQL database must be empty, with no tables.

Parameters in the CMC:

  • Database Type = MYSQL
  • JDBC URL = jdbc:mysql://<DB_IP>:<DB_PORT>/ <DATABASE_NAME>?useUnicode=yes&characterEncoding=UTF-8
  • User name = <MYSQL_USER_NAME>
  • Password = <MYSQL_USER_PASSWORD>
  • System administrator information:
    • Username = <ADMINISTRATOR_USER_NAME>
    • Password = <ADMINISTRATOR_PASSWORD>
    • Email = <ADMINISTRATOR_EMAIL>
    • Path = <PATH>
  • Zookeeper URL = <IP_ADDRESS>:<PORT>. Separate zookeeper node URLs with a comma. For example: (172.18.0.3:2181,172.18.0.4:2181,172.18.0.5:2181)

Integrate with Spark

When you choose a database or set up a node or cluster, you must complete information about your Spark integration. The following are the parameters you complete.

When you choose None, you choose to not install any version of Spark. You can install Incorta without Spark, but it is not recommended.

Choose to use the Bundled version of Spark to install the included version of Spark with Incorta.

  • Worker memory. Total memory for the Spark service.
  • App memory. Provide the maximum memory used by SQLi Spark queries, leaving enough memory if you plan to use materialized views. The memory required for both applications combined cannot exceed the worker memory.
  • App Cores. The dedicated CPU cores reserved for the SQLi Spark application. Ensure that there are enough cores for the OS, other services, and applications.
  • App Executers. The number of parallel processes reserved for the SQLi Spark application.
  • DS Port. 5442 default. The port number that will be used to connect to the Incorta Data Store.

Choose External to use a version of Spark you already have.

  • Master URL. The URL for the Master Spark UI.
  • App memory. Provide the maximum memory used by SQLi Spark queries, leaving enough memory if you plan to use materialized views. The memory required for both applications combined cannot exceed the worker memory.
  • App Cores. The dedicated CPU cores reserved for the SQLi Spark application. Ensure that there are enough cores for the OS, other services, and applications.
  • App Executers. The number of parallel processes reserved for the SQLi Spark application.
  • DS Port. 5442 default. The port number that will be used to connect to the Incorta Data Store.

For more information on how to use Spark with Incorta, see the Spark Guide.

Create a Loader Service

  1. Navigate to the Nodes tab.
  2. Select a node to use for the Loader Service.
  3. Select + to add a service.
  4. Enter the loader service information.
    • Service Name = loader1 or choose any unique name
    • Type = Loader
    • Heap Size = Amount of memory in kilobytes this Java Virtual Machine (JVM) uses, for example 2048.
  5. Select Check to verify the name.
  6. Select Next.
  7. Enter the additional settings or accept the defaults:
    • ICC port: The inter-cluster communication port to use for communication between cluster services. You must use different ports for services running on the same hardware.
    • Engine off heap: Enable so Incorta depends on machine memory instead of Java heap space.
    • Max engine off heap: Maximum off heap memory size to use for data loading. If loaded data is larger, removes the least-used columns in the table data.
  8. Select Create, then Finish to create the loader service.

Create an Analytics Service

  1. Navigate to the Nodes tab.
  2. Select a node to use for the Analytics Service.
  3. Select + to add a service.
  4. Enter the analytics service information
    • Service Name = <NAME>
    • Type = Analytics
    • Heap Size = Amount of memory in kilobytes this Java Virtual Machine (JVM) uses, for example 2048.
  5. Select Check to verify the name.
  6. Select Next.
  7. Enter the additional settings or accept the defaults:
    • ICC port: The inter-cluster communication port to use for communication between cluster services. You must use different ports for services running on the same hardware.
    • Engine off heap: Enable so Incorta depends on machine memory instead of Java heap space.
    • Max engine off heap: Maximum off heap memory size to use for data loading. If loaded data is larger, removes the least-used columns in the table data.
  8. Select Create, then Finish to create the analytics service.

Create a Cluster

  1. Go to the Clusters tab
  2. Select + to add a new cluster
  3. Set the Cluster Name.
  4. Follow the prompts to create the cluster.

Create a Tenant

  1. Select +.
  2. Enter the tenant information
    • Name = <TENANT_NAME>
    • Username = <ADMINISTRATOR_USER_NAME>
    • Password = <ADMINISTRATOR_PASSWORD>
    • Email = <ADMINISTRATOR_EMAIL>
    • Path = <PATH>
    • Choose include Sample Data
  3. Select Next
  4. Enter the email information
    • Sender’s email = a@c.com
    • Sender’s Password = dummy
    • Keep the default for the rest of the parameters
  5. Select Create.
  6. Select Finish. Verify the tenant is created. You do not need to restart servers.

Incorta URL: http://<server>:<port>/incorta/