Magento ODBC driver
Magento ODBC driver is an easy to use connectivity solution to access your Magento CMS data from popular applications like Microsoft Excel, Microsoft Access, LibreOffice, OpenOffice and many others.
ODBC driver is very useful for e-commerce business owners, website adminstrators and webmasters who online shops are running on Magento CMS. You can easily edit your Magento data (product cards or any data) through Excel spreadsheets or any other third-party application.
Magento ODBC driver supports bulk updates which means you can upload huge ammounts of data to Magento database in a nick of time.
This ODBC driver for Magento is also useful for Magento developers who create various Magento apps and plugins which communicate with Magento cloud database.
With this ODBC driver you can establish connection to Magento from Microsoft Office, Visual FoxPro, LibreOffice, Crystal Reports, Visual Studio, Python, PHP, QlickView, OpenOffice and many others.
The driver is completely new and constantly improves. It is a good choise if you need a relialbe and long term solution with fast support from original developers.
Connection to Magento
Driver provides capabilities to establish connections to Magento cloud databases directly via HTTP. If you have no access to Magento via HTTP directly, you have also an ability to connect via Proxy using the options: Host, Port, Username, Password.
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
Devart ODBC Driver for Magento provides support for DML: INSERT, UPDATE, DELETE which allows you to modify data in Magento the same way as in SQL databases.
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.
Our ODBC driver has full support for Magento Field data types and, moreover, the driver is compatible with the Magento API itself.
Advanced Data Conversion
We have implemented advanced Data Conversion mechanisms that provide bi-directional mapping between any Magento and ODBC data types.
Fully Unicode Driver
With our fully Unicode driver, you can retrieve and work with any data from multi-lingual Magento databases correctly, not depending on whether its charset is Latin, Cyrillic, Hebrew, Chinese, etc., in any environment localization.
Final ConclusionEvery operation with Magento becomes significantly faster using such capabilities of our driver as Local data caching, connection pooling, query optimization and much more.
Product Reviews (0) Write a review
There are yet no reviews for this product.
Submit your review
First: rate the product. Please select a rating between 1 (poorest) and 5 stars (best)
Become a client on Cmsmart, you are protected strongly with our Client Protection Programe. Especially we built -in a strong Central Ticket Support system to help clients and partners working on the products item support after purchased.Go to item support
We are happy to provide the customization services to buyer of this product, please submit your request here and we will contact you ASAP