How to call a ODBC with SSL on Selfhost runtime from Azure data factory?

David Dai 1

I setup a ODBC DSN on self hosted runtime and then try to call that DSN from azure datafactory.
But it keeps saying cert couldn't be found even I move those cert to system32 folder.

Anyone can help?

BhargavaGunnam-MSFT 26,496 Reputation points Microsoft Employee

2022-11-22T22:03:50.263+00:00

Hello @David Dai ,

Welcome to the MS Q&A platform.
It seems like the error is thrown by the driver.
Are you getting this error on the copy activity? if yes, could you please let me know your source and target?
David Dai 1 Reputation point

2022-11-22T22:10:56.003+00:00

Hi, I installed Postgres ODBC driver on Selfhost-IR, and set a system DSN. It works on the SHIR. But when I call that DSN from azure data factory, it pops such error. In the SHIR, I placed those cert and key files in the system32 folder and I can directly access those cert and key from ODBC without windows path.
Such as "qat-server-ca.pem". Test connection also shows successful. But when I call from ADF, it shows can't find file.

1 answer

BhargavaGunnam-MSFT 26,496 Reputation points Microsoft Employee

2022-11-24T00:36:49.713+00:00

Hello @David Dai ,
Do you see the certs in the "Trusted Root Certificate Authorities"?

1) Run MMC on the SHIR machine. Click File, then click Add/Remove Snap-in.

2) Add Certificates, and choose “Computer account” to view all certificates on this computer.

3) Please check the certificates listed under Trusted Root Certification Authorities

]2
Please sign in to rate this answer.
BhargavaGunnam-MSFT 26,496 Reputation points Microsoft Employee

2022-11-28T22:56:02.473+00:00

Hello @David Dai ,
Did you get a chance to look into my above response?
Sign in to comment