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:
| Field | Value |
|---|---|
| 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. |
