UDC connection string Bonita Portal postgres

[#1]

Dear Experts,

Bare with me, I'm new to the platform.

I have a Bonita Portal with users stored in a PostgreSQL database and I want to make sure our Qlik Sense server can read the database and when people login on the Bonita Portal they can access the Qlik reports with the same credentials as they log in to the Bonita Portal.

So I go to /qmc --> user directory connectors --> create new --> ODBC --> Filled in all the fields, but when I hit apply I get the error:

There are drivers installed in the System DNS for postgres drivers, that's the way we can load data from the database in to a report. We have add a new System DNS and tried to use that one, but is failing all the time . See the attachment for my connection string, what am I doing wrong, do I need to configure something else?

--edit

I tried to use a driver that's already there, from Qlik, Qlik-postgres. So I used that as driver, but now I got a time-out.

[Anonymous]

Hi Jermaine,

    Can you provide me details of how the timeout issue of UDC connector to Postgres was resolved?

Driver=Qlik-postgres;Server=test;Port=5432;Database=test;Uid=test;Pwd=test;