Connection options

Devart ODBC Driver for Salesforce provides multiple connection options to ensure flexibility, security, and integration with various applications and environments. Connection options for the driver depend on the chosen connection type and authentication method.

OAuth 2.0 authentication

OAuth 2.0 provides a secure way to connect without storing credentials in the connection settings.

Devart ODBC Driver for Salesforce Configuration

Required parameters:

Server – The Salesforce instance (for example, https://login.salesforce.com).

Authentication – OAuth.

Refresh Token – The Salesforce OAuth 2.0 token.

Consumer Key – The public identifier of your custom application in Salesforce.

Consumer Secret – The private key of your custom application in Salesforce used together with the consumer key for authentication and verification.

Example connection string:

DRIVER={Devart ODBC Driver for Salesforce};Server=login.salesforce.com;Authentication=OAuth;Refresh Token=a6Lgob979LW4anxfbhtDgtukr;Consumer Key=your_consumer_key;Consumer Secret=your_consumer_secret

Server-to-server authentication

Server-to-server authentication uses the OAuth 2.0 client credentials flow and enables applications to access Salesforce data without interactive user sign-in. Instead of signing in through a browser, the application authenticates using a consumer key and consumer secret.

Devart ODBC Driver for Salesforce server-to-server configuration

Required parameters:

Server – The Salesforce instance (for example, https://login.salesforce.com).

Authentication – Server-to-Server.

Consumer Key – The public identifier of your external client application in Salesforce used to authenticate the application.

Consumer Secret – The confidential key of your external client application in Salesforce used to verify the application’s identity during authentication.

Example connection string:

DRIVER={Devart ODBC Driver for Salesforce};Description=Devart ODBC Driver;Authentication=ServerToServer;Data Source=login.salesforce.com;Consumer Key=your_consumer_key;Consumer Secret=your_consumer_secret

For information about how to create an external client app and obtain the consumer key and consumer secret, see Get credentials for server-to-server authentication.

Username & password authentication

This method requires a Salesforce security token unless the connection is from a trusted IP range.

Devart ODBC Driver for Salesforce password authentication Configuration

Required parameters:

Server – The Salesforce instance (for example, https://login.salesforce.com).

Authentication – User ID and Password.

User ID – The Salesforce username.

Password – The Salesforce password.

Security Token – The security token used to authenticate access to your Salesforce account.

Example connection string:

DRIVER={Devart ODBC Driver for Salesforce};Server=login.salesforce.com;User ID=your_username;Password=your_password;Security Token=a6Lgob979LW4anxfbhtDgtukr

Connection via proxy server

Devart ODBC Driver for Salesforce supports proxy connections, enabling users to route their connection through a proxy server for enhanced network security and access control.

Required parameters:

Server – The Salesforce instance (for example, https://login.salesforce.com).

Proxy Server – The proxy server address.

Port – The port number used for the proxy connection.

Proxy User ID – The username for proxy authentication.

Proxy Password – The password for proxy authentication.

Example connection string:

DRIVER=Devart ODBC Driver for Salesforce;Description=Devart ODBC Driver for Salesforce;Server=login.salesforce.com;User ID=your_username;Proxy Server=your_proxy_server;Proxy Port=8080;Proxy User=your_proxy_username;Proxy Password=your_proxy_password;Security Token=a6Lgob979LW4anxfbhtDgtukr