Devart ODBC Driver for Magento allows Windows users to efficiently access Magento data using ODBC tools. With support for both 32-bit and 64-bit Windows, this enterprise-level solution is perfect for business users seeking connectivity for reporting, analytics, business intelligence, and extract, transform, load (ETL) processes.
One of the noteworthy features of this ODBC driver is its comprehensive support for standard ODBC API functions and data types, ensuring easy and convenient access to live Magento data from anywhere. This enables users to streamline their workflows and make more informed decisions while manipulating and analyzing Magento data using their preferred ODBC-aware application.
An exceptional feature of the Devart ODBC Driver for Magento is its compatibility with Windows 11. Additionally, users can establish connections to Magento objects directly via HTTPS, even when direct access to Magento servers is not available. This greatly improves accessibility to Magento data and can increase overall productivity.
Moreover, the driver includes support for DML (INSERT, UPDATE, DELETE) operations, allowing users to modify Magento data quickly and efficiently. Bulk updates can be executed effortlessly by combining SQL statements into batches, thus expediting and simplifying large-scale data modifications.
Another advantage of the Devart ODBC Driver for Magento is its full support for the common ODBC interface, including ODBC API Functions support, ODBC Data Types support, and Advanced Connection String parameters support. This means that users can connect to Magento from various environments and platforms that support ODBC, be it desktop or web-based applications.
Furthermore, the driver supports all data types defined in the Magento API and is fully compatible with the Magento API itself. The latest version of the Devart ODBC Driver for Magento can be downloaded from the official Devart website.
In conclusion, the Devart ODBC Driver for Magento is an essential software for those in need of a reliable connectivity tool to access Magento data. It enables users to work smoother and more efficiently, making it a must-have for anyone working with Magento.
Version 3.0.3:
*Improved compatibility with Microsoft Query
*Resolved an issue with data import into Microsoft Excel
Version 3.0.2: *Fixed bug with re-activation ODBC driver via another Windows user
Version 3.0.1:
*Now keys and passwords are stored in an encrypted form in the DSN record
*Renamed to ODBC Driver for Adobe Commerce
*Added metadata cache
Version 3.0.0:
*Now keys and passwords are stored in an encrypted form in the DSN record
*Renamed to ODBC Driver for Adobe Commerce
*Added metadata cache
Version 2.7.2:
*Fixed bug with driver license validation for Linked Server in MSSMS
*Fixed bug with reading DATETIMEs columns in Tableau
Version 2.7.1: *Oracle 23c, SQL Server 2022, and Maria DB 11 support.
Version 2.7.0:
*Added support for SQL_ATTR_MAX_ROWS attribute
*Improved compatibility with Linked Server in SQL Server
*Improved compatibility with Visual Basic in Visual Studio
*Improved compatibility with Alteryx
Version 2.6.0:
*Improved compatibility with Linked Server in SQL Server 2019
*Improved compatibility with Tableau Prep Builder
*Improved compatibility with Crystal Reports