KB244367: Connecting MicroStrategy Analytics Enterprise to MySQL Relational Database Service using SSL

Before configuring the DSN, ensure that the SSL certificate is saved available while deploying the MYSQL RDS to a local folder.
Note: Make sure that the Strategy user has been granted permission to access the folder where the certificate is stored.
The following parameters need to be configured in the ODBC driver to enable SSL
For Windows

1. Create a DSN using MYSQL ODBC driver, Expand the details button and navigate to the SSL tab and configure the following parameters:

       a. Set SSL Certificate Authority =<certificate location> \<certificate filename>
       b. Check the Verify SSL Certificate checkbox
 

 
For Linux

1. Create a MYSQL DSN and update the following parameters in the ODBC.ini file

     a. sslca=<certificate location> \<certificate filename>
     b. sslverify=1