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:
- Separating custom SQL logic that is used for heavy data transformation from the main ElastiCube for easier management and shorter build times.
- Combining tables that are based on different refresh schedules. As every ElastiCube has its own build schedule, it is possible to import a table from an ElastiCube that doesn’t refresh as often.
This page describes how to connect to your Sisense ElastiCubes through both methods:
- Sisense ElastiCube Connector
- ODBC Driver
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:
- Sisense, click Add Data and then, Ecube Database. The Connect to ElastiCube window is displayed.
- 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.
- In the User Name and Password fields, enter your Sisense credentials that you use when logging into Sisense.
- Click Connect to Server. The running ElastiCubes at the location you defined are displayed in the Select (Running) ECube list.
- Select the relevant ElastiCube. The Add table from ElastiCube Tables is displayed.
- 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
- Download and install the Sisense ODBC Driver as described here.
- Sisense, click Add Data and then, Generic ODBC Driver.
- 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:
- Click Add DSN.
- Select the System Data Source option. The created file will apply to all users in a specific machine only. Click Next.
- Select the Sisense ODBC Driver and click Next.
- Click Finish.
- In the New Sisense Data Source window, do the following:
Field Procedure Data Source Name Enter your name for the DSN that is to be displayed in the DSN dropdown list. Description Enter your description of the DSN. Server Enter the IP address of your ElastiCube server. Use secure connection (SSL) Select to enable a secure SSL connection. ElastiCube
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.
- Click Test. A pop window is displayed that indicates the connection was successful.
- Click OK.
- In the ODBC Connectivity Properties window, click Test Connection.
- Click OK to save and close the ODBC Connectivity Properties window.
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:
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:
- Connect to your ElastiCube tables via the Sisense ODBC Tool.
- Add your data source.
- In the Add table from ElastiCube Tables window, select the table you want to add to Sisense.
- Click Add. The selected tables are added to Sisense.
- When connecting to an ElastiCube that is part of a multi-node environment, the connection may take longer than expected