Devart ODBC Driver for HubSpot: Query and Update HubSpot CRM With SQL From Excel, Access and Power BI
Devart ODBC Driver for HubSpot is a $139.95-per-year Windows ODBC driver that turns HubSpot CRM objects into SQL tables. Excel, Access, Power BI, Tableau, SQL Server Linked Server, DBeaver, Python and other ODBC tools can then query deals, orders, engagements, custom objects and more, and change them with INSERT, UPDATE and DELETE.
HubSpot's own reports are good inside HubSpot. The trouble starts when sales data has to sit next to finance or support data, or when someone needs to fix a few hundred records at once. This driver gives every ODBC tool on a Windows PC a live, writable connection to the CRM.
Quick facts
- Version: 2.5.0, released October 16, 2026 (first released July 2021)
- Developer: Devart
- Platform: Windows Vista or later, 32-bit and 64-bit, including Terminal Server, with .NET Framework 4.5 or later. There is no macOS or Linux edition
- Connects to: the HubSpot API over HTTPS, optionally through a proxy
- Authentication: OAuth (the default, with a Sign in to HubSpot button) or a Private App access token
- SQL: SELECT with JOINs, subqueries, GROUP BY and aggregates; INSERT, UPDATE and DELETE
- Price: $139.95 per year for a Desktop license, 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 for a perpetual Desktop license and $899.95 per year for Server Standard. The download page listed version 2.5.0 with a 33.18 MB EXE and a 37.09 MB MSI installer. All checked on November 13, 2026. We didn't install the driver or connect it to a HubSpot account
Before you buy
The driver sees what the HubSpot user or Private App you connect with is allowed to see, so check the scopes on a Private App before blaming the driver for a missing table. INSERT, UPDATE and DELETE change your live CRM, and HubSpot workflows may fire on those changes, so test writes on a sandbox or a handful of records first. Custom objects have to be switched on with the UseCustomObjects option. A subscription license needs internet access to activate and to check the license.
Download Free Trial Buy Now
Overview
Devart ODBC Driver for HubSpot sits between the HubSpot API and any ODBC program on a Windows computer. It turns your SQL into API calls and returns the answers as rows and columns, so to Excel or Access the CRM looks like a database. You set it up once as a DSN (data source name), sign in to HubSpot or paste a Private App token, and every ODBC tool on the machine can use it.
The driver shares the framework of Devart's 90-plus ODBC drivers: the same configuration dialog, full ODBC API and data type support, Unicode data, and a tested-tool list that includes Power BI, Tableau, QlikView, TIBCO Spotfire, Excel, Access, LibreOffice, SQL Server linked servers, Oracle database links, DBeaver, Visual Studio, FileMaker, PHP and Python.
The driver's Windows configuration dialog with OAuth selected: the Sign in to HubSpot button fills in the refresh token, with proxy settings below and Advanced Settings and License tabs.
Features
SQL over CRM objects
Devart ODBC Driver for HubSpot accepts SQL-92 SELECT statements with JOINs, WHERE conditions, subqueries, GROUP BY, aggregate functions and ORDER BY, so a question like "deal value by owner and stage this quarter" is one query rather than a custom report. Version 2.3.0 extended the list of supported tables and fixed reading the Deal table.
Write changes back
Devart ODBC Driver for HubSpot supports INSERT, UPDATE and DELETE, so you can bulk-correct properties, reassign records or load data from a spreadsheet or Access table. Version 2.2.1 fixed reading and writing the Orders table, a sign the write path is in active use.
Custom objects and associations
Devart ODBC Driver for HubSpot can expose HubSpot custom objects through the UseCustomObjects option (added in 1.2.0) and supports Association objects (added in 2.2.0), which link records such as deals and companies, so joins across related records work in SQL.
OAuth or Private App
Devart ODBC Driver for HubSpot signs in with OAuth through a browser, the default, or with a Private App access token (added in 2.0.0), which suits servers and scheduled jobs. Since 2.1.0 tokens, keys and passwords are stored encrypted in the DSN.
Metadata cache
Devart ODBC Driver for HubSpot can cache table and column metadata in a temporary database and reset it hourly, daily, monthly or never (added in 2.1.0), so BI tools don't re-read HubSpot's schema on every connection.
Benefits
- CRM data next to everything else. Join HubSpot deals with invoices, support tickets or warehouse data in Access, Power BI or a SQL Server linked server.
- Bulk fixes without CSV round trips. Update hundreds of records with one SQL statement instead of export, edit and re-import.
- Live reports. Excel workbooks and dashboards refresh from HubSpot directly.
- No API code. SQL in familiar tools replaces scripts written against the HubSpot API.
Real-World Uses
- Pipeline report in Excel. A sales manager pulls deals by stage and owner into a pivot table that refreshes every morning.
- Revenue reconciliation. A finance analyst joins HubSpot orders with accounting data in Power BI to check which closed deals were invoiced.
- Data cleanup. A RevOps admin links HubSpot tables in Access and fixes inconsistent property values with UPDATE queries.
- Nightly sync to SQL Server. An IT team copies HubSpot records into an in-house SQL Server through a linked server for long-term reporting.
Who It's For, and Who Should Skip It
Devart ODBC Driver for HubSpot is for HubSpot users on Windows (sales operations, analysts, finance and IT) who report on CRM data in Excel, Access, Power BI or SQL Server, or need bulk edits, and would rather write SQL than code against the HubSpot API.
Skip it if you're on a Mac or Linux: this driver is Windows-only. Skip it too if HubSpot's built-in reports and exports cover your needs, or if your reporting all happens in one BI tool that already has a HubSpot connector. If you need many sources, Devart's ODBC Universal Bundle covers all its ODBC drivers from $499.95 per year.
Usage Guide
- Download the trial from the Download button (a free Devart account is needed) and run the EXE, or the MSI for managed deployment.
- Open the ODBC Data Source Administrator that matches your application's bitness (32-bit or 64-bit), choose User DSN or System DSN, click Add and select Devart ODBC Driver for HubSpot.
- On the License tab, enter the trial or purchased activation key; the trial needs activating too.
- Choose OAuth and click Sign in to HubSpot, or choose Private App and paste the app's access token. Add proxy details if needed.
- On Advanced Settings, turn on custom objects or the metadata cache if you need them, then click Test Connection and OK.
- In Excel, Access, Power BI or your tool, choose ODBC and pick the DSN.
Tip
For a shared server or a scheduled job, create a Private App in HubSpot with read-only scopes for reporting, and a separate one with write scopes only where a process really needs to change data. The DSN then can't do more than its job requires.
Where It Falls Short
- Windows only. There's no macOS or Linux build of the HubSpot driver.
- API speed, not database speed. Every query becomes HubSpot API calls, so large pulls and complex JOINs are slow next to a real database, and HubSpot's API limits still apply.
- Table coverage grows release by release. Supported tables were extended as recently as 2.3.0, so confirm during the trial that the objects you need are there.
- Per-user licensing. A Desktop license covers one user at a time; a shared server or gateway needs Server Standard at $899.95 a year.
What Users Say
We found no reviews of the HubSpot driver on its own in November 2026: review sites file Devart's ODBC drivers as one product. The ratings and comments below cover the whole line, which shares this driver's setup dialog, licensing and support team.
Ratings
Capterra shows 4.7 out of 5 from 26 reviews of Devart ODBC Drivers. G2 lists Devart ODBC Driver at 4.5 out of 5 from 17 reviews on its product page and 4.6 from 18 on a comparison page. TrustRadius gives an aggregate 5.2 out of 10 from 58 ratings, noticeably cooler than the other two.
What reviewers like
Setup is the most common compliment: reviewers describe installation and DSN configuration as simple, and one Capterra reviewer said the drivers just work. Reliability comes next, with a TrustRadius reviewer crediting "almost no connection failures" for making it "very reliable". Price gets praise from people comparing it with enterprise connectors: a Capterra reviewer wrote that "for less than $200 per year, you can't beat it", and another liked that a perpetual license was available.
What reviewers complain about
The criticism is about polish and paperwork rather than broken connections. A TrustRadius reviewer wrote that the "user interface could be better" and that "error messages could be improved to be more relevant and specific". A G2 reviewer found the documentation confusing at times, and one buyer said licensing "took a while to be ready and delivered". On Devart's Salesforce driver, another cloud-API driver, a reviewer said it "isn't very fast" but could be tuned until speed was no problem.
The pattern: people trust Devart's drivers to connect and stay connected, and find them cheap next to enterprise alternatives, while the rough edges are terse error messages, documentation gaps and per-user licensing. For a cloud-API driver like this one, use the 30-day trial to check speed and the objects you need with your own HubSpot account.
Comparisons
ODBC driver vs. HubSpot exports and reports
HubSpot's reports and exports cost nothing extra and are enough for occasional analysis. Devart ODBC Driver for HubSpot costs $139.95 a year but gives live data in any ODBC tool, SQL joins across objects and with other systems, and bulk changes written straight back.
OAuth vs. Private App
OAuth signs in as a HubSpot user through the browser and suits a person on their own PC. A Private App token is tied to an app with fixed scopes, which suits servers, gateways and scheduled jobs that shouldn't depend on one person's login.
Desktop vs. Server editions
Desktop covers one user at a time on one Windows computer. A reporting server, Power BI gateway or web server that several people use needs Server Standard (one server with up to 6 cores) or Server Enterprise. Site licenses cover a whole company, and OEM lets you ship the driver inside your own application.
Editions and Pricing
| Edition | Subscription (1 year) | Perpetual | Who can use it |
|---|
| Desktop for Windows | $139.95 | $279.95 | One user at a time on one computer |
| Server Standard for Windows | $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 |
Every edition and term is sold under one product: the Buy Now button opens the order page set to Desktop for Windows with a 1-year subscription, and you pick the edition, subscription length or perpetual license there. Each license includes a year of support and upgrades, priority support costs extra, and Devart takes 5, 10 or 15 percent off for 5, 10 or 20 or more copies.
FAQs
Does Devart ODBC Driver for HubSpot support Private App tokens?
Yes, since version 2.0.0. Devart ODBC Driver for HubSpot accepts a Private App access token as an alternative to OAuth sign-in.
Can the HubSpot ODBC driver read custom objects?
Yes. Devart ODBC Driver for HubSpot has a UseCustomObjects connection option, added in 1.2.0, that exposes HubSpot custom objects as tables.
Can I update HubSpot records from Excel or Access?
Yes. Devart ODBC Driver for HubSpot supports INSERT, UPDATE and DELETE, so linked tables in Access or tools that write back through ODBC can change CRM data. Changes are live, so test on a few records first.
Does the HubSpot ODBC driver work on a Mac?
No. Devart ODBC Driver for HubSpot runs only on 32-bit and 64-bit Windows with .NET Framework 4.5 or later.
Can I use it in a SQL Server linked server?
Yes. Devart ODBC Driver for HubSpot lists Linked Server in SQL Server among its tested uses, and several releases fixed linked-server reading and license checks.
What happens when the subscription ends?
Devart ODBC Driver for HubSpot on a subscription license works only during the paid term and needs internet access to check the license. A perpetual license keeps the version you bought working indefinitely and can be activated offline.
System Requirements
- Windows Vista or later, 32-bit or 64-bit, including Windows Server and Terminal Server
- .NET Framework 4.5 or later
- 33.18 MB EXE or 37.09 MB MSI installer; only one version of the driver installed at a time
- A HubSpot account, signed in with OAuth or a Private App access token
- Internet access to HubSpot over HTTPS (or through a proxy), and to activate a subscription license
Conclusion
Devart ODBC Driver for HubSpot is worth $139.95 a year if you report on HubSpot data in Windows tools, need to combine it with other systems, or fix records in bulk, and you prefer SQL to API code. It's maintained twice a year and has picked up Private App tokens, custom objects and associations along the way.
The reason not to buy: it's Windows-only and runs at API speed. Use the 30-day trial to check that the objects you need appear and that your largest report finishes in acceptable time.
Download Free Trial Buy Now