Guides → Tenant Configurations

You can manage your tenant(s) through the Cluster Management Console (CMC) by configuring various settings, such as a minimum password length, default language, maximum cached memory, and other settings. Here are the steps to configure your tenant(s):

  • Sign in to the CMC.
  • Select Clusters > Cluster-name > Tenants.
  • Configure your tenants as follows:
    • To set an individual tenant configuration, for a tenant row, select Configure.
    • To set your default tenant(s) configurations, select Cluster Configurations > Default Tenant Configurations.

The following tenant configurations are available in the CMC:

Important

To avoid losing data after configuring your settings on a page, select Save before navigating to another page.

Security

The security configurations include the authentication types and other important settings within Incorta Analytics, such as enabling Super User mode, cross-origin access, and support for password-protected Excel files.

Authentication Type

Select your authentication type from the drop down list. The supported types are:

Incorta Authentication

The following table illustrates the configuration properties of the Incorta authentication:

Configuration PropertyControlRequires RestartDescription
Authentication Typedrop down listNoSelect Incorta Authentication to sign in to Incorta using the Incorta Analytics username and password. You can also configure password rules and other security-related options.
Allow Different Authentication Type for External ToolstoggleYes, all servicesEnable this property to authorize a different authentication type for external tools, and then select the authentication type from the External Tools Authentication Type drop down list.
Enable Super User ModetoggleNoEnable this property to enable non-Admin users with a Super User role to access all content within a tenant.
Disable this property to restrict content access for all non-Admin users and provide access to shared content only.
Enable Support for Password-Protected Excel FilestoggleNoEnable this property to support the upload of password-protected Excel files using the Data Manager.

Prerequisite: you must install Java Cryptography Extension (JCE) to use this feature.

Here are the steps to install JCE:
    •   Download and extract JCE from Oracle
    •   Copy the JCE jars (local\_policy.jar and US\_export\_policy.jar ) into $JAVA\_HOME/jre/lib/security
    •   Restart Incorta CMC.
Minimum Password Lengthspin boxNoEnter the minimum number of characters for a password. The Default is 5 characters.
Password Cannot Include UsernametoggleNoEnable this property to restrict use of a username in passwords.
Require Lower Case LetterstoggleNoEnable this property to require lower-case letters in passwords.
Require Upper Case LetterstoggleNoEnable this property to require upper-case letters in passwords.
Require DigitstoggleNoEnable this property to require numbers in passwords
Require Special CharacterstoggleNoEnable this property to require special characters in passwords.
Enable Cross-Origin AccesstoggleYes, Analytics Service onlyEnable external websites to host Incorta dashboard(s) in an iFrame.
Enabling this property mandates that Incorta is accessed through a Secure Sockets Layer (SSL) connection (HTTPS).

Single Sign-On

The following table illustrates the configuration properties of the Single Sign-On (SSO) authentication:

Configuration PropertyControlRequires RestartDescription
Authentication Typedrop down listYes, if there are changes in the 'server.xml' fileSelect SSO to sign in to Incorta using a standard SSO tool. This requires enabling Allow Different Authentication Type for External Tools.
For more information, refer to Guides → Configure SSO.
Provider typedrop down listNoSelect your provider type. The options are:
    •   SAML2
    •   Okta
    •   Auth0
    •   Custom (requires entering the name of the custom provider for a specific customer)
Provider configurationstext boxNoEnter the properties or XML configurations for your selected provider.
Auto provision SSO userstoggleNoEnable this property to automatically add all SSO users to Incorta after successful authentication.
Auto provisioned SSO users default groupdrop down listNoSelect the newly provisioned SSO users to be assigned to this group.
Allow Different Authentication Type for External ToolstoggleYes, all servicesEnable this property to authorize a different authentication type for external tools, and then select the authentication type from the External Tools Authentication Type drop down list.
Enable Super User ModetoggleNoEnable this property to enable non-Admin users with a Super User role to access all content within a tenant. Disable this property to restrict content access for all non-Admin users and provide access to shared content only.
Enable Support for Password-Protected Excel FilestoggleNoEnable this property to support the upload of password-protected Excel files using the Data Manager.

