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