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 5.03.09.00 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?