Devart ODBC Driver for ServiceNow: ServiceNow Tables in Excel, Power BI and SQL Tools
Devart ODBC Driver for ServiceNow is a Windows ODBC driver, $139.95 a year for one desktop or $279.95 perpetual, that lets Excel, Power BI, Tableau, Access, SQL Server linked servers, Python and any other ODBC tool query and update ServiceNow data with SQL. It connects to your ServiceNow instance over HTTPS with a user name and password or OAuth 2.0, and needs no other client software.
ServiceNow's own reporting lives inside the platform, and pulling incidents, changes or CMDB records into a company's BI tools usually means export jobs or REST API code. An ODBC driver turns those tables into a live data source that any report can refresh, and that's the job this driver does.
Quick facts
- Version: 1.3.0, released October 16, 2026; first released April 10, 2024
- Developer: Devart
- Platforms: Windows 32-bit and 64-bit, including Windows Terminal Server; .NET Framework 4.5
- Sign-in: Basic (user ID and password) or OAuth 2.0 (client ID, client secret and refresh token), with your instance's subdomain
- Download: 32.95 MB EXE or 37.10 MB MSI installer
- Price: $139.95 a year or $279.95 perpetual for Desktop; $899.95 a year or $1,799.95 perpetual for Server Standard
- Trial: 30 days, full-featured
- Refund: Devart's ordering FAQ gives a refund within 30 days only when a technical problem support can't fix stops the product working
- What we checked: the order page charged $139.95 for Desktop for Windows with one year of updates on a yearly subscription, $279.95 perpetual, $899.95 a year for Server Standard and $1,799.95 perpetual, and the download page listed version 1.3.0 (EXE 32.95 MB, MSI 37.10 MB), on November 18, 2026. We didn't connect it to a ServiceNow instance
Download Free Trial Buy Now
Overview
You install the driver, create a DSN in the Windows ODBC Data Source Administrator (or use a connection string), and enter your instance's subdomain, the part before .service-now.com, with either a user ID and password or OAuth credentials. A proxy server can be set if the PC has no direct internet access.
From then on, ServiceNow tables appear like database tables in any ODBC application. SQL-92 SELECT statements with joins, subqueries, grouping and aggregates work, and INSERT, UPDATE and DELETE change records in ServiceNow.
Features
SQL over ServiceNow tables
Devart ODBC Driver for ServiceNow lets you query ServiceNow objects with SQL-92 SELECT statements, including complex joins, WHERE conditions, subqueries, GROUP BY, aggregate functions and ORDER BY, and supports INSERT, UPDATE and DELETE to change data.
Basic or OAuth sign-in
Devart ODBC Driver for ServiceNow connects with a ServiceNow user ID and password, or with OAuth 2.0 using a client ID, client secret and refresh token, to the instance named by its subdomain. Proxy server settings cover locked-down networks.
Works with common tools
Devart ODBC Driver for ServiceNow is checked by Devart with Excel, Power BI, Tableau, Qlik, Access, SQL Server linked servers, Oracle database links, DBeaver, Visual Studio, Python and PHP. Version 1.3 (October 2026) improved compatibility with Node.js, Visual FoxPro and DBeaver, and 1.2 with Qlik Replicate and PHP's PDO_ODBC.
Tuning options for awkward tools
Devart ODBC Driver for ServiceNow has settings for third-party tools with quirks: forcing ODBC 2.x or 3.x behaviour, ANSI or Unicode string types, regional number and date formats, UTC dates, query timeouts and turning off foreign key metadata that some tools request but don't need.
Caching and pooling
Devart ODBC Driver for ServiceNow uses local data caching and connection pooling to speed up repeated queries, and is Unicode-compliant for multilingual data.
Benefits
- Live ServiceNow reports. Power BI or Excel refreshes straight from ServiceNow instead of from exports.
- Join with other data. Combine incidents with HR, asset or finance data in one SQL query or report.
- No coding. Analysts use the tools they already know, not the REST API.
Real-World Uses
- IT service dashboards. A Power BI report shows open incidents and SLA breaches by team, refreshed daily.
- CMDB checks in Excel. An asset manager compares ServiceNow configuration items against a purchasing spreadsheet.
- SQL Server linked server. A DBA queries ServiceNow tables from T-SQL to feed a data warehouse.
- Bulk fixes. A script runs UPDATE statements to correct a field across many records.
Who It's For, and Who Should Skip It
The driver suits analysts, BI developers and IT managers who need ServiceNow data in Windows tools such as Excel, Power BI or SQL Server, with live refresh and SQL joins.
Skip it if ServiceNow's built-in reports and Performance Analytics cover your needs, or if you work on macOS or Linux: this driver is Windows-only. Shared report servers need the more expensive Server license, not Desktop.
Usage Guide
- Download the EXE or MSI from Devart's download page (a free Devart account is needed) and install it; choose Trial evaluation or enter a license key.
- Open ODBC Data Source Administrator (32-bit or 64-bit, matching your application) and add a DSN with the Devart ODBC Driver for ServiceNow.
- Enter your instance subdomain and choose Basic (user ID and password) or OAuth (client ID, client secret, refresh token); set a proxy if needed and click Test Connection.
- In Excel, Power BI or another tool, choose ODBC as the data source and pick the DSN.
- Select ServiceNow tables or write a SQL query, then refresh the report whenever you need current data.
Before you buy
The Desktop license covers one desktop computer used by one person at a time. A server where several users or a report service share the driver needs Server Standard ($899.95 a year) or Server Enterprise. Queries run through ServiceNow's API, so very large tables take time to read, and your instance's API limits and user permissions apply.
Where it falls short
- Windows only. There's no macOS or Linux build of this driver.
- Server pricing jumps. Shared use costs over six times the Desktop license.
- API speed. Large tables are read over HTTPS, slower than a database.
- Young product. First released in April 2024, with no reviews of its own yet.
What Users Say
Reviews of the Devart ODBC family
The ServiceNow driver hasn't collected reviews of its own. Capterra lists Devart's ODBC drivers together, at 4.7 out of 5 across 26 reviews, mostly from users of the database and Salesforce drivers. They value the quick installation and stable connections, and the most common criticism is the price. Test your own ServiceNow tables and largest queries in the 30-day trial before relying on those general marks.
Comparisons
ODBC driver vs. ServiceNow exports
ServiceNow can export lists to Excel or CSV for free, but each export is a snapshot you redo by hand. The driver gives a live connection that refreshes, joins with other data and can write changes back, which pays off once a report is run regularly.
ServiceNow driver vs. Devart's ODBC Universal Bundle
Devart's ODBC Universal Bundle includes the ServiceNow driver along with drivers for more than 90 other databases and cloud apps. If you also need Jira, Salesforce or other sources, compare the bundle's price before buying single drivers.
Editions and Pricing
| Edition | 1-year subscription | Perpetual | Typical use |
|---|
| Desktop for Windows | $139.95 | $279.95 | One person's PC |
| Server Standard for Windows | $899.95 | $1,799.95 | A reporting or SQL Server machine shared by many users |
| Server Enterprise, Site, OEM | Quote | Quote | Larger servers, company-wide installs, or shipping the driver in your product |
Buy Now opens the order page on Desktop for Windows with a 1-year subscription; the edition, license type (subscription or perpetual) and a 1-, 2- or 3-year term are chosen there.
FAQs
Can ODBC Driver for ServiceNow connect with OAuth?
Yes. Devart ODBC Driver for ServiceNow supports OAuth 2.0 with a client ID, client secret and refresh token, as well as basic sign-in with a user ID and password.
Can ODBC Driver for ServiceNow update ServiceNow records?
Yes. Devart ODBC Driver for ServiceNow supports INSERT, UPDATE and DELETE statements against ServiceNow tables, subject to the signed-in user's permissions.
Does it work with Power BI?
Yes. Devart ODBC Driver for ServiceNow is listed as compatible with Power BI, Excel, Tableau, Qlik and other ODBC tools; in Power BI you choose ODBC as the data source and pick the DSN.
Is there a Mac or Linux version?
No. Devart ODBC Driver for ServiceNow runs on 32-bit and 64-bit Windows, including Windows Terminal Server.
Do I need the Server license for a SQL Server linked server?
Yes, usually. Devart ODBC Driver for ServiceNow's Desktop license is for one user on one desktop computer at a time; shared use on a server needs Server Standard or Server Enterprise.
Can I get a refund?
Only for technical problems. Devart's ordering FAQ gives a full refund within 30 days of purchase when a bug or technical issue stops ODBC Driver for ServiceNow working and support can't fix it. Use the 30-day trial against your own instance first.
System Requirements
- Windows Vista or later, 32-bit or 64-bit, including Windows Terminal Server
- .NET Framework 4.5
- A ServiceNow instance and an account with API access (or OAuth credentials)
- An ODBC-compatible application
Conclusion
Devart ODBC Driver for ServiceNow is worth $139.95 a year to anyone who needs live ServiceNow data in Excel, Power BI or SQL Server reports, with SQL joins and write-back and no API coding. Shared report servers need the much pricier Server license, and macOS and Linux users are out of luck. If ServiceNow's built-in reports already answer your questions, you don't need it; if not, try it on your own instance with the 30-day trial.
Download Free Trial Buy Now