Skip to main content

Sisense

Connecting Sisense to Timbr​

  1. Open Sisense

  2. Select Live as the connection type under "Connect and Model Data."

connect

  1. On the Data page, click + Live in the top-right corner to create a new Live model.

new model

  1. Name your model and click Save.

name model

  1. Click + Data in the top-right corner of the empty model to add a data source.

add datasource

  1. In the connection window, scroll down to "Create New Connection" and select Databricks.

choose databricks

  1. Fill in the connection details as follows:

Connection Name:

  • Enter a name of your choice.

Connection String:

  • Enter the JDBC connection string for your Timbr instance. Replace the hostname and ontology name with your own values:

jdbc:databricks://<hostname>:443/default;transportMode=http;ssl=1;AuthMech=3;httpPath=/sql/protocolv1/o/databricks/ontology/<ontology_name>;

Password - Timbr User Access Token:

  • To get your token, open your Timbr instance and click Copy user access token on the welcome page. Paste the token into the Password field.

show token

  1. Click Save, then Continue.

save model

  1. Select your tables. You will see all the tables available in your Timbr ontology.
Notice

Make sure to select from the dtimbr schema. This is the schema that contains all of Timbr's concept relationships and measures. Once selected, click Done.

choose tables

  1. Click Publish in the top-right corner to make the model available for dashboards.

publish model

  1. You’re ready to use the concepts and their relationships as virtual tables for your reports and dashboards!