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.

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

Use Oauth SSO Okta
User Name okta_user

For example,

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:

your subdomain is:

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