Devart ODBC Driver for SugarCRM provides a high-performance and feature-rich connectivity solution for ODBC-compliant applications to access SugarCRM data from Windows, both 32-bit and 64-bit.

Version: 1.6.1Devart ODBC Driver for SugarCRM provides a high-performance and feature-rich connectivity solution for ODBC-compliant applications to access SugarCRM data from Windows, both 32-bit and 64-bit.
License: Free To Try $149.95
Operating System: Windows
Homepage: www.devart.com
Developed by:
Full support for standard ODBC API functions and data types implemented in our driver makes interaction of your application with SugarCRM fast, easy and extremely handy.
Key features:
- Connection to SugarCRM
Our connectivity solution enables various ODBC-aware applications to connect to SugarCRM directly via HTTPS.
If you have no direct access to SugarCRM, 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 SugarCRM 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 SugarCRM provides support for DML (INSERT, UPDATE, DELETE) operations, which allows you to modify data in SugarCRM in the same way as in SQL databases.* Bulk Updates
Moreover, with our driver you can perform bulk updates to SugarCRM by combining SQL statements into batches, thus simplifying and speeding up large data modification with SugarCRM.* 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 SugarCRM from various environments and platforms, that support ODBC.* SugarCRM Compatibility Our ODBC driver fully supports all data types defined in the SugarCRM API.
Moreover, the driver is compatible with the SugarCRM API itself.
You can always find the latest version of the product on the official Devart website.
What's New
Version 1.6.1: * The ReturnForeignKeys connection option to significantly improve performance is added * Compatibility with Visual Studio is improved