Devart ODBC Driver for Zendesk: Ticket Data in Your Own Reports and Spreadsheets
Devart ODBC Driver for Zendesk costs $109.95 a year and connects Windows reporting tools straight to Zendesk Support. Tickets, users, groups and, if you switch them on, your custom fields and custom objects become SQL tables that Excel, Power BI, Tableau, Access or a SQL Server linked server can query, and that SQL can update.
Zendesk Explore covers a lot of support reporting, but it stops at Zendesk's walls. When the question is "which of our biggest customers opened urgent tickets this month", the answer needs ticket data next to CRM or billing data, and that is the job this driver does.
Quick facts
- Current version: 1.5.0 from October 16, 2026 (on sale since August 2022)
- Made by: Devart
- Windows: Vista and later, 32-bit and 64-bit, Terminal Server included, .NET Framework 4.5 or newer
- Authentication: Zendesk domain plus agent e-mail and API token (default), or e-mail and password
- Zendesk-specific options: custom fields and custom objects as columns and tables, metadata cache
- Cost: $109.95 per year, or $219.95 for a perpetual Desktop license
- Trial: 30 days, key issued through a Devart account
- Money back: within 30 days if a technical fault stops the driver and support cannot fix it
- What we checked: on November 14, 2026 the order page priced Desktop for Windows with one year of subscription at $109.95, and the download page listed version 1.5.0 as a 32.05 MB installer. We didn't connect it to a Zendesk account
Before you buy
Generate an API token in Zendesk's Admin Center for the agent the driver will act as, and use the token option rather than a password. The driver sees what that agent sees, so pick an agent whose access covers the brands and groups you report on. Ticket updates made with SQL fire your Zendesk triggers and automations just like edits in the agent workspace.
Download Free Trial Buy Now
Overview
Devart ODBC Driver for Zendesk translates SQL into calls to the Zendesk API. You give it your Zendesk domain (yourcompany.zendesk.com), choose the authentication method, and save it as an ODBC DSN; from that point Excel's Get Data, Power BI's ODBC connector or Python's pyodbc can all treat Zendesk like a database.
Two connection options matter more here than in most of Devart's SaaS drivers. Zendesk accounts often carry dozens of custom ticket fields and, on some plans, custom objects; the CustomFields and CustomObjects options added in version 1.1.0 bring them into the tables. And because those schemas are large, version 1.2.0 added a metadata cache so tools don't re-read the field list on every connect.
The Zendesk DSN dialog: API Key authentication selected, the Zendesk domain, the agent e-mail and the API token, with proxy settings underneath.
Features
Tickets you can query like a table
Devart ODBC Driver for Zendesk handles SQL-92 SELECT with JOINs, GROUP BY and aggregates. Devart's own sample counts open, high-priority, non-spam tickets grouped by type in one statement.
Your custom fields included
Devart ODBC Driver for Zendesk can return custom ticket fields and custom objects when you enable the CustomFields and CustomObjects options, so the product, region or plan fields your agents fill in are available for filtering.
Two ways to sign in
Devart ODBC Driver for Zendesk authenticates with an agent e-mail and either an API token (the default) or a password, and since version 1.2.0 stores the token or password encrypted inside the DSN.
Write-back for bulk changes
Devart ODBC Driver for Zendesk supports INSERT, UPDATE and DELETE, which suits jobs such as re-tagging or reassigning a large set of tickets after a reorganisation.
Benefits
- Support data beside customer data. Join tickets to accounts in SQL Server or Access and rank customers by support load.
- Live dashboards. Power BI and Tableau read Zendesk on refresh, with no scheduled export jobs to maintain.
- Your schema, not a generic one. Custom fields come through, so reports use the categories your team actually works with.
- Bulk fixes in minutes. One UPDATE replaces a long session of manual edits or a custom API script.
Real-World Uses
- SLA review. A support manager pulls tickets by priority, group and status into Excel each week to see where backlogs build up.
- Account health score. A customer success team blends ticket counts with renewal dates and contract value in Power BI.
- Product feedback tally. A product manager groups tickets by a custom "feature area" field to see which part of the product generates most contacts.
- Warehouse feed. An IT team copies Zendesk tables nightly into SQL Server through a linked server for long-term history.
Who It's For, and Who Should Skip It
The Zendesk driver is meant for support operations staff, analysts and IT teams on Windows who want Zendesk data in Excel, Power BI, Tableau or a SQL Server warehouse, especially when they need custom fields or must combine tickets with other systems.
If Zendesk Explore's dashboards already answer your questions, you don't need it. Mac users can't use it at all. And teams that only ever want a spreadsheet may prefer Devart's Excel Add-in for Zendesk, which edits Zendesk data inside Excel without an ODBC DSN.
Usage Guide
- In Zendesk Admin Center, open the API settings, enable token access and create a token for the agent account the driver will use.
- Get the trial installer from the Download button (log in with a free Devart account) and install it.
- In the 32-bit or 64-bit ODBC Data Source Administrator, matching your application, add a DSN using Devart ODBC Driver for Zendesk.
- Enter the trial or license key on the License tab.
- Leave Authentication on Api Key, type your Zendesk domain, the agent e-mail and the token, and click Test Connection.
- If you need custom fields or objects, turn on the CustomFields or CustomObjects options before you build reports.
- Connect Excel, Power BI or your SQL tool to the DSN.
Tip
Big Zendesk accounts have years of tickets. Filter on created or updated dates in your SQL instead of loading whole tables into Excel: the driver fetches less from the API and your report opens far faster.
Where It Falls Short
- Windows-only. Devart offers no macOS or Linux build.
- Limited by the Zendesk API. Queries over large ticket histories run at API speed, and Zendesk's per-minute API rate limits apply to the driver like any other integration.
- Ticket edits trigger workflows. Bulk updates fire triggers, notifications and SLA changes, so a careless UPDATE can e-mail customers.
- Little published schema detail. Devart documents the connection options but not each Zendesk table and column.
What Users Say
There are no published reviews of this particular driver. Review sites group Devart's ODBC drivers together, so what follows describes the family as a whole.
GetApp
GetApp shows 4.7 out of 5 from 25 reviews of Devart ODBC Drivers. Reviewers there point to value for money, documentation they found comprehensive, and a standalone installer that needs no extra client software. One said the price, under $200 a year, was hard to beat.
Capterra and TrustRadius
Capterra's 26 reviews average 4.7 out of 5. One reviewer there praised how responsive the company was while noting a time-zone gap when waiting for answers. TrustRadius is cooler, with a 5.2 out of 10 score, and its handful of reviews range from 10 out of 10 for MySQL connectivity to 7 out of 10 from a reviewer with high-traffic workloads.
Users like the price and the plain installation, and the weaker scores point at heavy workloads and support across time zones. For a cloud API driver like this, test your largest ticket query during the trial.
Comparisons
ODBC driver vs. Zendesk Explore
Zendesk Explore is included with Zendesk plans and is the easier choice for dashboards about Zendesk alone. Devart ODBC Driver for Zendesk ($109.95 a year) is for when ticket data has to meet other data, or feed tools Explore doesn't reach.
ODBC driver vs. Excel Add-in for Zendesk
Devart also sells an Excel Add-in for Zendesk that loads, edits and saves Zendesk data inside Excel only. The ODBC driver serves every ODBC tool on the machine, from Power BI to SQL Server.
Editions and Pricing
| Edition | 1-year subscription | Perpetual | Who can use it |
|---|
| Desktop for Windows | $109.95 | $219.95 | One user at a time on one computer |
| Server Standard for Windows | $799.95 | $1,599.95 | Several users on one server with up to 6 cores, one legal entity |
| Server Enterprise, Site, OEM | Quote | Quote | Any core count, a whole company, or shipping the driver in your own app |
There's one Buy Now link for every edition. It opens the order page with Desktop for Windows and a 1-year subscription preselected; change it there to Server Standard, a 2-year or 3-year subscription, or a perpetual license. Priority support is an optional extra, and 5 or more copies get a volume discount of 5 to 15 percent.
FAQs
Does Devart ODBC Driver for Zendesk support OAuth?
No. Devart ODBC Driver for Zendesk signs in with an agent e-mail plus an API token or a password; OAuth is not one of its authentication options.
Can the Zendesk ODBC driver see custom ticket fields?
Yes. Devart ODBC Driver for Zendesk has a CustomFields option, added in version 1.1.0, and a CustomObjects option for Zendesk custom objects.
Will the Zendesk driver hit API rate limits?
It can. Devart ODBC Driver for Zendesk uses the Zendesk API, so very large or frequent queries count against your account's API limits like any integration. Filtered queries keep the call count down.
Does it work with Zendesk Sell or Chat?
Devart ODBC Driver for Zendesk is documented for Zendesk Support data such as tickets, users and groups. Other Zendesk products aren't listed.
Can I install the Zendesk driver on a reporting server?
Yes, with the right license. Devart ODBC Driver for Zendesk Desktop covers one user at a time; a server several people use needs Server Standard ($799.95 a year) or Server Enterprise.
System Requirements
- Windows Vista or later (32-bit or 64-bit), Windows Server and Terminal Server
- .NET Framework 4.5 or later
- 32.05 MB installer, one driver version per machine
- A Zendesk Support account, its domain, and an agent e-mail with API token or password
- Internet access to Zendesk over HTTPS or through a proxy
Conclusion
Devart ODBC Driver for Zendesk is good value at $109.95 a year for support teams that report outside Zendesk, need their custom fields in those reports, or want to change many tickets with SQL. The custom-object support and metadata cache show it has been fitted to Zendesk rather than just pointed at it.
Don't buy it if Explore is enough or you're on a Mac. Otherwise, run the 30-day trial with a token for a reporting agent and time your biggest ticket query first.
Download Free Trial Buy Now