topic Qlikview ODBC/JDBC Connection to Vertica using Key based Authentication in QlikView

Qlikview ODBC/JDBC Connection to Vertica using Key based Authentication

Mon, 29 Sep 2014 14:42:30 GMT

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

Re: Qlikview ODBC/JDBC Connection to Vertica using Key based Authentication

JonnyPoole — Mon, 29 Sep 2014 14:47:24 GMT

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

Re: Qlikview ODBC/JDBC Connection to Vertica using Key based Authentication

Mon, 29 Sep 2014 14:59:21 GMT

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