We need to pull data from a client on prem DB, they require us to use SSL+ their cert when connecting.

The only issue I'm having is: I have no idea where to "import" the PEM file for their certs in data factory. I know that I should use:"UseSystemTrustStore=<0/1>;" in my connection string when setting up the Data factory connection but can't understand where I should put the cert files.

PS. running DFv2 also: my appologies for bad english It's not my first language.


1 Answers

MartinJaffer-MSFT On

When dealing with on-premises data, usually you will want to use a self-hosted integration runtime. The self-hosted integration runtime will handle the connection issues.

You can store your certificates in Azure Key Vault, and then reference the certificate , as explained in this document