Prerequisite: you must install Java Cryptography Extension (JCE) to use this feature.

Here are the steps to install JCE:
    •   Download and extract JCE from Oracle
    •   Copy the JCE jars (local\_policy.jar and US\_export\_policy.jar) into $JAVA\_HOME/jre/lib/security Restart Incorta CMC.
Enable Cross-Origin AccesstoggleYes, Analytics Service onlyEnable external websites to host Incorta dashboard(s) in an iFrame.
Enabling this property mandates that Incorta is accessed through an SSL connection (HTTPS).

Lightweight Directory Access Protocol

The following table illustrates the configuration properties of the Lightweight Directory Access Protocol (LDAP) authentication:

Configuration PropertyControlRequires RestartDescription
Authentication Typedrop down listNoSelect LDAP to sign in to Incorta using the LDAP system user and password.
Base Provider URLtext boxYes, all servicesEnter a URL to access the LDAP server in the following format: ldap://<LDAP_SERVER_HOST>:<LDAP_SERVER_PORT>
Base Distinguished Nametext boxYes, all servicesEnter a name attribute to describe the location where the LDAP search should begin.
System Usertext boxYes, all servicesEnter the LDAP System User attribute. If searching your LDAP server does not require authentication, do not set this property.
System User Passwordtext boxYes, all servicesEnter the password for the LDAP System User.
User Mapping Logintext boxYes, all servicesEnter the attribute in LDAP that can be used to sign in to Incorta Analytics. This is the name of the column that contains a unique identifier for users in LDAP, such as an email or ID.
User Mapping Authenticationtext boxYes, all servicesOptionally, enter an attribute to authenticate users.
If no attribute is entered, the value entered for User Mapping Login will be used to authenticate users.
Allow Different Authentication Type for External ToolstoggleYes, all servicesEnable this property to authorize a different authentication type for external tools, and then select the authentication type from the External Tools Authentication Type drop down list.
Enable Super User ModetoggleNoEnable this property to enable non-Admin users with a Super User role to access all content within a tenant.
Disable this property to restrict content access for all non-Admin users and provide access to shared content only.
Enable Support for Password-Protected Excel FilestoggleNoEnable this property to support the upload of password-protected Excel files using the Data Manager.

Prerequisite: you must install Java Cryptography Extension (JCE) to use this feature.

Here are the steps to install JCE:
    •   Download and extract JCE from Oracle
    •   Copy the JCE jars (local\_policy.jar and US\_export\_policy.jar) into $JAVA\_HOME/jre/lib/security
    •   Restart Incorta CMC.
Enable Cross-Origin AccesstoggleYes, Analytics Service onlyEnable external websites to host Incorta dashboard(s) in an iFrame.
Enabling this property mandates that Incorta is accessed through an SSL connection (HTTPS).

Azure Active Directory

The following table illustrates the configuration properties of the Azure Active Directory (AD) authentication:

Configuration PropertyControlRequires RestartDescription
Authentication Typedrop down listNoSelect Azure AD to sign in to Incorta using the Client ID and Client Secret.

For more information on how to obtain the Azure AD Client ID and Client Secret, refer to Quickstart: Register an app in the Microsoft identity platform.
Client IDtext boxNoEnter the Application (Client) ID for the App registration defined on the Azure AD.
Client Secrettext boxNoEnter the Client Secret value (application password) that is defined for the Client ID on the Azure AD.
Allow Different Authentication Type for External ToolstoggleYes, all servicesEnable this property to authorize an authentication type for external tools, and then select the authentication type from the External Tools Authentication Type drop down list.
Enable Super User ModetoggleNoEnable this property to enable non-Admin users with a Super User role to access all content within a tenant.
Disable this property to restrict content access for all non-Admin users and provide access to shared content only.
Enable Support for Password-Protected Excel FilestoggleNoEnable this property to support the upload of password-protected Excel files using the Data Manager.

Prerequisite: you must install Java Cryptography Extension (JCE) to use this feature.

Here are the steps to install JCE:
    •   Download and extract JCE from Oracle
    •   Copy the JCE jars (local\_policy.jar and US\_export\_policy.jar) into $JAVA_HOME/jre/lib/security
    •   Restart Incorta CMC.
