Connect to Tableau Desktop

Kyligence supports integration with Tableau. This section will show you how to achieve that with model tds file.

Prerequisites

1. Install Tableau Desktop. For more information, see Tableau Desktop Download.

2. Visit the Kyligence Download Center. In the Drivers & Add-ons section, download:

   • Kyligence ODBC Driver

     Download the Kyligence ODBC Driver based on your operation system, double-click and follow the instructions to install.

     [!Note]

     MacOS system may prevent installation. In order to continue installing, click System Preferences -> Security & Privacy -> General, click the Open Anyway button, and enter your password.

   • Tableau Connector for Kyligence

     Download the Tableau Connector for Kyligence, copy it to the Tableau Desktop installation directory as below and then restart Tableau Desktop.

     Windows: My Documents/My Tableau Repository/Connectors
     macOS: ~/Documents/My Tableau Repository/Connectors
     

Integrate with Tableau Desktop

1. In the left navigation of Kyligence, click Model. In the Model List, select the ssb model to be analyzed, click the icon, and then choose Export TDS.

   

2. In the pop-up dialog box, select to include all columns and Tableau Kyligence Connector, then click Export.

   

3. Double-click the exported tds file, which will automatically open Tableau Desktop. Log into Tableau using your Kyligence account.

   [!Note]

   You can also find Kyligence account information on the test drive page by clicking BI tools -> Tableau.

   

4. Our Kyligence model will be synchronized to Tableau. You may check the imported dimensions and measures in Tableau. For the calculation formulas of the measures, see SSB sample dataset.

   

5. Now we are ready to analyze data with Tableau. You can drag and drop the fields to build your own view.

   For more details on the integration with Tableau, see Tableau.