cancel
Showing results for 
Search instead for 
Did you mean: 
Community_Admin
Community Team Member
Community Team Member

Question

The purpose of this post is to demonstrate how to connect to a Sisense ElastiCube from Microsoft Excel.

Answer

Begin by installing the Sisense ODBC driver.

https://documentation.sisense.com/latest/odbc.htm

Once it is installed, go to ODBC-64 bit from the windows search (just search odbc and it will pop up), then go to the system tab and add a new connection.

Community_Admin_0-1634391787674.png

Then choose the Sisense ODBC Driver.

Community_Admin_1-1634391787798.png

Add a name and a description and then click on the empty box for ElastiCube names. This will prompt you for a Sisense login. If working on the same server as Sisense, the server will be localhost:8081. The username and password corresponds to your login in Sisense. Note: If you receive a licensing error, please reach out to your Customer Success Representative.

Community_Admin_2-1634391787814.png

Finally, select an ElastiCube and save the connection. Now you are ready to connect to the ElastiCube from Excel.

Now open a new workbook in Excel. Select the Data tab> Get Data> From Other Sources > ODBC.

Community_Admin_3-1634391787833.png

You will be prompted to either select an existing connection or enter a connection string. Select the connection and continue.

Community_Admin_4-1634391787726.png

You may be prompted for credentials. However, because the connection already contains them, they are irrelevant at this stage. You can enter a random value and click continue if it will not let you continue with an empty box.

Once the connection is established, you should see all tables available in the ElastiCube. Please note you can not see hidden fields from the ODBC connection.

Community_Admin_5-1634391787855.png

In the case above, I have selected the Admissions table and loaded it into Excel.

Community_Admin_6-1634391787924.png

From this point you should have a populated table with the ability to refresh. You can append the query to join two tables together and customize the query. Please refer to the documentation for Excel Power Query.

Version history
Last update:
‎10-16-2021 06:44 AM
Updated by:
Contributors
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Need additional support?:

Community Support Request