Tableau
Connecting Tableau to the Timbr Knowledge Graph
- Open Tableau
In the main window under Connect go to the To a Server list and click on More...
In the search box above type Spark and select the Spark SQL connector.
Please make sure to download and install the latest ODBC driver from here: https://www.databricks.com/spark/odbc-drivers-download
- Fill in the following details:
Connection: SparkThriftServer (Spark 1.1 and later)
Server: timbr-server IP or HOSTNAME
Port: timbr-server port (default 11000)
Authentication: Username and Password
Username: token@\<ontology_name>
Password: \<user_token>
Transport: HTTP
HTTP Path: Leave empty (when routing is enabled the path should be hive2 or timbr-server)
Require SSL: false by default, true If SSL is enabled (using gateway or load-balancer)
- Loading Schemas & Tables:
Option #1 - Loading from a specific concept:
Once the connection is successful, click on Select Schema and write the schema you want to load (timbr/dtimbr/vtimbr).
After that click add (+) - make sure the Exact option is selected.
Once the Table option appears click on the magnifying glass search icon.
Once found, either click on Load or in some cases the concept list will appear automatically.
Once loaded, drag the concept you want to visualize and go to the Sheet 1 button (on the bottom-left side) to start visualizing.
Option #2 - Using a Custom SQL query:
After loading the desired schema, click on New Custom SQL.
Enter the custom query:
Click on OK and go to worksheet to visualize the results.
Congrats! You're ready to use the concepts and their relationships for your visualizations!