How to create a Data Source Name (DSN) to use for a new database connection in MicroStrategy Analytics Desktop 1.x
To create a new system Data Source Name (DSN) to use in a new database connection in Microstrategy Analytics Desktop 1.x, users need to use the Windows ODBC Data Source Administrator available here:
– 64 bit Windows: C:\WindowsSysWoW64odbcad32.exe
– 32 bit Windows: C:\WindowsSystem32odbcad32.exe
On the ODBC Data Source Administrator, please go to the “System” tab to create the DSN and refresh this page to see the changes.
![MAD4](https://resource.microstrategy.com/Support/UploadContent/50k/TN45197_TN45197_0.jpg)
Once the DSN is created, please go to Microstrategy Analytics Desktop and follow the steps outlined below:
– Click Import > Data
![MAD1](https://resource.microstrategy.com/Support/UploadContent/50k/TN45197_TN45197_1.jpg)
– Database
![MAD2](https://resource.microstrategy.com/Support/UploadContent/50k/TN45197_TN45197_2.jpg)
– New connection:
![MAD3](https://resource.microstrategy.com/Support/UploadContent/50k/TN45197_TN45197_3.jpg)
– under DSN Connections, choose the DSN created earlier:![MAD5](https://resource.microstrategy.com/Support/UploadContent/50k/TN45197_TN45197_4.jpg)
![MAD5](https://resource.microstrategy.com/Support/UploadContent/50k/TN45197_TN45197_4.jpg)
Hope it helps!
Have a Good Day!
Ref: MicroStrategy KB