Connecting to Sisense ElastiCubes
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:
- 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.
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:
- In the Data page, open an ElastiCube or click to create a new ElastiCube.
- In the Model Editor, click . The Add Data dialog box is displayed.
- Click Sisense ElastiCube. The Sisense ElastiCube area is displayed.
- 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.
- In User Name, enter your Sisense user name.
- In Password, enter your Sisense password.
- Click Next. A list of tables in the ElastiCube are displayed. All tables associated with the ElastiCube will appear in a new window.
- 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.
- (Optional) Click + to customize the data you want to import with SQL. See Importing Data with Custom Queries for more information.
- After you have selected all the relevant tables, click Done. The tables are added to your data model.
- The connector does not import relationships between tables