Features

Last modified: July 7, 2025

Devart ODBC Driver for Salesforce offers full ODBC compliance, seamless SQL-to-SOQL mapping, advanced data type handling, and flexible authentication options—making it a powerful solution for integrating Salesforce with BI tools, database systems, and cross-platform applications.

Full ODBC compliance

Devart ODBC Driver for Salesforce is fully compliant with the ODBC standard, enabling users to integrate it with a wide range of ODBC-compliant applications and tools.

• Support for BI tools and database systems.
• Cross-platform compatibility.
• Automatic configuration.
• Reliable data exchange.

Direct SOQL query execution

Devart ODBC Driver for Salesforce Allows direct execution of native SOQL queries. This enables users to take full advantage of Salesforce-specific query capabilities when needed, bypassing SQL-to-SOQL translation. Direct execution is useful for complex queries that rely on SOQL-specific functions or syntax not covered by standard SQL.

SQL-92 to SOQL query mapping

Devart ODBC Driver for Salesforce simplifies querying Salesforce data by automatically translating standard SQL-92 queries into SOQL, Salesforce’s native query language.

• Support for SQL-92 syntax, including WHERE, ORDER BY, JOIN, subqueries, and aggregate functions like COUNT, AVG, SUM, and GROUP BY.
• Server-side execution of translated queries to reduce data transfer and improve performance.
• Consistent querying.

Support for standard SQL syntax and DML operations

ODBC Driver for Salesforce fully supports standard SQL syntax, which allows users to execute queries and perform data operations with ease. It allows interaction with Salesforce objects as if they were standard SQL tables. This includes support for INSERT, UPDATE, and DELETE operations on Salesforce data.

Advanced data type mapping

The driver ensures accurate bi-directional mapping between Salesforce and ODBC data types. Automated data type mapping eliminates the need for manual adjustments and ensures compatibility with a wide range of applications and tools.

• Automatic data conversion of Salesforce-specific types to their ODBC equivalents.
• Data integrity preservation.

Fully Unicode driver

The driver provides full Unicode support, allowing you to retrieve and work with data from multilingual Salesforce databases regardless of character set—whether Latin, Cyrillic, Hebrew, Chinese, or others—and independently of the environment’s locale settings.

Flexible authentication options

Devart ODBC Driver for Salesforce provides two authentication methods, making it easier to integrate Salesforce with other tools and applications. Users can connect to Salesforce using their login credentials (username and password) or take advantage of the security and convenience of OAuth authentication.

• Support for multiple authentication methods.
• Simplified integration.
• Centralized authentication management with OAuth.

Support for proxy connections

Devart ODBC Driver for Salesforce supports connecting through HTTP proxy servers. This allows the driver to operate in network environments with restricted direct access to the internet. Proxy authentication is supported, and the feature works with both OAuth and login/password authentication methods.