Devart ODBC Driver for Dynamics 365 (formerly Dynamics CRM): SQL Access to Your CRM on Windows, Mac and Linux
Devart ODBC Driver for Dynamics 365 is a $179.95-per-year ODBC driver for Windows, macOS and Linux that exposes Dynamics 365 Customer Engagement, the product formerly called Dynamics CRM, as SQL tables. Excel, Access, Power BI, Tableau, SQL Server Linked Server, DBeaver, Python and other ODBC tools can query accounts, contacts, opportunities and your custom entities, and create, update and delete records.
Dynamics 365 has its own reporting, but CRM data rarely lives alone. This driver lets every ODBC tool on a PC, Mac or Linux server read and write the CRM with SQL.
Quick facts
- Version: 4.2.0, released October 16, 2026
- Developer: Devart
- Platforms: Windows 7 or later (32-bit and 64-bit, including Terminal Server), macOS on Intel and Apple Silicon, Linux 64-bit (DEB and RPM), on systems that support .NET 6
- Connects to: Dynamics 365 Customer Engagement (Dynamics CRM) by server URL over HTTPS, optionally through a proxy
- Authentication: OAuth 2.0 (the default, with a Sign in to Dynamics 365 button) or user ID and password
- SQL: SELECT with JOINs, subqueries, GROUP BY and aggregates; full create, read, update and delete; bulk operations
- Price: $179.95 per year for a Desktop license on one platform, or $349.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 $179.95 for Desktop for Windows with a 1-year subscription, and the same cart showed $349.95 for a perpetual Desktop license, $999.95 per year for Server Standard and $179.95 per year for Desktop for macOS. The download page listed version 4.2.0 with an 80.20 MB Windows EXE, a 95.00 MB MSI, an 84.64 MB macOS PKG and 33.46 MB RPM and 31.32 MB DEB Linux packages. All checked on November 13, 2026. We didn't install the driver or connect it to a Dynamics 365 organization
Before you buy
This driver is for Dynamics 365 Customer Engagement, the CRM side (sales, service, marketing). Dynamics 365 Business Central, the ERP, has a separate Devart driver. Licenses are per platform: a Windows license doesn't cover the Mac or Linux build, so choose the platform on the order page. For on-premises Dynamics, Devart's FAQ mentions Windows and claims-based authentication, but the documented DSN options are OAuth 2.0 and user ID and password, so confirm your login works during the trial. A subscription license needs internet access to activate and to check the license.
Download Free Trial Buy Now
Overview
Devart ODBC Driver for Dynamics 365 sits between the Dynamics 365 API and any ODBC program. It translates SQL into API calls and returns rows and columns, so Excel, Access or a BI tool see the CRM as a database. Every entity and its metadata are available, including custom entities, custom fields and calculated values, and records can be read or written in bulk.
Its release history goes back to the Dynamics CRM days, and it is no longer Windows-only: macOS and Linux support arrived in 3.0.0 (November 2022), Apple Silicon in 3.3.0, and a graphical configuration window plus OAuth 2.0 on macOS and Linux in 4.0.0 (November 2025). Version 4.2.0 added fixes for current Ubuntu and CentOS releases and a unixODBC issue. Devart lists more than 250 compatible tools, including Power BI, Tableau, QlikView, Excel, Access, SQL Server Management Studio and Data Tools, DBeaver, Visual Studio, FileMaker, PHP and Python.
The driver's Windows configuration dialog: the Dynamics 365 server URL, OAuth 2.0 authentication with a Sign in to Dynamics 365 button that fills in the refresh token, and proxy settings.
Features
SQL over CRM entities
Devart ODBC Driver for Dynamics 365 accepts SQL-92 SELECT statements with JOINs, WHERE conditions, subqueries, GROUP BY, aggregate functions and ORDER BY, so you can filter, join and total CRM records without learning the Dynamics 365 Web API or FetchXML.
Full CRUD and bulk operations
Devart ODBC Driver for Dynamics 365 supports creating, reading, updating and deleting records, and can read or write large volumes in one operation, which suits data cleanup, migrations and syncs as well as reporting.
Custom entities and fields
Devart ODBC Driver for Dynamics 365 exposes the whole CRM schema, including custom entities, custom fields and calculated values, so a heavily customized organization shows up in SQL as it really is.
Windows, macOS and Linux
Devart ODBC Driver for Dynamics 365 runs on 32-bit and 64-bit Windows, on macOS (Intel and Apple Silicon) and on 64-bit Linux from DEB or RPM packages. Since 4.0.0 the Mac and Linux builds have the same graphical configuration window and OAuth 2.0 sign-in as Windows.
Caching, pooling and throttling
Devart ODBC Driver for Dynamics 365 caches metadata (daily by default, adjustable from hourly to never), reuses connections, and according to Devart batches requests and retries automatically to cope with Dynamics 365 API limits and throttling. Tokens and passwords are stored encrypted in the DSN since 3.4.0.
Benefits
- CRM data where analysts already work. Pivot tables, Access queries and Power BI reports run on live Dynamics 365 data.
- One driver for mixed teams. Windows desktops, Mac analysts and Linux ETL servers can all use the same driver and SQL.
- Bulk changes without import wizards. Fix or load records with SQL statements instead of spreadsheets and the import tool.
- CRM joined with other systems. Linked servers and BI tools can combine Dynamics 365 with ERP, finance or support data.
Real-World Uses
- Sales pipeline dashboard. A sales operations analyst connects Power BI or Excel to opportunities and accounts and refreshes the pipeline every morning.
- Linux ETL job. A data engineer runs a nightly Python job on a Linux server that copies CRM entities into a warehouse through the DEB package.
- Data quality cleanup. A CRM admin finds duplicate or incomplete contacts with SQL in DBeaver and fixes them with UPDATE statements.
- SQL Server integration. A DBA adds Dynamics 365 as a linked server so existing SSRS reports can join CRM data with on-premises tables.
Who It's For, and Who Should Skip It
Devart ODBC Driver for Dynamics 365 is for Dynamics 365 Customer Engagement users (sales and service operations, analysts, CRM admins and data engineers) who want CRM data in Excel, Access, BI tools, SQL Server or scripts, on Windows, Mac or Linux, and who prefer SQL to the Web API.
Skip it if you run Business Central rather than Customer Engagement; Devart sells a separate driver for that. Skip it too if Power BI's built-in Dataverse connector or Dynamics 365's own reports and Excel export already cover what you need. 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 for your platform from the Download button (a free Devart account is needed): EXE or MSI for Windows, PKG for macOS, DEB or RPM for Linux, and install it.
- On Windows, open the ODBC Data Source Administrator that matches your application's bitness, choose User, System or File DSN, click Add and select Devart ODBC Driver for Dynamics 365. On macOS and Linux, use the driver's configuration window.
- Activate the driver on the License tab with the trial or purchased key; the trial needs activating too.
- Enter your Dynamics 365 server URL, keep OAuth 2.0 and click Sign in to Dynamics 365, or choose User ID and Password. Add proxy details if needed.
- Click Test Connection, then OK.
- In Excel, Power BI, DBeaver or your tool, choose ODBC and pick the DSN, or use a DSN-less connection string from your code.
Tip
For a scheduled job or a shared server, create a System DSN rather than a User DSN; the docs note that SQL Server Management Studio linked servers and the Oracle database gateway need one. Match the driver's bitness to the program that uses it.
Where It Falls Short
- Customer Engagement only. Business Central data needs Devart's separate Business Central driver.
- API speed, not database speed. Large pulls and complex JOINs run through web API calls and are slower than a real database; heavy reports can still meet Dynamics 365 throttling.
- Bigger install. The Windows installer is 80.20 MB, much larger than Devart's Windows-only cloud drivers.
- Per-platform, per-user licensing. A Desktop license covers one user at a time on one OS; a shared server or gateway needs Server Standard at $999.95 a year.
- Pricier than Devart's database drivers. At $179.95 a year it sits in Devart's top price tier for single drivers.
What Users Say
We found no reviews of the Dynamics 365 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 your custom entities against your own organization.
Comparisons
ODBC driver vs. Dataverse connector in Power BI
Power BI connects to Dynamics 365 data on its own. Devart ODBC Driver for Dynamics 365 matters when the tool isn't Power BI (Excel's ODBC import, Access, SQL Server linked servers, DBeaver, Python or a Linux job) and when you need to write data back, which a reporting connector doesn't do.
Windows vs. macOS vs. Linux licenses
Devart ODBC Driver for Dynamics 365 is priced the same on all three platforms: $179.95 a year or $349.95 perpetual for Desktop. Each license covers one platform, so a person who works on both Windows and a Mac needs two.
Desktop vs. Server editions
Desktop covers one user at a time on one 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, macOS or Linux | $179.95 | $349.95 | One user at a time on one computer |
| Server Standard for Windows, macOS or Linux | $999.95 | $1,999.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, platform 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 platform, 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
Is Devart ODBC Driver for Dynamics 365 the same as the Dynamics CRM ODBC driver?
Yes. Devart ODBC Driver for Dynamics 365 is the current name of Devart's Dynamics CRM ODBC driver; Microsoft renamed Dynamics CRM to Dynamics 365 Customer Engagement, and Devart's site still links both names to the same product.
Does the Dynamics 365 ODBC driver work with Business Central?
No. Devart ODBC Driver for Dynamics 365 covers Customer Engagement (sales, service, marketing). Devart sells a separate ODBC Driver for Dynamics 365 Business Central.
Can I use the Dynamics 365 ODBC driver on a Mac?
Yes. Devart ODBC Driver for Dynamics 365 has macOS builds for Intel and Apple Silicon, with a graphical configuration window and OAuth 2.0 sign-in since version 4.0.0. The Mac license is bought separately from the Windows one.
Do I need Microsoft's SDK or client libraries?
No. Devart ODBC Driver for Dynamics 365 is a standalone install that talks to Dynamics 365 itself; the platform only needs to support .NET 6.
Can I update Dynamics 365 records with SQL?
Yes. Devart ODBC Driver for Dynamics 365 supports INSERT, UPDATE and DELETE, including bulk operations. Changes are live, so try them in a sandbox environment first.
What happens when the subscription ends?
Devart ODBC Driver for Dynamics 365 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 7 or later, 32-bit or 64-bit, including Terminal Server (80.20 MB EXE or 95.00 MB MSI)
- macOS 64-bit, Intel or Apple Silicon (84.64 MB PKG)
- Linux 64-bit, DEB (31.32 MB) or RPM (33.46 MB) packages
- An operating system that supports .NET 6; only one version of the driver installed at a time
- A Dynamics 365 Customer Engagement organization and an account for OAuth 2.0 or password sign-in
- Internet access to Dynamics 365 over HTTPS (or through a proxy), and to activate a subscription license
Conclusion
Devart ODBC Driver for Dynamics 365 is worth $179.95 a year if you report on or maintain Dynamics 365 CRM data in tools other than Power BI, need SQL access on a Mac or a Linux server, or want to write changes back in bulk. It covers all three desktop platforms, signs in with OAuth 2.0 on each, and gets two releases a year.
The reason not to buy: if Power BI and Dynamics 365's own reports already give you what you need, it adds cost without much benefit. Otherwise, use the 30-day trial against your own organization, with your custom entities, before you pay.
Download Free Trial Buy Now