KB325497: How to create a Data Source Name (DSN) to use for a new database connection in MicroStrategy Analytics Desktop

To create a new system Data Source Name (DSN) to use in a new database connection in Strategy Analytics Desktop, users need to use the Windows ODBC Data Source Administrator available here:
- 64 bit Windows: C:\\Windows\SysWoW64\odbcad32.exe
 
On the ODBC Data Source Administrator, go to the "System" tab to create the DSN and refresh this page to see the changes.
 

 
Once the DSN is created, go to Strategy Analytics Desktop and follow the steps outlined below:
 

1. Select “Add New Data” from the Main menu.

1. In the Connect to Your Data window, select Database.

1. Select any of the three options in the next window.

1. In the Import from Tables window, select Add… next to Data Sources.

1. Select “DSN Data Sources”; from here, you will be able to select your previously created DSN, make sure to fill out the User and Password fields.

 
Third Party Software Installation WARNING:
 The third-party product(s) discussed in this technical note is manufactured by vendors independent of Strategy. Strategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability.