I am a SQL Server DBA configuring an SSIS package that uses a connection to a remote vendor MySQL database instance.

The vendor has sent us 3 files to implement SSL transport to their MySQL database. The filenames are: ca.pem, client-cert.pem, client-key.pem. We're currently connecting to their instance via ODBC driver MySQL ODBC 5.3 ANSI Driver, version supplied by Oracle. I see that there is a selection for working with SSL when configuring the ODBC connection (see screen shot). Can someone advise me on how to set up these 3 files in this context?

enter image description here


1 Answer 1


To connect using SSL from the client side. Use the following mapping

  • ssl key = \\folderpath\client-key.pem
  • ssl certificate = \\folderpath\client-cert.pem
  • ssl ca = \\folderpath\ca.pem

Reference: Created using comment from samosql

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.