Magento ODBC driver

Connectivity solution which helps to connect your application with Magento cloud database

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

magento connection

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
- Subqueries
- GROUP statements
- Aggregation functions
- ORDER statements

DML Operations

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.

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.

Magento Compatibility

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 Conclusion

Every 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)

Write review

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
{{(items | filter:search).length }} comments
  • Date: {{item.created| date:'MM/dd/yyyy h:mma'}}
We will NOT remove negative comments unless they are abusive or offensive. Once a comment has been reported it cannot be retracted and will be sent to moderators for review.
{{itemreply.user.username}} {{itemreply.user.username}} {{itemreply.user.username}} {{itemreply.user.username}}
  • Date: {{itemreply.created| date:'MM/dd/yyyy h:mma'}}
We will NOT remove negative comments unless they are abusive or offensive. Once a comment has been reported it cannot be retracted and will be sent to moderators for review.
No comment
Login and write a review

We are happy to provide the customization services to buyer of this product, please submit your request here and we will contact you ASAP

Submit Request Customized
Request Subject(*)
Detail Request(*)

Change log

This is a Magento® Extensions
Product rating: 5 star rating | Write a review 5/5 based on 1 rating(s)

Magento 2.0.x

{{comments}} comments Ask Partner

Member Since: 2016, Jul 20

1 Items
Client Rating:

0 average based on 0 ratings

Download this items

$149.00 Regular License

You can use the product for your own website or your clients website if you are developer. You need to provide purchase license during support and upgrade new version.

Domain License Under a 1 domain License for the item you are granted a non-exclusive non-transferable permission to use the item on a single site.

If you plan to use the product on other domains, you SHOULD buy now to SAVE much better than buying separated order.
You will be rewarded 74 Points ($7.4)

Partner products