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

KB422148: How to configure MicroStrategy to connect to Salesforce.com using MicroStrategy ODBC Driver for Salesforce on Windows


Community Admin

• Strategy


This technical note outlines the steps to configure Strategy on Windows to connect to Salesforce.com. This setup can be achieved through the Strategy connectivity configuration wizard.
 
     1.    Launch Strategy Connectivity Wizard, and select the Strategy ODBC driver for Salesforce as shown below:

ka04W000000Oaj1QAC_0EM440000002L8Q.png

 
 
     2.    Input DSN name as shown below:

ka04W000000Oaj1QAC_0EM440000002L8V.png

– Data Source Name: Type a descriptive name that identifies the DSN in the system.
– Host Name: You can either keep the default value of login.salesforce.com or change it to a sandbox instance relevant for your organization
 
     3.    Click Test to input the login credentials.

ka04W000000Oaj1QAC_0EM440000002L8f.png

Use a Salesforce account login information. Note that the password syntax is PasswordSecurityToken, where Password is the password for the user account and SecurityToken is the additional security token required to access Salesforce.com. Do not use any spaces or other characters to separate the password and security token.
 
KB43264 KB422148


Comment

0 comments

Details

Knowledge Article

Published:

May 5, 2017

Last Updated:

December 31, 2018