topic Re: Connect Qlik Sense to Heroku Postgres database in Connectivity & Data Prep

Connect Qlik Sense to Heroku Postgres database

Fri, 10 Mar 2017 14:18:00 GMT

Hello,

I have a DB hosted in heroku. Using their credentials

And adding the last attribute, sslmode=require.

I still get an error message:

Invalid attribute string: "sslmode".

The same happens with just "ssl".

If I remove the attribute, I get the following error:

Can't connect to server .... General error.

Any idea?

Thanks,

Ivo

Re: Connect Qlik Sense to Heroku Postgres database

peterkunhardt — Fri, 19 Jan 2018 18:59:36 GMT

Hi ivoletra, did you ever determine a solution to this issue? I am having the same problem, same errror message when attempting to pass 'sslmode' as an attribute. When I don't specify the attribute, I receive an error message that ends with

'FATAL: SSL connection is required. Please specify SSL options and retry.'

Re: Connect Qlik Sense to Heroku Postgres database

peterkunhardt — Wed, 31 Jan 2018 20:58:02 GMT

For those experiencing issues connecting to their Heroku DB, (or any other DB with SSL authentication) we found a solution that appears to work with our Heroku instances:

Qlik Sense appears to utilize this ODBC driver for Postgres connections, which uses a nonstandard attribute nomenclature for security and encryption options. The following two attributes will replicate the effect of sslmode = require:

Attribute Value

EncryptionMethod 1

ValidateServerCertificate 0