Kyligence Connector | Tableau Exchange

Kyligence Connector

by Kyligence

Description

Founded by the creators of Apache Kylin, Kyligence is on a mission to accelerate the productivity of its customers by automating data management, discovery, interaction and insight generation – all without barriers. Kyligence enables Tableau customers to scale their data with unmatched performance and seamless integration.

Tableau users can analyse petabytes of data on the big data platform with sub-second query latency, and can conduct multi-dimensional and ad-hoc queries using a live connection between Kyligence and Tableau.

Kyligence automatically syncs models with Tableau to avoid duplicated effort and human error and connects data sources on Hadoop platform and accelerates queries.

Installation

Configure the Kyligence Connector for Tableau Desktop

  1. Download and Install the Kyligence ODBC Driver
  2. Download Kyligence Connector file (.taco)
  3. Copy your packaged connector file (.taco) into your install directory:
  • macOS: ~/Documents/My Tableau Repository/Connectors
  • Windows: My Documents/My Tableau Repository/Connectors
  1. Restart Tableau Desktop
  2. Start Tableau and under Connect, select the Kyligence connector. (Note: You’ll be prompted if the driver is not yet installed.)

Configure the Kyligence Connector for Tableau Server

  1. Create a directory for Tableau connectors. This needs to be the same path on each machine. For example:/usr/local/tableau_connectors
  2. Copy Kyligence packaged connector file (.taco) into the folder your created
  3. Restart Tableau Server

Configure the delegation

Prerequisites for User Delegation

  1. You are using Tableau Desktop and Server 2019.4 and above.
  2. You are using Kyligence Enterprise 4.1.6 and above
  3. You have installed Kyligence ODBC Driver 3.1.9 and above.
  4. You have configured the Kyligence connector on your Tableau Desktop and Tableau Server machine.
  5. Ensure for each user, the Tableau Server username is the same as the username in Kyligence Enterprise. We call it an execute as user. You can set it locally in Tableau Server and Kyligence Enterprise, in LDAP or other third-party user authentication systems.
  6. Set “kylin.query.query-with-execute-as” to “true” in the Kyligence Enterprise configuration file in “<Kyligence Enterprise Installation Directory>/conf/kylin.properties”. Restart Kyligence Enterprise server to let the changes become effective.

Configure the delegation

The user delegation only works on Tableau Server. When you upload a workbook using Kyligence connector as the data source to Tableau Server, please choose “Impersonate via embedded password” as the Authentication mode.

Please refer to Kyligence User Manual for detailed Instructions.

Tech Specifications

Version
1.0.0
Works with
Tableau 2019.4 and later

Resources