KB262252: Steps to Create a DSN to MongoDB in MicroStrategy Secure Enterprise 10.x

Introduction:
The following document explains how to use the Strategy Connectivity Wizard to create a DSN configured to point to MongoDB in Strategy Secure Enterprise 10.x
 
Configuration steps:

• On the same host where Strategy is installed, create a directory to house the files created by the Strategy ODBC Driver for MongoDB to map the MongoDB database to a relational schema (for more information please refer to the driver documentation). This location must have the proper write permissions enabled so that the Strategy Connectivity Wizard will be able to create the files in this location.
  Windows example: C:\>mkdir mongodb_mstr
  Linux example: mkdir /mongodb_mstr, chown mstruser mongodb_mstr
  
• Start the Connectivity Wizard
  On Windows: Start->Programs->Strategy Tools->Connectivity Wizard
  On Linux/UNIX: /MSTR_INSTALLATION_PATH/bin/mstrconnectwiz
  
• Choose ‘Next’ to continue
• Choose the ‘Strategy ODBC Driver for MongoDB’ and continue.
  

• Provide the following information for the new DSN
  Data Source Name: Provide a unique name for the DSN so that there is no conflict with existing DSNs
  Host Name: Provide the host name of the server that hosts the MongoDB database
  Port Number: Provide the port number for the MongoDB database (typically 27017)
  Database name: Provide the MongoDB database name
  Schema Definition Path: Provide the path where the files are to be written and a name for the configuration file. The path was created in the first step in this document. The config file name is user configurable but should take the following format for best practice: databasename.config. For example, if the MongoDB database name is warehouse1 it is a good practice to use warehouse1.config as the file name.
  

• Test the connection to verify the information is correct and that the configuration files were created in the proper location
  

• Click the Finish button to create the DSN and exit the wizard