Devart ODBC Driver for BigCommerce: Query Your Store With SQL From Excel, Access and BI Tools
Devart ODBC Driver for BigCommerce is a $139.95-per-year ODBC driver for Windows, macOS and Linux that turns a BigCommerce store into a set of SQL tables. Excel, Access, Power BI, Tableau, Crystal Reports, Python and other ODBC tools can then read orders, products and customers, and even write changes back, through the BigCommerce API.
Store owners and the people who report for them usually live with CSV exports and copy-paste. A driver like this replaces that with a live connection: refresh the spreadsheet and the numbers are current. It's a specialist tool, and it's priced for people who need it every week, not once a quarter.
Quick facts
- Version: 3.2.0, released October 16, 2026
- Developer: Devart
- Platforms: Windows Vista or later (32-bit and 64-bit, including Terminal Server) with .NET Framework 4.5, macOS on Intel and Apple Silicon, Linux x86 and x64 (DEB and RPM)
- Connects to: the BigCommerce API over HTTPS, versions 2 and 3, with a legacy token or OAuth, optionally through a proxy
- SQL: SELECT with JOINs, subqueries, GROUP BY and aggregates; INSERT, UPDATE and DELETE
- Price: $139.95 per year for a Desktop license on one platform, or $279.95 perpetual
- Trial: 30 days, activated with a trial key from a Devart account
- Refund: within 30 days of purchase, if a technical problem that support can't fix stops the driver from working
- What we checked: the Buy Now order page charged $139.95 for Desktop for Windows with a 1-year subscription, and the same cart showed $279.95 perpetual and $899.95 per year for Server Standard. The download page listed version 3.2.0 with a 76.64 MB Windows installer. All checked on November 13, 2026. We didn't install the driver or connect it to a store
Before you buy
You need BigCommerce API credentials: either a legacy API token or an OAuth Store ID, Client ID and Access Token from your store's control panel. The driver defaults to API version 2; switch to version 3 in the DSN for OAuth and the newer objects. Writes go straight to your live store, so test INSERT, UPDATE and DELETE on a sandbox or a copy of your data first. A subscription license needs internet access to activate and to check the license.
Download Free Trial Buy Now
Overview
BigCommerce keeps your store data behind a REST API. Devart ODBC Driver for BigCommerce sits between that API and any ODBC program: it translates SQL into API calls and returns the results as rows and columns. To Excel or Access, the store looks like a database. You set it up once as a DSN with your store address and credentials, and every ODBC tool on that computer can use it.
The driver is part of Devart's line of more than 90 ODBC drivers and shares their framework: the same DSN dialog, full ODBC API support, Unicode data, and a tested-tool list that includes Power BI, Tableau, Qlik Sense, Crystal Reports, Alteryx, SQL Server Management Studio, Excel, Access, LibreOffice, FileMaker, Delphi, Visual Studio, PHP and Python.
Features
SQL over your store
Devart ODBC Driver for BigCommerce accepts SQL-92 SELECT statements with JOINs, WHERE conditions, subqueries, GROUP BY, aggregate functions and ORDER BY, so you can ask questions the BigCommerce control panel can't answer in one screen, such as revenue by product category per month or customers with more than three orders. The driver works out the API calls behind the scenes.
Write changes back
Devart ODBC Driver for BigCommerce supports INSERT, UPDATE and DELETE, so you can bulk-edit product prices from an Access form or an Excel sheet, or update records from an ETL job. Version 2.4.3 fixed updates to the ProductCustomFields table, a sign that writing is actively used and maintained.
API 2 or 3, token or OAuth
Devart ODBC Driver for BigCommerce connects with Basic authentication (user ID and legacy token) or OAuth (Store ID, Client ID and Access Token), and lets you choose BigCommerce API version 2.0 or 3.0, which decides which objects and fields you see. If your network blocks direct HTTPS to BigCommerce, a proxy server, port and login can be set in the DSN. Tokens are stored encrypted in the DSN since version 2.4.
Options for speed and for picky tools
Devart ODBC Driver for BigCommerce has a metadata cache (added in 2.4) so tools don't re-read the store's structure on every connection, a ReturnForeignKeys switch to skip slow foreign key lookups, a query timeout, and a UTC Dates option to choose between UTC and local time. ANSI or Unicode strings and ODBC 2.x behavior help older tools.
Windows, Mac and Linux
Devart ODBC Driver for BigCommerce was Windows-only until version 2.0.1 (September 2022) added macOS and Linux; Apple Silicon followed in 2.3.0 (August 2023), and version 3.0 (November 2025) added a graphical configuration window on Mac and Linux. On Windows it needs .NET Framework 4.5 or later, and an MSI package is available for Group Policy deployment.
Benefits
- Live reports instead of exports. A refresh in Excel or Power BI pulls current orders and stock, without downloading CSV files.
- Bulk edits with familiar tools. Update prices or product fields from a spreadsheet or Access table rather than one product at a time.
- Join store data with other data. In Access, Power BI or a SQL Server linked server, combine BigCommerce orders with accounting or warehouse data.
- No programming. SQL in a familiar tool replaces writing code against the BigCommerce API.
Real-World Uses
- Weekly sales dashboard. A store manager connects Power BI to the DSN and builds a dashboard of sales by product and region that refreshes itself.
- Price update from a spreadsheet. An e-commerce assistant links the products table in Access and updates hundreds of prices with one UPDATE query.
- Merging with accounting. A bookkeeper pulls BigCommerce orders into Excel next to the accounting export to reconcile payouts.
- Warehouse sync. An IT team reads new orders into an in-house SQL Server through a linked server for picking and shipping.
Who It's For, and Who Should Skip It
Devart ODBC Driver for BigCommerce is for BigCommerce merchants, agencies and analysts who report on store data often, want to edit it in bulk from familiar tools, or need to join it with other systems, and who'd rather write SQL than code.
Skip it if you only need an occasional sales report: the BigCommerce control panel's analytics and exports cost nothing extra. Developers comfortable with the REST API can call it directly. If you also need data from other platforms, Devart's ODBC Universal Bundle starts at $499.95 per year for all its ODBC drivers.
Usage Guide
- In your BigCommerce control panel, create API credentials: a legacy API token, or an API account that gives you a Client ID and Access Token for OAuth.
- Download the driver for your system from the trial link (a free Devart account is needed): EXE or MSI for Windows, PKG for macOS, DEB or RPM for Linux, and install it.
- Open the ODBC Data Source Administrator that matches your application's bitness (32-bit or 64-bit) and add a data source with Devart ODBC Driver for BigCommerce.
- Activate the driver on the License tab with the trial or purchased key from your registration email or the Devart Customer Portal; the trial needs activating too.
- Choose the API version and authentication, enter the store address and token, or the Store ID, Client ID and Access Token, add proxy details if needed, and click Test Connection.
- In Excel, Access or your BI tool, pick ODBC and choose the DSN. An OAuth connection string looks like
DRIVER={Devart ODBC Driver for BigCommerce};Authentication=OAuth;Store ID=...;Client ID=...;Access Token=....
Tip
Every query becomes API calls, and big stores have a lot of orders. Filter with WHERE on dates or status rather than pulling whole tables, and turn off ReturnForeignKeys if a tool is slow to list tables.
Where It Falls Short
- API speed, not database speed. Queries run through the BigCommerce API, so large pulls and complex JOINs take longer than they would against a real database.
- A large install. The Windows installer is 76.64 MB and needs .NET Framework 4.5, much bigger than Devart's database drivers.
- Per-user, per-platform licensing. A Desktop license covers one user at a time on one OS; a shared server or gateway needs Server Standard at $899.95 per year.
- Little independent feedback. We found no reviews of the BigCommerce driver on its own, so the trial is the only real test.
What Users Say
We found no reviews of the BigCommerce driver itself in November 2026; review sites file Devart's ODBC drivers as one product. The figures below cover the whole line and came from the sites' listings through search summaries, since the review pages block automated reading.
Ratings and comments for Devart ODBC drivers
Capterra shows 4.7 out of 5 from 26 reviews of Devart ODBC Drivers, G2 about 4.5 to 4.6 out of 5 from 17 to 18 reviews, and TrustRadius 5.2 out of 10 from 58 ratings.
Reviewers praise reliability ("Great product. Very Reliable." on Capterra), easy installation and DSN setup, and support that fixed a problem another vendor's driver had left unresolved for two years.
The complaints are about cost and licensing: a TrustRadius reviewer wrote that "Prices are still high", others disliked needing a license per user and wanted more how-to documentation, and a Capterra reviewer got conflicting answers from support on which license suits a network.
Take these as a view of Devart as a vendor. For a cloud-API driver like this one, test speed and the objects you need with your own store during the trial.
Comparisons
ODBC driver vs. control panel exports
BigCommerce's own exports and analytics are free and enough for occasional reports. Devart ODBC Driver for BigCommerce costs $139.95 per year but gives you live data in any ODBC tool, SQL queries across objects, and the ability to write changes back, which exports can't do.
API version 2 vs. version 3
Devart ODBC Driver for BigCommerce defaults to API version 2.0 with Basic authentication. Version 3.0 with OAuth changes the objects and fields you see. If a table or field you expect is missing, switch the API Version in the DSN before assuming the driver lacks it.
Desktop vs. Server editions
Desktop is one person on one computer. A reporting server, Power BI gateway or web server that several people use needs Server Standard (up to 6 cores) or Server Enterprise. Site licenses cover a whole company, and OEM lets you ship the driver inside your own app.
Editions and Pricing
| Edition | Subscription (1 year) | Perpetual | Who can use it |
|---|
| Desktop (Windows, macOS or Linux) | $139.95 | $279.95 | One user at a time on one computer |
| Server Standard (Windows, macOS or Linux) | $899.95 | $1,799.95 | Many users on one server with up to 6 cores |
| Server Enterprise, Site, OEM | On request | On request | Any core count, a whole company, or redistribution |
Each license is for one platform and includes a year of support and upgrades. A Desktop subscription paid up front costs $279.95 for two years and $419.95 for three. Priority support is extra, and Devart takes 5, 10 or 15 percent off for 5, 10 or 20 copies. The Buy Now button opens the order page set to Desktop for Windows with a 1-year subscription; you can change the edition, platform and term there.
FAQs
Does Devart ODBC Driver for BigCommerce support OAuth?
Yes. Devart ODBC Driver for BigCommerce supports OAuth with a Store ID, Client ID and Access Token, for API versions 2.0 and 3.0, as well as Basic authentication with a legacy token.
Can I change product prices in BigCommerce from Excel or Access?
Yes. Devart ODBC Driver for BigCommerce supports UPDATE, INSERT and DELETE, so a linked table in Access or an ODBC tool that writes back can change store data. Test on a sandbox first, since changes are live.
Does it work on a Mac?
Yes. Devart ODBC Driver for BigCommerce has had a macOS version since 2.0.1 in 2022, with Apple Silicon support since 2.3.0 and a graphical configuration window since 3.0.
Do I need .NET installed?
On Windows, yes. Devart ODBC Driver for BigCommerce needs .NET Framework 4.5 or later and runs on Windows Vista and newer.
Can I connect through a corporate proxy?
Yes. Devart ODBC Driver for BigCommerce has proxy server, port, user and password settings in the DSN for networks without direct HTTPS access to BigCommerce.
What happens when the subscription ends?
Devart ODBC Driver for BigCommerce on a subscription works only during the paid term and checks the license online. A perpetual license keeps the version you bought working indefinitely.
System Requirements
- Windows Vista or later, 32-bit or 64-bit, with .NET Framework 4.5 or later (76.64 MB EXE or 92.64 MB MSI installer)
- macOS on Intel x64 or Apple Silicon (78.94 MB PKG)
- Linux x86 or x64, DEB or RPM packages (about 29 to 31 MB)
- A BigCommerce store with API credentials (legacy token or OAuth)
- Internet access to BigCommerce over HTTPS, and to activate a subscription license
Conclusion
Devart ODBC Driver for BigCommerce is worth $139.95 a year if you report on or bulk-edit BigCommerce data regularly and want to do it in Excel, Access or a BI tool with SQL instead of exports or code. It's current, maintained twice a year, supports OAuth and API 3, and runs on all three desktop platforms.
If you only need a report now and then, BigCommerce's own exports are enough. Otherwise, use the 30-day trial on your real store, check that the tables you need appear under the API version you choose, and time a typical report before you buy.
Download Free Trial Buy Now