Devart ODBC Driver for Shopify: Your Store's Data in Excel, Power BI and SQL Server
Devart ODBC Driver for Shopify is a Windows ODBC driver that lets Excel, Power BI, Tableau, Qlik, Access, SQL Server and scripts query a Shopify store with SQL and write changes back. It signs in with a Shopify Admin API access token or an app's Client ID and Secret, and costs $109.95 a year for one Windows desktop.
Shopify's own reports cover the basics, but merchants and their accountants soon want store data next to other numbers: ad spend, warehouse stock, the accounting system. Exporting CSVs every week gets tedious and goes stale. An ODBC driver turns the store into a data source your existing tools can refresh on demand.
Quick facts
- Version: 2.1.0, released October 16, 2026; version 2.0.0 (April 2026) added Shopify API version 2 and draft-order properties
- Developer: Devart
- Operating systems: Windows Vista or later, 32-bit and 64-bit, including Terminal Server; .NET Framework 4.5
- Authentication: Admin API access token from a custom app (the default), or Client ID and Client Secret from an app built in Shopify's Dev Dashboard
- SQL: SELECT with joins, subqueries, grouping and aggregates; INSERT, UPDATE and DELETE
- Price: $109.95 a year, or $219.95 perpetual, for Desktop for Windows
- Trial: 30 days with every feature
- Refunds: Devart refunds in full within 30 days of purchase only when support can't fix a technical problem or bug that stops the driver working (its ordering FAQ)
- What we checked: the order page priced ODBC Driver for Shopify at $109.95 for the default Desktop for Windows edition on a 1-year subscription renewing yearly, and the download page listed version 2.1.0 with a 35.44 MB EXE and a 39.46 MB MSI, both on November 15, 2026. We didn't connect it to a Shopify store
Before you buy
You need to be the store owner, or a staff member allowed to develop apps, because the driver connects through an app you create in your own Shopify admin. The scopes you grant that app decide what the driver can read and change, so grant read-only scopes if reporting is all you want. If the app needs customers' personal data, Shopify requires you to request access to protected customer data first.
Download Free TrialBuy Now
Overview
Devart launched the Shopify driver in March 2023. Its biggest update came in April 2026: version 2.0.0 added support for a second Shopify API version, which is now the default, plus properties on draft-order details. Earlier releases fixed updating Shopify data from Microsoft Access, Tableau date columns and SQL Server linked-server licensing, and started encrypting tokens stored in the DSN.
The connection itself needs two things: your store's URL and a credential from an app in your store. Devart documents both routes step by step, from enabling custom app development to copying the Admin API access token, or building an app in the Dev Dashboard and pointing its redirect URL at one of the localhost addresses the driver listens on.
Features
Two Shopify sign-in methods
Devart ODBC Driver for Shopify defaults to AccessToken authentication, where you paste the Admin API access token from a custom app with the Admin API scopes you chose. The CustomApp method instead uses a Client ID and Client Secret from an app built and released in Shopify's Dev Dashboard, with redirects to http://localhost:58187 or one of three other local ports. A Store field holds your shop's URL, and an API Version setting picks version 1 or 2.
Store data as SQL tables
Devart ODBC Driver for Shopify presents the store's objects as tables you can filter, join, group and sort with SQL-92 SELECT statements. A BI tool sees them in its table list, and you can push a WHERE clause down so Power BI loads last month's records instead of the whole history.
Changes written back to the store
Devart ODBC Driver for Shopify supports INSERT, UPDATE and DELETE, as far as your app's scopes allow. That makes bulk edits possible from an Access form or a script, such as adjusting many records from a spreadsheet of corrections, instead of clicking through the admin one item at a time.
Guides for 47 tools
Devart ODBC Driver for Shopify comes with Devart setup guides for 47 tools, including Excel, Power BI, Tableau, Qlik Sense, QlikView, Domo, MicroStrategy, TARGIT, TIBCO Spotfire, SSMS, Alteryx, Informatica, RStudio, MATLAB, Python, PHP and Node.js.
Benefits
- Store numbers next to everything else. Join Shopify data with ad spend, accounting or warehouse data in one report.
- Refresh instead of re-export. A workbook or dashboard updates from the live store with one click.
- Control over what's exposed. Because access runs through your own app, you decide the scopes and can revoke them in Shopify at any time.
Real-World Uses
- A store owner builds an Excel workbook of daily orders by product and channel that refreshes each morning.
- An agency's analyst connects Power BI to a client's store and combines it with marketing spend for a return-on-ad-spend dashboard.
- An accountant pulls the month's orders through ODBC into an Access database that reconciles them against payouts.
- A company with its own ERP on SQL Server adds a linked server so nightly jobs copy Shopify orders into the ERP's tables.
- A merchandiser corrects a batch of records from a spreadsheet with UPDATE statements instead of editing each one in the admin.
Who It's For, and Who Should Skip It
It's for Shopify merchants, agencies and finance or BI staff on Windows who report in Excel, Power BI, Tableau, Qlik or SQL Server and want live store data without writing API code.
Skip it if Shopify's built-in analytics and exports already cover your needs, or if a Shopify app from the App Store already syncs your data to the tool you use. Developers comfortable with Shopify's API may prefer to call it directly. And it doesn't run on a Mac, which many small merchants use.
Usage Guide
- In Shopify admin, open Apps, then App and sales channel settings, click Develop apps and allow custom app development.
- Create an app, configure its Admin API scopes, save, and install it on the store.
- On the app's API credentials tab, copy the Admin API access token.
- Install the driver from its EXE or MSI and pick Trial evaluation or enter your activation key.
- In the ODBC Data Source Administrator of the right bitness, add a DSN for Devart ODBC Driver for Shopify, enter the store URL and the access token, and click Test Connection.
- Pick the DSN in Excel's Get Data > From ODBC, Power BI or your BI tool and select the tables.
Where it falls short
- Setting up the app is the hardest part for non-technical owners; Shopify's admin menus for custom apps have moved before, so expect screens to differ slightly from guides.
- Shopify throttles API traffic, so pulling a large order history into a BI model takes time; filter in SQL to keep refreshes small.
- Writes go live in your store immediately, so test UPDATE and DELETE on a development store first.
- There's no macOS or Linux version.
What Users Say
How the Devart ODBC line rates
No one has reviewed the Shopify driver on its own yet. Capterra scores Devart ODBC Drivers as a family at 4.7 out of 5 from 26 reviews, written mostly by database and Salesforce users, who praise the simple install and stable connections and grumble about the price. Merchants should judge the Shopify driver on their own store during the free 30 days.
Comparisons
ODBC Driver vs Devart Excel Add-in for Shopify
Devart also sells an Excel Add-in for Shopify that works only inside Excel. Pick the add-in if Excel is the only place you'll ever use the data. Pick the ODBC driver if you also need Power BI, Tableau, Access, SQL Server or scripts.
ODBC Driver vs Shopify's own exports
Shopify's admin can export orders, products and customers to CSV for free, but each export is a one-off file. The driver gives a live, queryable connection that refreshes and can write back, which is worth paying for once you rebuild the same report every week.
Editions and Pricing
One Buy Now button covers every edition: the order page opens with Desktop for Windows on a 1-year subscription, and you change the edition, subscription or perpetual license, and term there.
| Edition | 1-year subscription | Perpetual | Licensed for |
| Desktop for Windows | $109.95 | $219.95 | A single computer, one user at a time |
| Server Standard for Windows | $799.95 | $1,599.95 | A server with up to 6 cores and concurrent users |
| Server Enterprise, Site, OEM | Quote | Quote | Bigger servers, a whole company, or redistribution |
FAQs
Can I connect several Shopify stores?
Yes, with one DSN per store. Devart ODBC Driver for Shopify's connection has a single Store URL and its own token, so each store gets its own data source, and a BI tool can combine them.
Which Shopify API version should I choose?
Usually the default. Devart ODBC Driver for Shopify added API version 2 in release 2.0.0 and sets the version by default according to the authentication type you pick, with version 1 still selectable in the API Version setting.
Can I use the Shopify driver from Python?
Yes. Devart ODBC Driver for Shopify works with any ODBC client, and Devart publishes Python, PHP, Node.js and R connection guides. You connect with the DSN name or a connection string holding the store URL and access token.
Is the access token safe in the DSN?
Devart ODBC Driver for Shopify has stored tokens and passwords encrypted in the DSN since version 1.2.0. Anyone who can use that DSN on the PC can still query the store, so use a System DSN only on machines you control.
Do I need a Server license for a scheduled refresh?
Yes, if the refresh runs on a shared server or several people use the connection at once. Devart's Desktop license for ODBC Driver for Shopify allows one computer used by one person at a time; a reporting or SQL Server machine needs Server Standard or Server Enterprise.
System Requirements
- Windows Vista or later, 32-bit or 64-bit, including Windows Terminal Server
- .NET Framework 4.5 or later
- A Shopify store where you can create a custom app (Admin API access token) or a Dev Dashboard app (Client ID and Client Secret)
- HTTPS access to Shopify, directly or through a proxy
Conclusion
If you run Shopify reporting in Excel, Power BI or SQL Server every week, Devart's driver is worth $109.95 a year: one connection gives every Windows tool live store data, SQL filtering, and write-back for bulk fixes. The reason to skip it: setting up a Shopify app and scopes is a technical step some owners won't want, and the driver is Windows-only, so Mac-based merchants should look elsewhere.
Download Free TrialBuy Now