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.

Example connection string:

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

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