Devart ODBC Driver for Magento (Adobe Commerce): Store Orders, Products and Customers in SQL
Devart ODBC Driver for Magento, which Devart now sells as ODBC Driver for Adobe Commerce, is a Windows ODBC driver that lets Excel, Power BI, Crystal Reports, Access, SQL Server and other ODBC tools query a Magento or Adobe Commerce store's products, customers and shipments with SQL. It works with Magento 2.x and Adobe Commerce as well as old Magento 1.x stores, and costs $139.95 a year for one desktop.
Store admins know the pain: Magento's admin grids are fine for one order at a time, but questions like "which customer group bought what last quarter" mean exports, spreadsheets and VLOOKUPs. With this driver, the store's data shows up as tables you can query directly.
Quick facts
- Version: 3.3.0, released October 16, 2026
- Developer: Devart (renamed from ODBC Driver for Magento to ODBC Driver for Adobe Commerce in version 3.0.0, March 2024)
- Platform: Windows Vista or later, 32-bit and 64-bit, Terminal Server included; .NET Framework 4.5
- Store versions: Adobe Commerce and Magento 2.x (store URL, API user, password) or Magento 1.x (store URL, API user, API key)
- Example tables: Products, Customers, CustomerGroups, SalesOrderShipments, SalesOrderShipmentItems
- Price: $139.95 a year or $279.95 perpetual for Desktop for Windows
- Trial: 30 days, full features
- Refunds: full refund within 30 days if a technical problem stops the driver working and Devart support can't fix it
- What we checked: the order page listed the product as ODBC Driver for Adobe Commerce at $139.95 in its default configuration (Desktop for Windows, 1-year subscription renewing yearly, no premium support), and the download page offered version 3.3.0 as a 32.82 MB EXE or 36.71 MB MSI, both on November 14, 2026. We didn't connect it to a store
Before you buy
The driver's Version setting defaults to Ver1, the Magento 1.x mode. On any Magento 2 or Adobe Commerce store, change it to Ver2 or the connection won't work. You'll also need an API user created in the store's admin panel. Because the driver can write to the store, give that user only the access your reports need. Windows only.
Download Free TrialBuy Now
Overview
Devart has sold this driver since July 2016, first for Magento 1, then from February 2018 for Magento 2 as well. When Adobe folded Magento Commerce into its Adobe Commerce brand, Devart followed in March 2024 and renamed the driver; the product page still lives at the old Magento address and the driver still connects to open-source Magento stores.
Devart's sample queries show what the tables look like. One finds the heaviest product of each product type from Products. Another joins Customers to CustomerGroups on the group ID to list everyone in the "General" group. A third pulls SKU, name, price and quantity from SalesOrderShipmentItems joined to SalesOrderShipments. That's real store reporting in plain SQL.
Features
Catalog, customer and fulfilment data as tables
Devart ODBC Driver for Magento maps store entities such as products, customers, customer groups and shipments to SQL tables, and runs SQL-92 SELECT statements over them with joins, subqueries, GROUP BY and aggregates like MAX and COUNT.
Magento 1 and Magento 2 in one driver
Devart ODBC Driver for Magento keeps both connection modes: Ver1 for Magento 1.x signs in with the store's admin URL, an API user and an API key; Ver2 for Magento 2.x and Adobe Commerce uses the store URL, API user and password. A sample connection string is DRIVER={Devart ODBC Driver for Adobe Commerce};Version=Ver2;Domain=http://myhost/magento;User ID=admin;Password=....
Updates back to the store
Devart ODBC Driver for Magento supports INSERT, UPDATE and DELETE and batched bulk updates, so product attributes or customer data can be changed from Access, Excel-based tools or SQL scripts.
Faster metadata and tool fixes
Devart ODBC Driver for Magento added a metadata cache in version 3.0.0, which cuts the delay when a BI tool lists a large store's tables, and a ReturnForeignKeys switch (off by default) for the same reason. Its release notes include fixes for Power BI Desktop, Excel, Power Pivot, Crystal Reports, FileMaker, Access date fields and SQL Server linked servers.
Benefits
- Answers without exports. Store questions become saved queries that refresh on demand.
- Store data in the company's BI. Join sales and customers with accounting, ads or warehouse data in Power BI or SQL Server.
- Survives a platform upgrade. The same driver covers Magento 1 and Magento 2, which helps during a migration.
Real-World Uses
- Shipping report. Operations lists items shipped per SKU per week from the shipment tables in Excel.
- Customer group analysis. Marketing compares wholesale and retail customers by joining Customers with CustomerGroups in Power BI.
- Catalog audit. A merchandiser queries Products for items with missing weights or prices before a shipping-rate change.
- Migration check. During a Magento 1 to Magento 2 move, a developer compares row counts on both stores through two DSNs.
Who It's For, and Who Should Skip It
It suits merchants, ecommerce analysts and agencies that report on Magento or Adobe Commerce stores in Windows tools, and developers who need store data in legacy Windows software.
Skip it if you have direct read access to the store's MySQL database and are comfortable with its schema, since a free MySQL driver gets you there (at the cost of working with Magento's complex table structure). Also skip it on Mac or Linux, or if Adobe Commerce's built-in reports already cover you. Devart's Excel Add-in, dotConnect and SSIS components for Adobe Commerce cover Excel-only, .NET and ETL use.
Usage Guide
- In the store admin, create an API user (and, for Magento 1, an API key) for the driver.
- Download ODBC Driver for Adobe Commerce from Devart (login required), install it, and choose the trial or your activation key.
- Add a DSN in the ODBC Data Sources tool that matches your program's bitness.
- Set Version to Ver2 for Magento 2 or Adobe Commerce, enter the store's Domain, User ID and Password, and test the connection.
- Open Excel, Power BI or Crystal Reports, pick the DSN, and start with the Products or Customers table.
Where it falls short
- API speed. Large catalogs and order histories come through the store's web API page by page, which also puts load on the store server.
- Confusing default. The Ver1 default is a leftover from Magento 1 and trips up Magento 2 users.
- Naming. After the rename, the driver appears as "Devart ODBC Driver for Adobe Commerce" in ODBC lists, so look for that name, not Magento.
- Windows only, and the subscription license needs internet access to activate and verify.
What Users Say
The Magento/Adobe Commerce driver doesn't have published user reviews of its own. Here's the picture for Devart's ODBC drivers as a whole.
Devart ODBC line on review sites
Devart ODBC Drivers average 4.7 out of 5 on Capterra (26 reviews) and 4.6 out of 5 on G2 (18 reviews). Easy installation and speed draw the most praise. Price is the most common complaint, and some reviewers found the first DSN setup and the credential documentation harder than they expected.
Devart customer story (xBase driver)
Cargohouse, on ODBC Driver for xBase: "Our customers were happy to receive order information within moments..."
Comparisons
API driver vs. a MySQL driver on the store database
A MySQL ODBC driver reads Magento's database directly and fast, but you need database access (often impossible on managed hosting or Adobe Commerce Cloud) and must navigate Magento's EAV tables. Devart's driver goes through the store API with friendly table names and works wherever you have an API user.
ODBC driver vs. Excel Add-in for Adobe Commerce
Devart's Excel Add-in loads and edits store data inside Excel only. The ODBC driver serves every ODBC program, including Power BI, Crystal Reports, Access and SQL Server.
Editions and Pricing
The edition and license type are options on one order page.
| Edition | For | 1 year | Perpetual |
|---|
| Desktop for Windows | One PC, one user at a time | $139.95 | $279.95 |
| Server Standard for Windows | One server up to 6 cores, multiple users | $899.95 | $1,799.95 |
| Server Enterprise / Site / OEM | Unlimited cores, all company PCs, or redistribution | Quote | Quote |
Buy Now opens the default order, Desktop for Windows on a 1-year subscription at $139.95, under the name ODBC Driver for Adobe Commerce. Longer terms, perpetual licenses and Server editions are chosen on the same page, and 5 or more copies get a volume discount.
FAQs
Is Devart ODBC Driver for Adobe Commerce the same product as the Magento driver?
Yes. Devart ODBC Driver for Magento was renamed ODBC Driver for Adobe Commerce in version 3.0.0 (March 2024); it's the same driver, same product page and same license, and it still connects to open-source Magento stores.
Does the Magento ODBC driver still support Magento 1?
Yes. The Magento ODBC driver's Ver1 mode connects to Magento 1.x stores with an API user and API key, and Ver2 handles Magento 2.x and Adobe Commerce.
Does Devart's Magento driver need database access to the store?
No. Devart's Magento driver connects through the store's web API with an API user, so it works on hosted stores where you can't reach the MySQL database.
Can I run the Adobe Commerce ODBC driver on a report server for several users?
Yes, with a Server license. The Adobe Commerce driver's Desktop license covers one computer and one user at a time; Server Standard ($899.95 a year) covers a server of up to 6 cores with concurrent users.
What is the refund policy for Devart's Magento driver?
Devart refunds the Magento driver within 30 days of purchase only when a technical problem keeps it from working and support can't fix it. Use the 30-day trial against your store first.
System Requirements
- Windows Vista or later, 32-bit or 64-bit, including Terminal Server
- .NET Framework 4.5 or later
- An Adobe Commerce, Magento 2.x or Magento 1.x store with an API user, reachable over HTTPS (proxy supported)
- Administrator rights to install
Conclusion
Devart ODBC Driver for Magento (Adobe Commerce) is worth $139.95 a year for store teams that report on products, customers and shipments in Excel, Power BI or Crystal Reports and can't, or don't want to, work with Magento's raw database. It's long-maintained and covers both Magento 1 and 2. The reasons to pass: Windows only, API-bound speed on big stores, and if you already have MySQL access and know the schema, a free driver can do the job. Remember to switch Version to Ver2 when you try it.
Download Free TrialBuy Now