Devart ODBC Driver for Salesforce offers three authentication methods to provide secure and flexible access to Salesforce data. You can select the authentication method that best suits your needs.
OAuth 2.0 is the recommended authentication method for accessing Salesforce, as it provides secure, token-based access without exposing user credentials.
OAuth uses a browser-based flow to authenticate the user. Upon login, Salesforce issues an access token that the driver uses to establish connections.
1. When configuring a DSN for Salesforce in ODBC Data Source Administrator on Windows or Devart ODBC administrator on macOS or Linux, select OAuth 2.0 from the Authentication dropdown list.
2. Click Sign in to Salesforce. A browser window opens for Salesforce login.
3. Log in with your Salesforce username and password and authorize the application.
4. The driver retrieves and stores the access token for subsequent connections.
5. For a custom application, enter the consumer key and secret.
This method uses direct username-password authentication with an additional security token for API access.
1. When configuring a DSN for Salesforce, select User ID and Password from the Authentication dropdown list.
2. Enter the following credentials in the corresponding fields:
Note
If your organization requires a security token, append it to your password when entering it into the driver configuration dialog.
For example:
Password: MyPassword
Security Token: 123ABC
Entered Password: MyPassword123ABC
Salesforce allows bypassing the security token requirement for connections originating from trusted IP ranges defined in the Salesforce settings.
Your Salesforce admin configures trusted IP ranges in the organization’s security settings.
Connections from these IPs authenticate with just the username and password, without requiring a security token.
For on-premises applications operating within known, secure network environments.