Using ODBC with Salesforce and Active Directory Federation Services (ADFS) Single Sign On (SSO)

This blog describes how to get an ODBC connection to a Salesforce instance that has been integrated with Active Directory Federation Services (ADFS).

The Salesforce ODBC driver has been tested with a Salesforce / ADFS environment that was set up by following this Salesforce tutorial:

Note that we set up ADFS on a Windows Server 2012 machine rather than a Windows Server 2008 machine as used in the tutorial.

Using the Easysoft Salesforce ODBC Driver with ADFS

Install and license the Salesforce ODBC driver. You need build version 2.0.20 or later. Contact the Easysoft Support team for this build.

Complete the Salesforce ODBC data source configuration dialog box as follows:

FieldValue
Use Oauth SSO AD FS
User Name windows-active-directory-user@windows-active-directory-domain

For example, myuser@mydomain.org.

Password The password for this user.
SSO Token URL The Salesforce OAuth 2.0 Token Endpoint. This is located in the Salesforce backend under Setup > Security Controls > Single Sign-On Settings > SAML Single Sign-On Settings > ADFS > OAuth 2.0 Token Endpoint. (Click the ADFS link, not the nearby Edit button.)
SSO Relying Party The display name of the Relying Party Trust you configured for Salesforce.
SSO Login URL https://windows-server-machine-name