I’ve installed the Cloudera ODBC driver on our AWS LINUX. I am following all the instructions in the associated guide and after configuring the odbc.ini as follows:

[ODBC Data Sources]

CDLPROD DSN=Cloudera ODBC Driver for Impala 64-bit

CDLQA   DSN=Cloudera ODBC Driver for Impala 64-bit

[CDLPROD]

Driver=/opt/cloudera/impalaodbc/lib/64/libclouderaimpalaodbc64.so

Host=edlimpalaprod.jnj.com

Port=21050

AuthMech=3

UseSASL=1

TrustedCerts=/opt/cloudera/impalaodbc/lib/64/cacerts.pem

UID=sagbcsbp@JNJ.COM

PWD=XXXXXX

TSaslTransportBufSize = 1000

[CDLQA]

Driver=/opt/cloudera/impalaodbc/lib/64/libclouderaimpalaodbc64.so

Host=edlimpalaqa.jnj.com

Port=21050

AuthMech=3

UseSASl=1

TrustedCerts=/opt/cloudera/impalaodbc/lib/64/cacerts.pem

UID=sagbcsbq@JNJ.COM

PWD=XXXXXX

TSaslTransportBufSize = 1000

I am trying to test the DSN connection using the following command from /usr/local/odbc:

isql -v CDLPROD

[S1000][unixODBC][Cloudera][DriverSupport] (1100) SSL certificate verification failed because the certificate is missing or incorrect.

[ISQL]ERROR: Could not SQLConnect

Would someone be able to help me resolve this issue? It would be greatly appreciated.