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. Select OAuth 2.0 from the Authentication drop-down list when configuring Windows DSN for Salesforce.
2. When prompted, 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.
This method uses direct username-password authentication with an additional security token for API access.
1. Select User ID and Password from the Authentication drop-down list when configuring Windows DSN for Salesforce.
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.