KB308262: How to connect to MongoDB using SSL in MicroStrategy Secure Enterprise?

SUMMARY
Starting with Strategy Secure Enterprise 10.5, it is possible to connect to MongoDB using SSL. This technical note explains the necessary steps to achieve this requirement.
 
Steps for Windows OS

1. Navigate to the Strategy Connectivity Wizard and create a DSN to MongoDB. Refer to KB262252 for details.
2. After the DSN is created, open the 64-bit Windows ODBC Administrator and configure the created MongoDB DSN. In the Security tab, set the Encryption Method =1 – SSL and uncheck the Validate Server Certificate check box.
3. Save the changes. After this, user should now be able to successfully connect to MongoDB.

 
Steps for Linux OS

1. Create a DSN to MongoDB as instructed in KB262252
2. Edit the MongoDB DSN section in the <MSTR_Install>/odbc.ini file. Add the following settings EncryptionMethod=1, ValidateServerCertificate=0 and save the odbc.ini file.

 
DSN-less Connection String

1. Navigate to Strategy Web -> Add External Data -> Databases -> MongoDB -> Pick tables and add a new data source.
2. Check the Edit Connection String checkbox and set the EncryptionMethod=1

 
Strategy Desktop Data Import

1. Open Strategy Desktop and choose “Add New Data”

1. Choose MongoDB as the Database type in the “Connect to Your Data” window

1. Choose an import option from the "Select import options" window:

1. From the “Import from Tables” window, choose to add a new data source:

1. Configure the Data Source with the relevant information to connect to MongoDB (hostname, port number, database name, user, password). Click the “Show connection string” link to expand the editor and display the connection string.

1. Click the 'Edit connection string' box to make changes to the connection string. This string needs to be updated to support SSL connections to MongoDB.

1. Remove the “SchemaDefinition=MSTR_JDBC_JAR_FOLDER}” from the string. Be sure to remove the curly bracket from the end of 'MSTR_JDBC_JAR_FOLDER'.

1. Update the EncryptionMethod to equal “SSL”

1. At the end of the connection string, add a curly bracket ( } ) to the connection string. Click the OK button to save the changes.

1. Click on the newly created Data Source in the 'Import from Tables' window. If everything is configured properly, users will see a list of available schemas from which to choose existing tables.