topic Re: Connecting Qlik Sense Enterpise On-Prem with Apache Pinot using jdbc connection in Connectivity & Data Prep

Connecting Qlik Sense Enterpise On-Prem with Apache Pinot using jdbc connection

Aditya_Chitale — Thu, 26 Mar 2026 12:23:20 GMT

Hi All,

I am trying to connect Qlik Sense with Apache Pinot, but pinot does not provide any ODBC driver to create an ODBC connection in Qlik Sense, instead, it provides jdbc driver which is not supported by Enterprise Qlik Sense.

I did some research and found out that we need to use some JDBC-ODBC driver bridge, which is fine, but is there any other way to connect jdbc databases with Qlik Sense ? anything that I am missing ? Any suggestions would be appreciated.

Regards,

Aditya

Re: Connecting Qlik Sense Enterpise On-Prem with Apache Pinot using jdbc connection

Sunilsahu_345 — Thu, 02 Apr 2026 13:09:12 GMT

Thanks for this helpful information

Re: Connecting Qlik Sense Enterpise On-Prem with Apache Pinot using jdbc connection

RafaelBarrios — Thu, 30 Apr 2026 21:09:54 GMT

Hi @Aditya_Chitale

In my experience, I would recommend avoiding JDBC-ODBC bridges, as they often introduce stability issues and performance bottlenecks in production environments.

In our implementation, we solved this by placing Presto (or Trino) as a federation layer between Qlik and Pinot. This approach offers two main advantages:

Handling Complex Logic: While Pinot is incredibly fast for low-latency queries, it has known limitations regarding complex JOINs and heavy aggregations. Presto excels at multi-staging and handling more sophisticated SQL logic.
Native Connectivity: Qlik Sense has a native Presto connector. By using Presto as the entry point, you eliminate the need for third-party drivers and ensure a much more stable, supported connection.

If your use case involves complex data transformations or joining Pinot tables with other sources, this architecture is a much more robust long-term solution.

help users find answers! Don't forget to mark a solution that worked for you & to smash the like button!

Re: Connecting Qlik Sense Enterpise On-Prem with Apache Pinot using jdbc connection

RafaelBarrios — Fri, 01 May 2026 20:28:22 GMT

as commented in my previous reply, i recommend using Presto, but if you still need to go directly to PINOT, you can always use a REST connection

Create new connection

in request body, use useMultistageEngine if you need to use joins

authetication method

Check "Allow with connection" so you can change query without creating a connection for each query

Load and sort your model

Hope this helps.