ODBC Driver for Salesforce
A high-performance connectivity tool with enterprise level functionality that can access Salesforce from ODBC-compatible reporting, analysis, BI, and ETL tools on 32-bit and 64-bit Windows. Our ODBC driver fully supports standard ODBC API functions and data types, and allows easy access to real-time Salesforce data from anywhere.
Connecting to Salesforce
Our connectivity solution enables various ODBC-enabled applications to directly connect to Salesforce through HTTPS. If you cannot directly access Salesforce through HTTPS, you can choose to establish a connection through a proxy server.
Extended SQL syntax
Our ODBC driver provides unparalleled opportunities to use Salesforce objects like SQL tables. The extended SQL syntax allows you to use all SQL advantages in SQL-92 compatible SELECT statements:
- Complex connections
- condition
- Subquery
- GROUP statement
- Summary function
- ORDER statement
- More
DML operation
The Devart ODBC driver for Salesforce provides support for DML:
This allows you to modify data in Salesforce just like in an SQL database.
Cost effective deployment
Our ODBC driver is a standalone installation file that does not require users to deploy and configure any other software, such as database clients or vendor libraries. Deployment costs are greatly reduced, especially in large organizations with hundreds of computers, when using silent installation methods with OEM licenses.
ODBC consistency
This driver fully supports common ODBC interfaces:
- ODBC API function support
- ODBC data type support
In addition, we provide support for advanced connection string parameters, allowing any desktop and web application to connect to Salesforce from various environments and platforms that support ODBC.
Salesforce compatibility
Our ODBC driver fully supports Salesforce field data types, and is also compatible with the Salesforce API itself.
What are the reasons for choosing the Devart ODBC driver for Salesforce?
The ODBC driver for Salesforce can be used with 32-bit and 64-bit applications on both x32 and x64 platforms, so there is no need to configure additional drivers, applications, or environments.
This driver is compatible with third-party tools for data analysis, such as Microsoft Excel, and integrates with various IDEs and systems such as Visual Studio.
For a complete list of compatible tools and environments, please visit the 'Compatibility' page.
- Fully Unicode compliant driver
Using our fully Unicode compatible driver, you can correctly retrieve and modify any data in a multilingual Salesforce database without considering their character sets: Latin, Cyrillic, Hebrew, Chinese, etc., as well as in any language environment.
We have implemented an advanced data conversion mechanism that provides bidirectional mapping between any Salesforce and ODBC data type.
