Kyligence Releases ODBC Driver 2.0 to Provide Enterprise-Level BI Connectivity

12 - 12 - 2017

In early December, Kyligence announced the official release of its self-developed ODBC driver, Kyligence ODBC Driver 2.0 (Kyligence ODBC). We restructured the code base of Kyligence ODBC to simplify installation and deployment; optimize support for leading BI software, such as Tableau, Power BI, MicroStrategy, QlikView, and Cognos; and natively support live connection with Tableau and Direct Query with Power BI. It pushes SQL queries to Kyligence Analytics Platform (KAP), our enterprise OLAP on Hadoop solution, on the backend and only returns the results to the connected BI software. This design enables data analysts and other end users to quickly access and analyze petabyte-scale data with sub-second latency through KAP, without having to first load data from their sources to local BI tools or BI servers.

KAP, powered by Apache Kylin, enables sub-second SQL query latency on petabyte-scale dataset. It supports various query interfaces, such as JDBC, ODBC, and REST API, while simplifying the connection with external applications. The existing Apache Kylin ODBC Driver cannot satisfy enterprise users’ needs of seamless integration with various BI tools in different scenarios. This challenge motivated our team to invest large development resources to make Kyligence ODBC, a cross-platform driver that meets our enterprise customers’ demand.

Kyligence ODBC not only supports all existing functionalities of Apache Kylin ODBC, but also enhances its support for over 90% of Tableau’s features. Combined with Tableau Live Connection or Power BI Direct Query, Kyligence ODBC allows Tableau and Power BI to send user queries to KAP’s query engine directly, to make getting instantaneous analytics results possible. This improvement significantly increases the query efficiency and interactive experience of these two leading BI tools.

 

Kyligence ODBC Deployment Window

Instructions for Using Kyligence ODBC:

  1. Kyligence ODBC is part of the KAP enterprise product line. KAP users may use it directly.
  2. Please select 32-bit or 64-bit installation package corresponding to your application.
  3. Kyligence ODBC can only connect with KAP and cannot connect with Apache Kylin.
  4. Windows compatibility is available in the current release. Linux compatibility will be available soon.
  5. Please download the latest Kyligence ODBC Driver from Kyligence official website [http://account.kyligence.io].

For more details, please refer to the related chapter in KAP manual

Recent Post

Kyligence Announces General Availability of Kyligence Cloud to Accelerate Mission Critical Analytics at Strata Data Conference San Jose 2018

Kyligence Announces General Availability of Kyligence Cloud to Accelerate Mission Critical Analytics at Strata Data Conference San Jose 2018

San Jose, CA – March 7, 2018 – Kyligence, a leading big data intelligence company, announced general availability of Kyligence Cloud at Strata Data Conference 2018.
Read More

Kyligence Launches Partner Certification Program to Foster Big Data Technology Ecosystem

Kyligence Launches Partner Certification Program to Foster Big Data Technology Ecosystem

Kyligence, a leading big data intelligence platform, unveils its Kyligence Certification Program (KCP) for partner organizations to provide enterprise customers with a trusted, end-to-end program that certifies connectivity and compatibility between Kyligence’s and its partners’ products.
Read More

Global Smartphone Manufacturer OPPO Deploys Kyligence Analytics Platform Plus to Remove Big Data Bottlenecks

Global Smartphone Manufacturer OPPO Deploys Kyligence Analytics Platform Plus to Remove Big Data Bottlenecks

SANTA CLARA, CA–November 7, 2017–Kyligence Inc., a leading Big Data intelligence platform, announces that OPPO Electronics Corp.
Read More