Devart ODBC Driver for Salesforce is a high-performance connectivity tool with enterprise-level features for accessing Salesforce from ODBC-compliant reporting, analytics, BI, and ETL tools on both 32-bit and 64-bit Windows.
Version: 2.0.1Devart ODBC Driver for Salesforce is a high-performance connectivity tool with enterprise-level features for accessing Salesforce from ODBC-compliant reporting, analytics, BI, and ETL tools on both 32-bit and 64-bit Windows. Our ODBC driver fully supports standard ODBC API functions and data types and enables easy access to live Salesforce data from anywhere.
License: Free To Try $199.95
Operating System: Windows
- Connection to Salesforce
Our connectivity solution enables various ODBC-aware applications to connect to Salesforce directly via HTTPS.
If you have no direct access to Salesforce, you have the option of establishing a connection through a proxy server.* Extended SQL Syntax Our ODBC driver provides an unrivalled opportunity to work with Salesforce objects just as with SQL tables. The extended SQL syntax allows you to use all the SQL benefits in SQL-92 compatible SELECT statements:
- Complex JOINs
- WHERE conditions
- GROUP statements
- Aggregation functions
- ORDER statements, etc.
Devart ODBC Driver for Salesforce provides support for DML (INSERT, UPDATE, DELETE) operations, which allows you to modify data in Salesforce in the same way as in SQL databases.* Bulk Updates
Moreover, with our driver you can perform bulk updates to Salesforce by combining SQL statements into batches, thus simplifying and speeding up large data modification with Salesforce.* ODBC Conformance The driver provides full support for common ODBC interface:
- ODBC API Functions support
- ODBC Data Types support
In addition, we provide support for Advanced Connection String parameters.
Thus allowing any desktop and web applications to connect to Salesforce from various environments and platforms, that support ODBC.
You can always find the latest version of the product on the official Devart website.
Version 2.0.1: * OAuth authorization is supported * The ability to execute SOQL queries is added
Version 1.8.1: * The ReturnForeignKeys connection option to significantly improve performance is added * Compatibility with Visual Studio is improved