Enable Cross-Origin AccesstoggleYes, Analytics Service onlyEnable external websites to host Incorta dashboard(s) in an iFrame.
Enabling this property mandates that Incorta is accessed through an SSL connection (HTTPS).

Regional Settings

The following table illustrates the configuration properties of the regional settings:

Configuration PropertyControlRequires RestartDescription
Languagedrop down listNoSelect the default language for your tenant using the ISO two-letter codes. For example, fr stands for the French language.
Countrydrop down listNoSelect the default country for your tenant.
Text Directiondrop down listNoSelect the text direction for your tenant:
    •   Left to right
    •   Right to left

Email

The following table illustrates the configuration properties of the tenant email:

Configuration PropertyControlRequires RestartDescription
SMTP Hosttext boxNoEnter the server used to send emails. For example, smtp.gmail.com.
Enable SMTP SSLtoggleNoEnable this property to establish a port for Simple Mail Transfer Protocol Secure (SMTP) to operate using SSL.
Socket Factory Portspin boxNoEnter the port number used for connection when using an SMTP Socket Factory.
Email Host Requires AuthenticationtoggleNoEnable this property if the email host, such as Gmail, requires authentication before sending an email.
SMTP Server Portspin boxNoEnter the port number to use for connecting to the email server.
Email Server Protocoldrop down listNoSelect an email protocol:
    •   smtp
    •   ews
Export Server Timeout in Secondsspin boxNoEnter the required server timeout in seconds when sending an HTML dashboard.
If a dashboard is not sent due to a server timeout, you can increase this value to resolve the issue.
Sender's Username AuthtoggleNoEnable this property to use a username for the SMTP authentication instead of the sender's email.
System Email Addresstext boxNoEnter the email address to use for sending dashboards or notifications.
Person Nametext boxNoEnter the name to display as the email sender.
System Email Passwordtext boxNoOptionally, enter the password for the email address used for sending dashboards or notifications.
Leave this field blank if the email server does not require a password for the sender’s email.
Forgot Password Email Subjecttext boxNoEnter the text to display in the subject line of password recovery emails.
Server URL Protocoldrop down listNoSelect the server url protocol:
    •   http
    •   https
Server Nametext boxNoEnter the current server name, for example, localhost.
Server Portspin boxNoEnter the current server port, for example, 8080.
Enable NotificationstoggleNoEnable this property to send email notifications when sharing dashboards.
Notification Email Subjecttext boxNoEnter the subject line of a sharing notification email.
Enable Internal Error NotificationstoggleNoEnable this property to be notified of the internal error(s) by email.
Internal Error Notification Subjecttext boxNoEnter the subject line of the internal error notification emails.

Data Loading

The following table illustrates the configuration properties related to data loading:

Configuration PropertyControlRequires RestartDescription
Enable Always CompacttoggleNoEnable this property to trigger automatic compaction during schema load.

Note the following:
    •   To compact a preloaded schema, either restart the server, or reload the schema (full or incremental).
    •   This property must be enabled if SQLi is enabled.
Stop Loading on First ErrortoggleNoEnable this property to stop a schema extraction or loading on the first encountered error.
Pause Scheduled JobstoggleNoEnable this property to pause all the active schedule jobs including schema loads, dashboards, and data alerts.

Integration

The following table illustrates the integration configuration properties:

Configuration PropertyControlRequires RestartDescription
Google Maps API Keytext boxNoEnter the API key for Google Maps.
Apple Maps Developer Team IDtext boxNoEnter the Developer team ID to use for enabling Apple Maps in Incorta’s maps visualizations.
Apple MapKit JS Key IDtext boxNoEnter the Apple MapKit JS key to use for enabling Apple Maps in Incorta’s maps visualizations.
Apple Maps API Keytext boxNoEnter the Apple Maps API key to use for enabling Apple Maps in Incorta’s maps visualizations.
Google Drive Client IDtext boxYes, all servicesEnter the Google Drive Client ID used by the Google Drive connector.
Google Drive Client Secrettext boxYes, all servicesEnter the Google Drive Client Secret used by the Google Drive connector.
Dropbox App Keytext boxYes, all servicesEnter the Dropbox App Key used by the Dropbox connector.
Dropbox App Secrettext boxYes, all servicesEnter the Dropbox App Secret used by the Dropbox connector.
Box Client IDtext boxYes, all servicesEnter the Box Client ID obtained from the Box application.
Box Client Secrettext boxYes, all servicesEnter the Box Client Secret obtained from the Box application.
Mapbox API Keytext boxNoEnter the Mapbox API Key of the Advanced Mapbox.

