Qlikview ODBC/JDBC Connection to Vertica using Key based Authentication

[#1]

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

[JonnyPoole]

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

[#3]

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