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