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

[Aditya_Chitale]

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

[Sunilsahu_345]

Thanks for this helpful information

[RafaelBarrios]

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:

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

2. 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! 

[RafaelBarrios]

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.