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 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

Kyligence Announces General Availability of Kyligence Enterprise 3.0 and Kyligence Cloud 2.0

Kyligence Announces General Availability of Kyligence Enterprise 3.0 and Kyligence Cloud 2.0

Shanghai China, July 5, 2018 – Today, we are excited to announce the general available of Kyligence Enterprise 3.0 along with Kyligence Cloud 2.0. Together, these products help analysts manage insights from massive datasets with a game-changing intelligent modeling engine and high performance from on-premise to in the cloud. SQL Acceleration Intelligently Kyligence Enterprise 3.0 provides […]
Read More

Kyligence Cloud 2.0 Release Announcement

Kyligence Cloud 2.0 Release Announcement

Today we’re proud to announce Kyligence Cloud 2.0, a simple, intelligent, and secure solution for moving big data analytics to cloud. In this new release, we embedded our latest OLAP engine Kyligence Enterprise 3.0, to accelerate your OLAP analysis and mission critical queries at interactive speed on PB-scale data. Simple and Seamless User Experience With […]
Read More