EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB45197: How to create a Data Source Name (DSN) to use for a new database connection in Microstrategy Analystics Desktop 9.4.1.1 and above


Community Admin

• Strategy


How to create a Data Source Name (DSN) to use for a new database connection in Microstrategy Analystics Desktop 9.4.1.1 and above

 
To create a new system Data Source Name (DSN) to use in a new database connection in Strategy Analytics Desktop 9.4.1.1 and above, users need to use the Windows ODBC Data Source Administrator available here:
 
- 64 bit Windows: C:\\Windows\SysWoW64\odbcad32.exe
- 32 bit Windows: C:\\Windows\System32\odbcad32.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.
 

ka04W000000Ogg3QAC_0EM4400000026UL.jpeg

 
Once the DSN is created, please go to Strategy Analytics Desktop and follow the steps outlined below:
 
- Click Import > Data
 

ka04W000000Ogg3QAC_0EM4400000026UN.jpeg

 
- Database
 

ka04W000000Ogg3QAC_0EM4400000026U9.jpeg

 
- New connection:
 

ka04W000000Ogg3QAC_0EM4400000026UI.jpeg

 
- under DSN Connections, choose the DSN created earlier:

ka04W000000Ogg3QAC_0EM4400000026UB.jpeg

 
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.
 
 
 


Comment

0 comments

Details

Knowledge Article

Published:

June 13, 2017

Last Updated:

June 13, 2017