Rocky 8 PostgreSQL Data Movement Gateway

[jborthen]

Hi, I have a PostgreSQL database in Rocky 8 running on an AWS EC2 instance.  I was able to install the Qlik Data Movement rpm file and I've checked all the permissions on the EC2 instance but I still don't seem to be able to create a data connection in QDI.  I keep getting the following error.

SYS-E-HTTPFAIL, Failed to connect. SYS,GENERAL_EXCEPTION,Failed to connect,RetCode: SQL_ERROR SqlState: 01000 NativeError: 0 Message: [unixODBC][Driver Manager]Can't open lib 'PostgreSQL Unicode(x64)' : file not found

[vinodn1989 · Accepted solution]

Can you try installing the PostgreSQL ODBC Driver Package?

You can use the below command on redhat based machines

sudo yum install postgresql-odbc