Using ODBC with Salesforce and Okta Single Sign On (SSO)

This blog describes how to get an ODBC connection to a Salesforce instance that has been integrated with Okta.

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

Using the Easysoft Salesforce ODBC Driver with Okta

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 Okta
User Name okta_user

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 > okta > OAuth 2.0 Token Endpoint. (Click the okta link, not the nearby Edit button.)
SSO Login URL The Okta subdomain. For example, if your Okta URL is:

https://mycompany.okta.com

your subdomain is:

mycompany.okta.com

SSO Tenant Your Okta API token. To generate a token, in the Okta Admin GUI, choose Security > API > Tokens > Create Token.