Connectivity issue via Simba ODBC Driver for BQ

kishetty03 — Wed, 21 Dec 2022 11:50:57 GMT

I did installed Simba ODBC Driver and Google SDK as mentioned in Qlik Replicate Nov 22 Guide for Big Query as Target.

while checking the connectivity from Qlik Replicate End point Getting below error

Cannot connect to ODBC provider
RetCode: SQL_ERROR SqlState: HY000 NativeError: 1120 Message: [Simba][DriverSupport] (1120) SSL verification failed because the server host name specified for the connection does not match the "CN" entry in the "Subject" field or any of the "DNS Name" entries of the "Subject Alternative Name" field in the server certificate.

OS is RHEL 8

Any idea on the resolution of this

Thanks in Advance

Re: Connectivity issue via Simba ODBC Driver for BQ

SwathiPulagam — Wed, 21 Dec 2022 12:08:17 GMT

Hi @kishetty03 ,

If your Replicate server is on windows then try to connect using ODBC administrator. If it is Linux then try to connect using the isql command.

Let us know the result.

Thanks,

Swathi

topic Re: Connectivity issue via Simba ODBC Driver for BQ in Qlik Replicate

Connectivity issue via Simba ODBC Driver for BQ

Re: Connectivity issue via Simba ODBC Driver for BQ