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 [https://account.kyligence.io].

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

Recent Post

Kyligence Expands Its Global Commitment to Accelerate Big Data Analytics

Kyligence Expands Its Global Commitment to Accelerate Big Data Analytics

Kyligence opens the doors to its new headquarters for the Americas to better serve a growing community of customers and partners.   On Thursday, January 17th, Kyligence hosted representatives from local clients, leading technology firms, and distinguished members of the Silicon Valley tech community for a grand opening celebration of the company’s U.S. headquarters. Founded […]
Read More

Kyligence Enterprise v3 Now Available in the Microsoft Azure Marketplace

Kyligence Enterprise v3 Now Available in the Microsoft Azure Marketplace

Microsoft Azure customers worldwide now gain access to Kyligence Enterprise v3 to take advantage of the scalability, reliability, and agility of Azure to drive application development and shape business strategies.     SANTA CLARA, CA — December 5, 2018 —Kyligence, a leading data intelligence company that focuses on big data analytic technology innovation, today announced the availability of […]
Read More

Kyligence Joins the OpenPOWER Foundation Foster Big Data Solution to community-driven hardware innovation

Kyligence Joins the OpenPOWER Foundation Foster Big Data Solution to community-driven hardware innovation

Shanghai/July 24, 2018 … Kyligence, a leading data intelligence company, today announced the company has joined the OpenPOWER Foundation, an open development community based on the POWER microprocessor architecture.   The OpenPOWER Foundation, founded in 2013 with 340 members expanding across 34 countries, is an open technical community based on the POWER architecture, enabling collaborative development and […]
Read More