Devart ODBC Driver for Stripe: Charges, Customers and Invoices in Excel and Power BI
Devart ODBC Driver for Stripe is a Windows ODBC driver, $109.95 a year for one user, that connects Excel, Access, Power BI, Tableau, SQL Server and scripts to a Stripe account. With your account ID and secret API key in the setup dialog, Stripe data such as charges, customers, invoices and events can be queried with SQL like tables in a database.
Finance teams on Stripe know the routine: download a CSV from the Dashboard, paste it into the month-end workbook, repeat next month. The driver lets that workbook, or a Power BI report, read Stripe directly, and lets you join payments with the accounting or CRM data that Stripe doesn't have.
Quick facts
- Version: 1.8.0, released October 16, 2026 (first released December 15, 2021)
- Developer: Devart
- Platform: Windows Vista or later, 32-bit and 64-bit, Terminal Server included, .NET Framework 4.5 or later
- Sign-in: Stripe account ID (starts with acct_) and a secret API key
- Connection: a DSN, or a DSN-less connection string for scripts and automated jobs
- Price: $109.95 per year for Desktop, $219.95 perpetual
- Trial: 30 days from installation, with a trial key from a Devart account
- Refund: within 30 days only when a technical problem support can't fix stops the driver
- What we checked: the order page charged $109.95 for Desktop for Windows on a 1-year subscription. The download page listed version 1.8.0 with a 32.41 MB EXE and a 36.50 MB MSI. All checked on November 14, 2026. We didn't install the driver or connect it to a Stripe account
Before you buy
The driver asks for a secret API key, which carries the power of your Stripe account. Treat it like a password: store it only on PCs you control, and leave Save Secret Key unticked on shared machines. If you roll the key in the Stripe Dashboard, the DSN stops connecting until you paste the new one.
Download Free Trial Buy Now
Overview
Devart's Stripe connectivity covers charges, customers, invoices, events and other Stripe objects, and the driver shows them as SQL tables. You find the account ID in your Stripe account settings and the secret key on the API keys page of the Dashboard's Developers section, enter both in a DSN, and every ODBC application on the PC can connect.
Devart keeps tracking Stripe's own changes: version 1.5.0 in April 2025 added the PaidOutOfBand column and other columns to the Invoices table, so invoices marked as paid outside Stripe (by bank transfer, say) show up correctly in reports. Devart also publishes a step-by-step getting-started guide for this driver, with troubleshooting for rolled keys, timeouts and 32/64-bit mismatches.
The Stripe DSN dialog: an acct_ account ID, the secret key with Save Secret Key ticked, and proxy settings.
Features
Payments data as tables
Devart ODBC Driver for Stripe lets you run SQL-92 SELECT statements over Stripe objects, with JOINs, subqueries, GROUP BY and aggregates: revenue by customer, invoices overdue by month, or charges joined to the customers who made them.
Invoices with out-of-band payments
Devart ODBC Driver for Stripe includes the PaidOutOfBand column and other invoice fields added in version 1.5.0, which matters for accounts-receivable reports where some customers pay outside Stripe.
DSN or connection string
Devart ODBC Driver for Stripe works through a saved DSN for desktop tools, or a DSN-less connection string (Account Id and Secret Key) for Python, PHP or scheduled jobs where settings are managed in code.
Write support where Stripe allows
Devart ODBC Driver for Stripe lists INSERT, UPDATE and DELETE among its features. With payment data, use it carefully and test against Stripe's test mode keys before your live account.
Real-World Uses
- Month-end close. A bookkeeper refreshes a workbook of the month's charges and invoices instead of downloading CSVs.
- Receivables check. A controller lists open invoices by customer in Access, including the ones settled outside Stripe.
- SaaS metrics. An analyst joins Stripe customers with product usage from the app's database in SQL Server to look at revenue per active account.
- Dispute and refund review. A support lead pulls the month's charge data into Power BI to spot patterns by product.
Who It's For, and Who Should Skip It
Devart ODBC Driver for Stripe is for finance staff, bookkeepers and analysts on Windows who work in Excel, Access, Power BI or SQL Server and want Stripe data there live.
Skip it if Stripe's Dashboard reports and exports already cover your month-end, if you work on a Mac, or if you'd rather query Stripe inside Stripe with its own SQL reporting product, Sigma. Developers who already pull Stripe data through its API, or companies that sync Stripe into a data warehouse, don't need it either.
Usage Guide
- In the Stripe Dashboard, copy your account ID from the account settings and a secret key from Developers > API keys.
- Download the trial with the Download button (Devart account required) and run the EXE or MSI. During setup, choose Trial evaluation, or enter your activation key.
- Open ODBC Data Sources with your application's bitness, click Add and pick Devart ODBC Driver for Stripe.
- Enter the Account Id and Secret Key, choose whether to save the key, and click Test Connection.
- Open the DSN from Excel, Power BI or Access, or use a connection string from a script.
Tip
If a tool can't see the DSN, the usual cause is bitness: a 32-bit Excel only sees DSNs made in the 32-bit ODBC Data Source Administrator. Devart's own troubleshooting guide for this driver covers it.
Where It Falls Short
- Windows only. No Mac or Linux build is sold.
- Secret key handling. Anyone with the DSN and a saved key can read your Stripe data, so shared PCs need care.
- History takes time. Years of charges come through Stripe's API page by page, so first loads are slow.
- Per-user license. A shared gateway or reporting server needs Server Standard at $799.95 a year.
What Users Say
The Stripe driver has no reviews of its own on G2, Capterra or TrustRadius; those sites group all of Devart's ODBC drivers into one listing.
What the driver family's reviewers report
Ratings run from 4.7 out of 5 on Capterra (26 reviews) and 4.6 out of 5 on G2 (18 reviews) to 5.2 out of 10 on TrustRadius (58 ratings). The positive reviews talk about straightforward installation, dependable connections and a yearly price well under enterprise connectors. The negative ones are about the first weeks: writing SQL against an unfamiliar schema, unhelpful error messages, and in a few cases a driver that never connected on the reviewer's machine.
That points to the same advice for Stripe users: during the trial, rebuild one real report, such as last month's invoices, and check the totals against the Stripe Dashboard before you buy.
Comparisons
ODBC driver vs Stripe Dashboard exports
Dashboard exports are free and fine for occasional use. The driver is for reports you refresh every week or month and for joining Stripe with other systems, which exports make manual.
ODBC driver vs Stripe Sigma
Stripe Sigma runs SQL inside Stripe and is billed by Stripe. Devart's driver brings Stripe data out to your own tools, where it can meet data Stripe doesn't hold. If all your questions are about Stripe data alone, Sigma is the more direct option; if they cross systems, the driver fits better.
Editions and Pricing
Every edition is ordered with the Buy Now button; the order page offers the edition and the subscription or perpetual choice. Prices as listed on November 14, 2026.
| Edition | 1 year | Perpetual | Licensed for |
|---|
| Desktop for Windows (order page default) | $109.95 | $219.95 | One PC, one user at a time |
| Server Standard for Windows | $799.95 | $1,599.95 | One server, 6 cores max, many users |
| Server Enterprise, Site, OEM | Priced on request | Priced on request | Larger servers, device bands, redistribution |
A subscription needs an internet connection to activate and verify, and ends with its term; the perpetual license activates offline.
FAQs
Where do I find the account ID and secret key for the Stripe ODBC driver?
Devart ODBC Driver for Stripe needs the account ID from your Stripe account settings (it starts with acct_) and a secret key from the API keys page in the Dashboard's Developers section.
Can I test the Stripe driver without touching live payments?
Yes. Devart ODBC Driver for Stripe connects with whatever secret key you give it, so a DSN made with your Stripe test mode secret key works against Stripe's test data instead of live payments.
Does the Stripe ODBC driver run on a Mac?
No. Devart ODBC Driver for Stripe is available for 32-bit and 64-bit Windows only.
What happens to the driver when I roll my Stripe secret key?
Devart ODBC Driver for Stripe stops authenticating until you open the DSN in the ODBC Data Source Administrator and enter the new key; Devart's troubleshooting guide covers this case.
Does Devart refund the Stripe driver?
Only for technical failure: Devart ODBC Driver for Stripe is refundable within 30 days of purchase if a problem support can't fix stops it working. Changing your mind isn't covered.
System Requirements
- Windows Vista or later, 32-bit or 64-bit, including Windows Server and Terminal Server
- .NET Framework 4.5 or later
- Only one version of the driver installed
- A Stripe account ID and secret API key, and HTTPS internet access (proxy supported)
Conclusion
Devart ODBC Driver for Stripe is worth $109.95 a year to a Windows-based finance or analytics team that rebuilds Stripe reports by hand every month: invoices, charges and customers become refreshable tables that join with the rest of the business. The reasons to pass are the secret key it needs, which calls for careful handling, and Stripe's own exports and Sigma, which may already be enough. Use the 30-day trial with a test mode key first.
Download Free Trial Buy Now