Devart ODBC Driver for Salesforce

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. Our ODBC driver fully supports standard ODBC API functions and data types and enables easy access to live Salesforce data from anywhere. Available in both installer formats, MSI and EXE.

Key Features

Connection to Salesforce

Key Features

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 via HTTPS, 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
• Subqueries
• GROUP statements
• Aggregation functions
• ORDER statements
• and many more.
  

  DML Operations Devart ODBC Driver for Salesforce provides support for DML: INSERT UPDATE DELETE which allows you to modify data in Salesforce the same way as in SQL databases. Cost-Effective Deployment Our ODBC driver is a standalone installation file that doesn’t require the user to deploy and configure any additional software such as a database client or a vendor library. Deployment costs are reduced drastically, especially when using the silent install method with an OEM license in large organizations that have hundreds of machines. 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. Salesforce Compatibility Our ODBC driver has full support for Salesforce field data types and, moreover, the driver is compatible with the Salesforce API itself. Platforms Variety 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 additionally configure the driver, applications or environment. Integration The driver is compatible with 3rd-party tools for data analysis, such as Microsoft Excel, and integrates with various IDEs and systems like Visual Studio, etc. For the complete list of compatible tools and environments visit the Compatibility page. Fully Unicode-Compliant Driver With our fully Unicode-compliant driver, you can properly retrieve and modify any data in multilingual Salesforce databases, regardless of their character set: Latin, Cyrillic, Hebrew, Chinese, etc., and in any language environment. Advanced Data Conversion We have implemented advanced Data Conversion mechanisms that provide bi-directional mapping between any Salesforce and ODBC data types.

• Devart ODBC Driver for Salesforce 2.2.1

  Salesforce ODBC driver (32/64 bit)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. Our ODBC driver fully supports standard ODBC API functions and data types and enables easy access to live Salesforce data from anywhere.

  Devart ODBC Driver for Salesforce for Windows 10 – Full description

  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. Our ODBC driver fully supports standard ODBC API functions and data types and enables easy access to live Salesforce data from anywhere. Key Features: * Support for Windows 11 * 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 – Subqueries – GROUP statements – Aggregation functions – ORDER statements, etc. * DML Operations 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.

  Allow ODBC-based applications to access Salesforce databases in a convenient way using this ODBC connector for Salesforce, compatible with both 32-bit and 64-bit apps

  What’s new in ODBC Driver for Salesforce 2.2.1:

  • Added support for Windows 11
  • Improved compatibility with Linked Server in MSSMS
  • Improved compatibility with FICO Mosel
  • Improved compatibility with FileMaker

  READ THE FULL CHANGELOG 

  ODBC Driver for Salesforce is a cross-platform and powerful utility that allows users to enable Salesforce database access to ODBC-based applications in a convenient manner. This driver provides developers with full support for ODBC API functions, thus enhancing its overall accessibility and also improving database interaction for both 32-bit and 64-bit apps.

  Users can easily implement various useful features within their applications so that they connect directly to Salesforce databases without turning to additional database clients. Connections can be established directly through TCP or IP, therefore allowing users to benefit from more stable and fast interaction.

  ODBC Driver for Salesforce features complex functions that allow ODBC-based applications to handle Salesforce objects in a similar manner to SQL tables. Since it packs extended SQL syntax capabilities, users are provided with a wide spectrum of capabilities.

  Additionally, developers can perform multiple Salesforce updates by chaining several SQL statements and combining them into batches. This can help them simplify their work by applying numerous modifications simultaneously.

  This driver features full support for standard ODBC API functions and data types. Furthermore, users can implement various capabilities to their applications, thus rendering them able to connect to Salesforce from several ODBC-based platforms or environments.

  Data Conversion mechanisms are also implemented within ODBC Driver for Salesforce, thus allowing users to benefit from Salesforce-ODBC data types bi-directional mapping.

  Developers can easily benefit from this driver’s functions from a wide variety of data analysis tools. Some of them include Microsoft Office, Python, Microsoft Visual Studio or PHP.

  System requirements

  • Only one ODBC Driver for Salesforce version can be installed on PC in order to avoid incompatibility

  Limitations in the unregistered version

  • 30-day trial