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 and 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.

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.