Connecting to Sisense ElastiCubes

Applicable to Sisense on Linux and Microsoft Windows

ElastiCubes can also be connected to as 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:

The native Sisense ElastiCube connector enables you to import data from other running ElastiCubes. 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 the Sisense Admin page.

To import data from other ElastiCube:

  1. In the Data page, open an ElastiCube or click to create a new ElastiCube.
  2. In the Model Editor, click . The Add Data dialog box is displayed.
  3. Click Sisense ElastiCube. The Sisense ElastiCube area is displayed.
  4. In Location, if you are connecting to a local ElastiCube, enter localhost. If you are connecting to an ElastiCube that is part of a multi-node deployment, enter the address and port of the remote server to connect to.
  5. In User Name, enter your Sisense user name.
  6. In Password, enter your Sisense password.
  7. Click Next. A list of tables in the ElastiCube are displayed. All tables associated with the ElastiCube will appear in a new window.
  8. From the Tables list, select the relevant table you want to work with. You can click Next to the relevant table or click Preview to see a preview of the data inside it.
  9. (Optional) Click + to customize the data you want to import with SQL. See Importing Data with Custom Queries for more information.
  10. After you have selected all the relevant tables, click Done. The tables are added to your data model.

Limitations