Qlik Community

Qlik Sense Data Connectivity

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

Not applicable

Connect Qlik Sense to Heroku Postgres database

Hello,

I have a DB hosted in heroku. Using their credentials

QlikSense.jpg

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

Tags (2)
2 Replies
peterkunhardt
New Contributor II

Re: Connect Qlik Sense to Heroku Postgres database

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.'

peterkunhardt
New Contributor II

Re: Connect Qlik Sense to Heroku Postgres database

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

Community Browser