Export

The following table illustrates the configuration properties related to exporting Insights:

Configuration PropertyControlRequires RestartDescription
Export All DatatoggleNoEnable this property to export or download all data from Listing or Aggregated tables.
Export All Data (Pivot Tables)toggleNoEnable this property to export or download all data from Pivot tables.
Download Rows Limitspin boxYesEnter the maximum number of rows to download or export a table Insight.
Add BOM to CSVtoggleNoEnable this property to add a Byte Order Mark (BOM) to CSV files.
This property must be enabled to export Unicode-encoded files.
Include Prompt Selections in Excel ExporttoggleNoEnable this property to add the applied prompt filters to the first line in an exported or downloaded Excel file.
Export FolderuploadNoSelect + Add Folder to enter the destination folder’s name and path on the Incorta host server to use for sending or scheduling a dashboard.

Advanced

The following table illustrates the advanced configuration properties related to materialized views (MVs) and the maximum groups default and limit in insights.

Configuration PropertyControlRequires RestartDescription
Enable Hive Context in MVstoggleNoEnable this property to support Hive context in MVs.
Python Pathtext boxNoEnter the Python binary executable to use for Python MVs in the driver and executors.
Insight Max Groups UI Defaultspin boxNoEnter the default maximum number of groups that cannot be exceeded in an insight.

You can also configure this property for an insight in the Settings panel of the Analyzer. The value in the insight overrides the value configured in the CMC.
Insight Max Groups Limitspin boxNoEnter the limit for the maximum number of groups that cannot be exceeded in an insight.

Entering the values 0 or -1 will set the number of groups to unlimited. This value cannot be overridden.
Insight Max Values in Filter Subqueryspin boxNoEnter the maximum values for an insight in the filter subquery.
Force Reload ColumnstoggleYes, Analytics Service onlyEnable this property to automatically reload the data in memory after a schema load. For example, after an incremental update.

If disabled, data will only be reloaded when accessing a dashboard that queries such data, which may impact the performance and cause a delayed response.
Sync in BackgroundtoggleYes, Analytics Service onlyEnable this property to synchronize your data in the background during a schema load by reading columns in separate memory on the Analytics service.
Warmup Mode on Analytics Servicesdrop down listNoSelect an option to load and warmup specific columns first on the Analytics service. This decreases the time to load dashboard queries. The options are:
    •   None - works best for small deployments with ad-hoc queries.
    •   Last Used Columns - load the previous state prior to shut down in the Analytics service.
    •   Business View Columns - load all columns referenced in business schema views on the Analytics service only.
    •   Most Used Dashboards Columns - load the most used dashboards columns first.
    •   All - works best for supporting ad-hoc queries, in case no business schemas are in place, and the time between the Analytics service startup and dashboard usage is significant.
Warmup Mode on Loader Servicesdrop down listNoSelect an option to load and warmup specific columns first on the Loader service. The options are:
    •   None - works best for small deployments with ad-hoc queries.
    •   Last Used Columns - load the previous state prior to shut down in the Loader service.
    •   All - works best for supporting ad-hoc queries.
Turn off/on Global Auto Refresh for InsightstoggleNoEnable this property to turn on Auto Refresh by default for all insights.

You can turn off Auto Refresh to allow the Analyzer Users to turn on Auto Refresh for individual insights.

Tuning

The following table illustrates the tuning configuration properties:

