Advanced connection options

Devart ODBC Driver for Salesforce provides advanced connection options, allowing you to customize settings to suit your specific needs.

You can configure these custom settings when creating a new Windows DSN or modify an existing DSN.

1. Open the ODBC Data Source Administrator.

2. Navigate to the User DSN or System DSN tab, depending on where the DSN for Salesforce is configured.

3. Select the Salesforce Data source, then select Configure.

4. In the Devart ODBC Driver for Salesforce Configuration dialog that opens, navigate to the Advanced Settings tab.

Configure a custom connection on Windows

5. Configure the required settings, then select OK to save and apply the changes.

Available options

Metadata section

Empty Strings as NULL: Enable this option to treat empty strings as NULL values when interacting with Salesforce data.

Allow NULL Strings: Enable this option to permit NULL string values in the dataset.

Return Foreign Keys: Enable this option to retrieve foreign key relationships. Enabling this may significantly degrade performance, depending on the query and dataset.

Cache Metadata: Configure how long metadata is cached using the dropdown options:

  • False: No caching.
  • 1 Hour: Cache metadata for one hour.
  • 1 Day: Cache metadata for one day.
  • 1 Month: Cache metadata for one month.
  • True (Infinite): Cache metadata indefinitely.

Connection section

Connection Timeout: Set the maximum time (in seconds) before the driver stops attempting to establish a connection. Useful for preventing hangs in unstable environments.

Query Timeout: Set the maximum time (in seconds) to wait for a query to execute. Helps manage long-running operations.

UTC Dates: Enable this option to ensure all date and time values are returned in Coordinated Universal Time (UTC).

Include Deleted: Enable this option to include deleted records in query results.

Use Local Regional Settings when converting to strings section

Numbers: Enable this option to format numbers according to the local regional settings of the system.

Dates and Times: Enable this option to format dates and times based on the system’s local regional settings.

Compatibility section

ODBC Behavior: Configure the ODBC behavior using the dropdown options:

  • Default: Uses the default behavior of the driver.

  • ver 2.x: Emulates ODBC 2.x behavior for compatibility with older applications.

  • ver 3.x: Emulates ODBC 3.x behavior for compatibility with newer standards.

String Types: Select the string type for data exchange:

  • Default: Uses the driver’s default string type.

  • ANSI: Uses ANSI encoding for string data.

  • Unicode: Uses Unicode encoding for string data.