Devart ODBC Driver for Pipedrive: Your Sales Pipeline as SQL Tables in Excel, Power BI and Access
Devart ODBC Driver for Pipedrive is a $139.95-per-year Windows ODBC driver that turns your Pipedrive CRM into SQL tables. Excel, Power BI, Tableau, Access, SQL Server and scripts in Python or PHP can then select deals, people and organizations with ordinary SQL, and write changes back with INSERT, UPDATE and DELETE. You connect by clicking Sign in to Pipedrive (OAuth) or by pasting an API token.
Pipedrive's own Insights reports are fine for a sales team looking at its own funnel. The trouble starts when finance wants won deals next to invoices, or a manager wants a forecast in a workbook that already holds targets and quotas. This driver is for that moment: the pipeline goes wherever SQL can reach.
Quick facts
- Version: 1.6.0, released October 16, 2026 (first released August 10, 2022)
- Developer: Devart
- Platform: Windows Vista or later, 32-bit and 64-bit, including Terminal Server, with .NET Framework 4.5 or later. No macOS or Linux build
- Sign-in: OAuth through a Sign in to Pipedrive button (the driver keeps a refresh token), or a Pipedrive API token
- SQL: SQL-92 SELECT with JOINs, subqueries, GROUP BY and aggregates; INSERT, UPDATE and DELETE, also in batches
- Price: $139.95 per year for one user (Desktop), $279.95 perpetual
- Trial: 30 days, activated with a trial key from a free Devart account
- Refund: full refund within 30 days, but only when a technical problem Devart's support can't solve keeps the driver from working
- What we checked: the order page charged $139.95 for Desktop for Windows with a 1-year subscription, renewing every 12 months. The download page listed version 1.6.0 with a 32.59 MB EXE and a 36.82 MB MSI. All checked on November 14, 2026. We didn't install the driver or connect it to a Pipedrive company account
Before you buy
The driver sees exactly what the signed-in Pipedrive user sees, so a sales rep's login gives a rep's view of the pipeline, not the whole company's. Sign in as a user with the visibility your reports need. Turn on the Custom Fields option if your deals carry custom fields (deal source, contract length, region); without it those columns stay out of your queries. And a subscription license needs an internet connection to activate and to check the license.
Download Free Trial Buy Now
Overview
Pipedrive keeps its data behind a REST API. That's convenient for developers and awkward for everyone else: a spreadsheet can't call an API, and an export goes stale the moment someone moves a deal to the next stage. Devart's driver sits in the middle. You create a data source (DSN) once on your Windows machine, and any program that speaks ODBC sees Pipedrive objects (Devart's Pipedrive connectors name organizations, deals and persons among them) as tables it can query.
Devart describes its Pipedrive connectors as sending simple statements straight to Pipedrive as API calls, while for more complex ones, such as a JOIN between deals and organizations with a GROUP BY on top, they pull the data needed and finish the work locally. The same driver framework runs Devart's other 90-odd ODBC drivers, so the configuration dialog, licensing and long list of tested tools are shared with them.
The driver's Windows DSN dialog: OAuth chosen as the authentication method, a stored refresh token, the Sign in to Pipedrive button and optional proxy settings.
Features
Two ways to sign in
Devart ODBC Driver for Pipedrive offers OAuth, where you click Sign in to Pipedrive, approve access in the browser and the driver stores a refresh token, or a plain API token copied from your Pipedrive settings. OAuth avoids putting a long-lived token into shared files; the API token is handy for a connection string on a server job. Since version 1.3.0 tokens and passwords are stored encrypted in the DSN.
Custom fields in your queries
Devart ODBC Driver for Pipedrive has a Custom Fields connection option, added in version 1.1.0, that brings user-defined Pipedrive fields into queries, reports and merges. Most Pipedrive accounts lean on custom fields for the things that matter in reporting, so this switch is what makes the tables match your real pipeline.
Write back, one row or a batch
Devart ODBC Driver for Pipedrive supports INSERT, UPDATE and DELETE, and it can combine statements into batches for bulk updates. Reassigning a departed rep's open deals, or correcting a misspelled organization name across hundreds of records, becomes a single statement instead of an afternoon of clicking.
Fewer calls when you don't need them
Devart ODBC Driver for Pipedrive has a Suppress Extended Requests option that skips extra metadata requests for speed, and a ReturnForeignKeys switch that stays off by default because many tools ask for key metadata they never use. Local caching and connection pooling help repeat queries.
Benefits
- Pipeline next to money. Join won deals with invoices from your accounting database in Access or a SQL Server linked server.
- Refreshable instead of exported. A Power BI or Excel report pulls current stages and values every time it refreshes.
- Cleanup at scale. SQL updates fix data quality problems that the Pipedrive web app makes you correct one record at a time.
- No code. Analysts who know SQL don't have to learn the Pipedrive API or maintain a script.
Real-World Uses
- Monthly forecast workbook. A sales manager pulls open deals with their stage, value and expected close date into Excel and weights them against quota sheets already in the file.
- Commission check. Finance joins won deals by owner with paid invoices in Access to confirm what each rep earned.
- Territory change. An admin moves every deal of one region to a new owner with an UPDATE batch run from DBeaver.
- Long-term archive. IT copies Pipedrive records into an in-house SQL Server through a linked server, so years of pipeline history sit next to other company data.
Who It's For, and Who Should Skip It
Devart ODBC Driver for Pipedrive suits Pipedrive companies on Windows where someone (a sales operations analyst, a finance controller, an IT admin) already works in Excel, Access, Power BI or SQL Server and wants the CRM in the same place.
Skip it on a Mac or Linux machine: there's no build for either. Skip it too if Pipedrive's Insights dashboards already answer your questions, or if you need a scheduled copy of the CRM in a warehouse rather than live queries from desktop tools; a sync service fits that job better. Pipedrive teams that also pull data from many other services should price Devart's ODBC Universal Bundle instead of buying drivers one at a time.
Usage Guide
- Download the trial with the Download button (sign in with or create a free Devart account) and run the EXE, or the MSI if you deploy software centrally.
- Open ODBC Data Sources with the same bitness as your application (32-bit or 64-bit), pick User DSN or System DSN, click Add and choose Devart ODBC Driver for Pipedrive.
- Enter the trial or license key on the License tab; the trial needs activating as well.
- On the General tab choose OAuth and click Sign in to Pipedrive, or choose the API token method and paste your token.
- On Advanced Settings, enable Custom Fields if you use them, then click Test Connection and OK.
- In Excel choose Data > Get Data > From Other Sources > From ODBC and pick your DSN; Power BI, Access and DBeaver work the same way.
Tip
Test updates against a filter that hits two or three deals before you run them across the pipeline. Pipedrive automations and notifications react to changed deals just as they would to edits in the browser.
Where It Falls Short
- Windows only. The ordering page sells Windows editions alone.
- An API, not a database. Large JOINs and aggregates are computed after the data comes down through Pipedrive's API, so they take far longer than the same query on SQL Server.
- Thin product documentation. Devart's Pipedrive docs cover setup and connection options but don't publish a table-by-table reference, so you find the schema by browsing it in your tool.
- One user per Desktop license. Sharing the driver from a server needs Server Standard at $899.95 a year.
What Users Say
Review sites don't keep a separate profile for the Pipedrive driver; they review Devart's ODBC drivers as one product line. The comments below come from those line-wide profiles and are about the drivers in general, not Pipedrive specifically.
Capterra (4.7 out of 5, 26 reviews)
Capterra's reviewers are mostly positive; its sentiment summary counts 92% of reviews as positive. On setup, one wrote: "The Devart ODBC drivers were very easy to install." Another put the case for the price bluntly: "Value for money. For less than $200 per year, you can't beat it."
The criticism is worth reading too. One reviewer warned that "Some of the SQL code you need to write can be a bit confusing to grasp at first," and another never got the product running: "Good price and documentation, but I can't get them to work, so basically a waste of money for me."
G2 and TrustRadius
G2 rates Devart ODBC Driver 4.6 out of 5 from 18 reviews, where one reviewer notes there's a learning curve but that complex queries can do almost anything once you have it. TrustRadius is cooler, at 5.2 out of 10 from 58 ratings: its reviewers credit performance and fewer connection failures than their previous tools, and mark down the user interface and error messages.
The pattern across all three sites: the drivers install easily and are cheap next to enterprise connectors, while the SQL learning curve and the occasional machine where nothing works are the risks. That makes the 30-day trial worth using properly: connect it to your own Pipedrive account and build the report you actually need before paying.
Comparisons
ODBC driver vs Pipedrive's own exports and Insights
Pipedrive's built-in reports and CSV exports cost nothing and need no setup, and for a team reporting only on its own pipeline they're enough. The driver earns its $139.95 when the pipeline has to meet other data (accounting, quotas, support tickets) in a tool you already use, or when a report must refresh by itself, or when you need bulk changes that the web app makes tedious.
ODBC driver vs Devart's SSIS components for Pipedrive
Devart also sells SSIS Data Flow components for Pipedrive. Those are for scheduled ETL packages in SQL Server Integration Services; the ODBC driver is for live queries from desktop and BI tools. Pick the SSIS components if your goal is a nightly load into a warehouse.
Editions and Pricing
All editions are bought through the same Buy Now button: the order page lets you choose the edition and switch between a yearly subscription and a perpetual license. Prices as listed on November 14, 2026.
| Edition | 1-year subscription | Perpetual | Who may use it |
|---|
| Desktop for Windows (the order page's default) | $139.95 | $279.95 | One computer, one user at a time |
| Server Standard for Windows | $899.95 | $1,799.95 | One server up to 6 cores, many concurrent users |
| Server Enterprise, Site, OEM | On request | On request | Servers of any size, many devices, or redistribution |
A perpetual license keeps working with the version you bought and activates offline; the subscription gives updates and support while it runs. 2-year and 3-year terms and a premium support option are also offered on the order page.
FAQs
Should I use OAuth or an API token with the Pipedrive ODBC driver?
Devart ODBC Driver for Pipedrive works with both. OAuth is the friendlier choice on a desktop: you sign in through the browser and the driver keeps a refresh token. An API token suits a connection string on a server or in a script, where nobody is there to click a sign-in button.
Can Power BI refresh Pipedrive data through this driver on a schedule?
Devart ODBC Driver for Pipedrive works with Power BI Desktop through an ODBC DSN. For scheduled refresh in the Power BI service, the driver has to be installed on the machine running the on-premises data gateway, and a shared gateway server is a case for the Server edition rather than Desktop.
Does the Pipedrive driver work on a Mac?
No. Devart ODBC Driver for Pipedrive is built for Windows only. Mac users would need to run it inside a Windows virtual machine.
What happens when my subscription ends?
Devart ODBC Driver for Pipedrive's subscription license grants use only for the subscription term, and the driver checks the license online, so it stops working if you don't renew. If you want to keep using one version indefinitely, buy the perpetual license instead.
Can I get my money back if the driver isn't right for me?
Only in a narrow case. Devart refunds within 30 days of purchase when a technical problem or bug stops the product from working and its support team can't fix it. Changing your mind isn't covered, so decide during the 30-day trial.
Which tools has Devart tested the Pipedrive driver with?
Devart ODBC Driver for Pipedrive's releases since 2023 list compatibility fixes for SQL Server linked servers, Alteryx, Tableau, Visual Basic, Microsoft Query, Excel, Qlik Replicate, PHP's PDO_ODBC, Node.js, Visual FoxPro and DBeaver. Devart also publishes step-by-step guides for Excel, Access, Power BI, Tableau, Python and others.
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 at a time
- A Pipedrive account, with internet access over HTTPS (a proxy is supported)
- Internet access for activating and checking a subscription license
Conclusion
Devart ODBC Driver for Pipedrive is worth $139.95 a year for a Windows-based sales ops or finance person who keeps rebuilding Pipedrive exports by hand: OAuth sign-in, custom fields and write-back make the CRM behave like one more database in Excel, Power BI or SQL Server. The main reason not to buy is speed and scale; it reads through Pipedrive's API, so it's a reporting and cleanup tool, not a warehouse. Try it for 30 days against your real pipeline, because the refund policy won't cover a change of heart.
Download Free Trial Buy Now