Configuration PropertyControlRequires RestartDescription
Schema Pool Sizedrop down listYes, Loader Service onlySelect the number of schemas (up to 10) that can be loaded at a time per tenant. The default value is 5.
Table Maximum Parallel Chunksdrop down listYesSelect the number of concurrent chunks (between -1 and 10) that you can extract from the source at the same time.
Maximum Cached Entriesspin boxYes, Analytics Service onlyEnter the maximum number of insights or MVs to store in the cache. The default value is 2000. Caching an insight larger than 10MB may affect performance.

Incorta uses both the Maximum Cached Entries and the Maximum Cached Memory (%) properties to determine the cache size, and then uses the lower of the two limits.

For example, if you set off-heap memory to 100GB, and Maximum Cached Memory (%) to 1%, the cache size will be 1GB. Therefore, if you set Maximum Cached Entries to 2000 and you reach 1GB with fewer reports, Incorta will stop caching reports at 1GB.
Maximum Cached Memory (%)spin boxYes, Analytics Service onlyEnter a percentage between 0% and 10% of the total off-heap memory to use as the maximum memory size for cached reports. The default is 5% of the off-heap memory.
Evaluate Session Variables At LogintoggleYesEnable this property to evaluate all session variables on a separate thread at session login. This allows you to evaluate several session variables used in different insights on a single dashboard.

Incorta Labs

Note

An Incorta Labs feature is experimental and can be either promoted to a product feature or deprecated without notice.

The following table illustrates the configuration properties of Incorta Labs:

Configuration PropertyControlRequires RestartDescription
Start Engine on a background threadtoggleNoEnable this property to start the engine on a background thread.
Enable saving query plantoggleNoEnable this property to keep the join paths of your insights fixed.

If a change in a data model causes an invalid join path, the affected insights will remain the same unless their owners approve to update them.
Incorta-AssisttoggleNoEnable this property to have a bot assist you by suggesting and creating joins in a matter of minutes.
Enable Insight 'View As' MenutoggleNoEnable this property to show the View As menu in all the Dashboard Insight action menus.
Enable Incorta SQL TabletoggleNoEnable this property to create an Incorta SQL Table.

The Incorta SQL Table will use a new SQL Engine that supports all types of joins and provides better SQL coverage. The new SQL engine will query from data loaded in the memory.
Machine Learning supporttoggleYes, Analytics Service onlyEnable this property to have machine learning support.
Maximum number of versions per entityspin boxNoEnter the maximum number of versions to maintain for each entity, such as a schema or dashboard. The default value is 50.
Backup frequencydrop down listNoSelect the cadence to create versions for each entity. This can range from a record of each change to a weekly backup. The options are:
    •   Keep all versions
    •   5, 10, 15, or 30 minutes
    •   1, 2, 4, 6, or 12 hours
    •   1 Day
    •   1 Week
Notebook IntegrationtoggleNoEnable this property to integrate the notebook.
Notebook is not currently supported on Windows environments.
Enable Dynamic Allocation in NotebooktoggleNoEnable this property to use dynamic allocation by default in all notebooks.

Disabling this property will cause notebook sessions to allocate the full resource of the materialized views in their interactive session. Thus, it is recommended to enable this property to avoid consuming Spark cluster resources by the notebook sessions.

External Visualization Tools

The following table illustrates the configuration properties related to the external visualization business tools:

Configuration PropertyControlRequires RestartDescription
Default Schemastext boxNoEnter the list of default schemas, separated by commas, to be processed in order when a non-fully qualified table is encountered in an SQL query from an external BI tool.
Incorta Hosttext boxNoEnter the IP address of the Incorta Server (or Proxy or Load Balancer, if applicable) to use for connecting the external BI tools to Incorta.
Incorta Portspin boxNoEnter the port number of the Incorta Server (or Proxy or Load Balancer, if applicable) to use for connecting the external BI tools to Incorta.
Excel AddintoggleNoEnable this property to see instructions on how to connect Excel as an external BI tool to Incorta.
MicroStrategytoggleNoEnable this property to see instructions on how to connect MicroStrategy as an external BI tool to Incorta.
TableautoggleNoEnable this property to see instructions on how to connect Tableau as an external BI tool to Incorta.
PowerBItoggleNoEnable this property to see instructions on how to connect PowerBI as an external BI tool to Incorta.