Connecting to Sisense ElastiCubes

ElastiCubes can also be connected to a data source using the Sisense ElastiCube connector or the Sisense ODBC, allowing you to import tables across different ElastiCubes. This can be useful for several use cases, such as:

This page describes how to connect to your Sisense ElastiCubes through both methods:

Sisense ElastiCube Connector

The native Sisense ElastiCube Connector enables you to import data from other running ElastiCubes and provides faster performance over the Sisense ODBC. The Sisense ElastiCube Connector does not support SSL connections, however, you can import ElastiCube through SSL connections via the ODBC driver described below.

Note: The first time you connect to an ElastiCube, the ElastiCube must be running. For subsequent connections, the connector automatically activates the ElastiCube. You can verify and activate your ElastiCubes from the Sisense Server Console in Sisense Admin.

To import data from ElastiCubes:

  1. Sisense, click Add Data and then, Ecube Database. The Connect to ElastiCube window is displayed.
  2. From the Database server location list, enter the address of your ElastiCube. If your ElastiCube is hosted locally, the address is localhost:8081, unless you have changed your port in which case, the address will be localhost:(XXXX) where X is the port you defined. If your ElastiCube is hosted on a remote server, the address is the IP address followed by the port (XX.XX.XX.XX:port). For remote connections, open the Sisense Server Console and click to display the remote ElastiCube’s IP address.
    If you have previously entered the address, select the relevant address.
  3. In the User Name and Password fields, enter your Sisense credentials that you use when logging into Sisense.
  4. Click Connect to Server. The running ElastiCubes at the location you defined are displayed in the Select (Running) ECube list.
  5. Select the relevant ElastiCube. The Add table from ElastiCube Tables is displayed.
  6. Select the relevant tables to import and click Add. The tables are displayed in Sisense.

Sisense ODBC Driver

The following topics explain how you can import ElastiCube data from another ElastiCube.

Downloading and Connecting the Sisense ODBC Driver

  1. Download and install the Sisense ODBC Driver as described here.
  2. Sisense, click Add Data and then, Generic ODBC Driver.
  3. Select DSN. If a DSN file has already been created, select it in the dropdown list, and click Test Connection. If you need to add a DSN, see Adding a DSN. If your connection has been set up, you can click OK and review the tables generated by the Sisense ODBC driver.

Adding a DSN

If a DSN has not yet been created, you must add the DSN manually.

Note: To add a DSN you must run the Sisense ElastiCube Manager as an administrator.

To add a DSN:

  1. Click Add DSN.
  2. Select the System Data Source option. The created file will apply to all users in a specific machine only. Click Next.
  3. Select the Sisense ODBC Driver and click Next.
  4. Click Finish.
  5. In the New Sisense Data Source window, do the following:
    Data Source NameEnter your name for the DSN that is to be displayed in the DSN dropdown list.
    DescriptionEnter your description of the DSN.
    ServerEnter the IP address of your ElastiCube server.
    Use secure connection (SSL)Select to enable a secure SSL connection.

    Select the ElastiCube you want to export.


    If this is your first time configuring a DSN for the Sisense ODBC, click the ElastiCube list. The Login to Sisense window is displayed.

    Enter your credentials and click OK. Wait several seconds while Sisense returns a list of your ElastiCubes.

    After the list is displayed in the ElastiCube list, select the ElastiCube you want to import

    Log(Optional) To configure logging behavior for the driver, click Logging Options. For more information, see Logging Options.
  6. Click Test. A pop window is displayed that indicates the connection was successful.
  7. Click OK.
  8. In the ODBC Connectivity Properties window, click Test Connection.
  9. Click OK to save and close the ODBC Connectivity Properties window.

Logging Options

You can configure logging options by clicking Log in the New Sisense Data Source window. This displays the Logging Options window.

The Sisense ODBC driver provides tracing functionality, which you can activate to help troubleshoot issues.

Important: Only enable logging long enough to capture an issue. Logging decreases performance

and can consume a large quantity of disk space.

The driver allows you to set the amount of detail included in log files. The table below lists the logging levels provided by the Sisense ODBC Driver, in order from least verbose to most verbose.

In the Logging Options window, you can configure the following information:

Field Description
Log Level

Select the Log Level. There are seven possible options:

LOG_OFF: Disables all logging.

LOG_FATAL: Logs very severe error events that lead the driver to abort.

LOG_ERROR: Logs error events that might still allow the driver to continue running.

LOG_WARNING:Logs potentially harmful situations.

LOG_INFO: Logs general information that describes the progress of the driver.

LOG_DEBUG: Logs detailed information that is useful for debugging the driver.

LOG_TRACE: Logs more detailed information than the DEBUG level.

Log Path Enter the full path to the folder where you want to save log files.
Click Browse and select the folder where you want to save log files.
Log Namespace Enter the filename for your log.
Max Number Files Enter the maximum number of logs that can be created before the oldest log files are overwritten by newer logs.
Max File Size (MB) Enter the maximum number of megabytes your log can reach before the log is overwritten by a newer log.

Adding ElastiCubes Tables to your Project

After setting up the DSN, the Add table from ElastiCube Tables window is displayed.

From this window, you add your ElastiCube tables to Sisense. In addition, you can view the SQL syntax in the Query Preview section and click Edit to customize it.

To add ElastiCube Tables to your Project:

  1. Connect to your ElastiCube tables via the Sisense ODBC Tool.
  2. Add your data source.
  3. In the Add table from ElastiCube Tables window, select the table you want to add to Sisense.
  4. Click Add. The selected tables are added to Sisense.