Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Not applicable

Is there anyway to connect to a database using JDBC versus ODBC?

I'm trying to connect to a database using a JDBC connection string versus ODBC. Is there anyway to do this in Qlik Sense?

1 Solution

Accepted Solutions
Employee
Employee

Re: Is there anyway to connect to a database using JDBC versus ODBC?

Hi Zack -

Technically, not out of the box - since the Qlik Sense platform is not Java based, it is not a native component to most Windows software.

There are pay-for ODBC drivers that translate ODBC calls to JDBC calls that can do this - or even SDKs that can build this - (Simba)

We even have partners that built them - but at the moment I believe they are still for QlikView and NOT Qlik Sense

QlikView JDBC Connector

If you look into the partner, these would be provided as custom connectors, which are available for QlikView, but not yet in Qlik Sense. However, you can USE THEM with Qlik Sense -just a few small edits to the settings.ini file to allow legacy or CUSTOM CONNECTORS.

Also, this would be a great opportunity to visit Branch our (Qlik's) developer network and open exchange. It is in a closed beta at the moment, however you may be able to collaborate and network with others that might be working on a similar connector for Sense.

Sorry I could not give you a better answer. Perhaps others in the community might chime in.

(Please mark the appropriate replies as helpful / correct so our team and other members know that your question(s) has been answered to your satisfaction.)

Regards,

Mike Tarallo

(Qlik)

Regards,
Mike Tarallo
Qlik

View solution in original post

3 Replies
Employee
Employee

Re: Is there anyway to connect to a database using JDBC versus ODBC?

Hi Zack -

Technically, not out of the box - since the Qlik Sense platform is not Java based, it is not a native component to most Windows software.

There are pay-for ODBC drivers that translate ODBC calls to JDBC calls that can do this - or even SDKs that can build this - (Simba)

We even have partners that built them - but at the moment I believe they are still for QlikView and NOT Qlik Sense

QlikView JDBC Connector

If you look into the partner, these would be provided as custom connectors, which are available for QlikView, but not yet in Qlik Sense. However, you can USE THEM with Qlik Sense -just a few small edits to the settings.ini file to allow legacy or CUSTOM CONNECTORS.

Also, this would be a great opportunity to visit Branch our (Qlik's) developer network and open exchange. It is in a closed beta at the moment, however you may be able to collaborate and network with others that might be working on a similar connector for Sense.

Sorry I could not give you a better answer. Perhaps others in the community might chime in.

(Please mark the appropriate replies as helpful / correct so our team and other members know that your question(s) has been answered to your satisfaction.)

Regards,

Mike Tarallo

(Qlik)

Regards,
Mike Tarallo
Qlik

View solution in original post

Support
Support

Re: Is there anyway to connect to a database using JDBC versus ODBC?

I agree with Michael.

Partner
Partner

Re: Is there anyway to connect to a database using JDBC versus ODBC?

Hi,

Instal Cristal Report and will give you an ODBC to use to connect to SAP HANA, see in this link :

SAP HANA Demystified