Devart ODBC Driver for Magento provides a high-performance and feature-rich connectivity solution for ODBC-compliant applications to access Magento data from Windows, both 32-bit and 64-bit. Full support for standard ODBC API functions and data types implemented in our driver makes interaction of an external application with Magento fast, easy and extremely handy.
*Connection to Magento Our connectivity solution enables various ODBC-aware applications to connect to Magento directly via HTTPS. If you have no direct access to Magento, 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 Magento 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.
* DML Operations Devart ODBC Driver for Magento provides support for DML (INSERT, UPDATE, DELETE) operations, which allows you to modify data in Magento in the same way as in SQL databases.
* Bulk Updates Moreover, with our driver you can perform bulk updates to Magento by combining SQL statements into batches, thus simplifying and speeding up large data modification with Magento.
* 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 Magento from various environments and platforms, that support ODBC.
* Magento Compatibility Our ODBC driver fully supports all data types defined in the Magento API. Moreover, the driver is compatible with the Magento API itself.
You can always find the latest version of the product on the official Devart website.
SqlLobEditor is a database tool that helps DBA and Database Programmer edit Sql Server LOB (text, ntext, image) data directly. It can import/export LOB data also.
Downloads: 100555 - Shareware - Download Now
MySQL Turbo Manager is a powerful software solution for MySQL Database administration and development. With our very intuitive interfase you will save time and money.
Downloads: 68108 - Shareware - Download Now
EasyQuery.NET Silverlight: an unique set of components which allows you to include end-user-oriented query builder into your Silverlight application and provides your users with a natural language interface for their database requests.
Downloads: 100030 - Shareware - Download Now
DBSync for Oracle and Access is a tool for a quick and accurate database conversion and synchronization from Oracle to Access database. Unicode support, Primary keys and Indexes conversion, sessions support. Insert, Update and Drop sync.
Downloads: 66753 - Shareware - Download Now
DTM Data Generator for Excel is a tool that generates test Excel spreadsheets. The tool provides dozens built-in data generators: address, phone, e-mail, name, etc. The value library makes data more realistic. Custom generators are also available.
Downloads: 47908 - Demo - Download Now