Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlikview ODBC/JDBC Connection to Vertica using Key based Authentication

Hi All,

I have hit a brick wall trying to connect to a DB on cloud environment. I am able to connect to that DB from Database query tools such as Toad or Dbvisualizer using JDBC connection with Private key mentioned in connection string.

But in Qlikview, i cannot find an example connection string using Key based authentication using ODBC.

Similarly i havent found a stable way to configure JDBC connection with qlikview either.

is creating specialist code in .net or java required for this type authentication?

Thanks in advance

Kind Regards

Ravi Singh

2 Replies
JonnyPoole
Former Employee
Former Employee

TIQ has  JDBC Connector that may give you a starting point.   QlikView JDBC Connector | TIQ Solutions

For ODBC, you are dependent on 3rd party ODBC drivers. Does yours support that authentication mechanism ?

You MAY need to write an adapter .  QVX is a documented method in the SDK in how  you can transform a data feed from 3rd party code into QlikView format:

QlikView QVX File Format

Not applicable
Author

Hi Jonathan,

Thanks for quick response.

I have tried JDBC connector from TIQ , but wasn't successful either.

Are there any other JDBC based better configurable connection from Qlikview to Vertica ?

Creating a custom connector, surely is an option, but thats going to push boundaries of the team.

Any other ideas?

Kind Regards

Ravi