Devart ODBC Driver for NetSuite: Live NetSuite Data in Excel, Power BI and SQL Server, Without SuiteAnalytics Connect
Devart ODBC Driver for NetSuite is a $179.95-per-year Windows ODBC driver that presents NetSuite ERP and CRM records as SQL tables. Excel, Access, Power BI, Tableau, SQL Server Linked Server, DBeaver, Python and other ODBC tools can then query live NetSuite data and write changes back, without NetSuite's paid SuiteAnalytics Connect add-on.
If your finance or sales reports start with a NetSuite saved search exported to CSV and pasted into a spreadsheet, this driver replaces the export with a connection: refresh the workbook and the numbers are current. It's a specialist tool for people who report on NetSuite every week.
Quick facts
- Version: 3.5.0, released October 16, 2026
- 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: NetSuite through the SuiteTalk API over HTTPS, optionally through a proxy, including sandbox accounts
- Authentication: token-based (the default), OAuth 2.0, or user name and password
- SQL: SELECT with JOINs, subqueries, GROUP BY and aggregates; INSERT, UPDATE and DELETE, also in batches
- Price: $179.95 per year for a Desktop license, 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 and $999.95 per year for Server Standard. The download page listed version 3.5.0 with a 45.50 MB EXE and a 49.43 MB MSI installer. All checked on November 13, 2026. We didn't install the driver or connect it to a NetSuite account
Before you buy
You need NetSuite credentials the driver can use: for the default token-based login, a Consumer Key and Secret from an integration record plus a Token ID and Secret; for OAuth 2.0, a Client ID, Client Secret and refresh token; for basic login, your Account ID, user, password and an Application ID. The role you connect with decides which records you see. Writes go straight into your live NetSuite account, so try INSERT, UPDATE and DELETE on a sandbox account first. A subscription license needs internet access to activate and to check the license.
Download Free Trial Buy Now
Overview
NetSuite keeps its data behind web services. NetSuite's own ODBC route, SuiteAnalytics Connect, is a separately licensed add-on and is read-only. Devart ODBC Driver for NetSuite takes a different path: it talks to the standard SuiteTalk API over HTTPS, translates your SQL into API calls and hands the results back as rows and columns. To Excel or Access, NetSuite looks like a database you can also update.
You set it up once as a DSN (data source name) with your account ID and credentials, and every ODBC program on that computer can use it. The driver belongs to Devart's family of more than 90 ODBC drivers and shares their framework: the same configuration dialog, full ODBC API support, Unicode data, and a tested-tool list that includes Power BI, Tableau, Qlik Sense, Crystal Reports, Alteryx, SQL Server Management Studio, Excel, Access, FileMaker, Visual Studio, Delphi, PHP and Python.
The driver's Windows configuration dialog: account ID, role, user, password and application ID for basic login, a Sandbox switch, and proxy settings, with Advanced settings and License tabs.
Features
SQL queries over NetSuite records
Devart ODBC Driver for NetSuite accepts SQL-92 SELECT statements with JOINs, WHERE conditions, subqueries, GROUP BY, aggregate functions and ORDER BY, so you can ask questions a single saved search can't, such as invoice totals by customer and month joined to the sales rep. Version 3.0 added native support for LIMIT, so a "top 100" query no longer pulls the whole table first.
Write back with INSERT, UPDATE and DELETE
Devart ODBC Driver for NetSuite supports standard DML and batches of statements for high-volume changes, so you can bulk-update item prices or custom fields from an Access form or a SQL script. This is the main difference from SuiteAnalytics Connect, which only reads.
Three ways to sign in
Devart ODBC Driver for NetSuite supports token-based authentication (the default), OAuth 2.0 with a refresh token, and basic user and password login with an Application ID. A Role ID setting picks the NetSuite role, and since version 3.1.0 tokens, secrets and passwords are stored encrypted in the DSN.
Custom lists, sandbox and time zones
Devart ODBC Driver for NetSuite reads NetSuite custom lists (added in 3.0), connects to sandbox accounts with one checkbox, and lets you set the account time zone and choose whether dates come back as UTC or local time, which matters when you reconcile transactions across regions.
Caching for speed
Devart ODBC Driver for NetSuite has a metadata cache (added in 3.1.0) that you can reset hourly, daily, monthly or never, plus connection pooling and a ReturnForeignKeys switch, all aimed at cutting the number of API calls and the time tools spend reading the schema.
Fits Windows deployment
Devart ODBC Driver for NetSuite installs from one EXE with no NetSuite client software, and an MSI package (since 2.2.1) lets IT push it through Group Policy. It works from 32-bit and 64-bit applications and on Terminal Server.
Benefits
- Live reports instead of exports. A refresh in Excel or Power BI pulls current figures, so nobody rebuilds the weekly report from CSV files.
- No extra NetSuite license. The driver uses the API your account already has, rather than the SuiteAnalytics Connect add-on.
- Change data in bulk. Price lists, custom fields or records can be updated from a spreadsheet or Access table in one statement.
- Join NetSuite with everything else. Through Access, Power BI or a SQL Server linked server you can combine NetSuite with your warehouse, CRM or payroll data.
Real-World Uses
- Month-end dashboard. A finance analyst connects Power BI to the DSN and builds a refreshable view of revenue, receivables and expenses by subsidiary.
- Sales pivot tables. A sales manager pulls opportunities and invoices into an Excel pivot table that updates when opened.
- Linked server for the data team. A DBA adds NetSuite as a linked server in SQL Server so stored procedures and SSRS reports can join it with internal tables.
- Bulk price update. An operations lead links the items table in Access and runs one UPDATE query to apply a new price list.
- Python scripts. A developer reads NetSuite with pyodbc and standard SQL instead of writing SuiteTalk code.
Who It's For, and Who Should Skip It
Devart ODBC Driver for NetSuite is for NetSuite customers whose analysts, finance staff or DBAs report on NetSuite often, want it next to other data in Windows tools, or need to update records in bulk, and who prefer SQL to writing SuiteScript or SuiteTalk code.
Skip it if you work on a Mac or Linux: this driver is Windows-only, unlike many of Devart's other ODBC drivers. Skip it too if NetSuite's saved searches and built-in reports already answer your questions, or if your company already pays for SuiteAnalytics Connect and only needs to read. If you need several sources, Devart's ODBC Universal Bundle covers all its ODBC drivers from $499.95 per year.
Usage Guide
- In NetSuite, prepare credentials: enable token-based authentication and create an integration record and access token (Consumer Key and Secret, Token ID and Secret), or set up OAuth 2.0 to get a Client ID, Client Secret and refresh token.
- 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) and add a data source with Devart ODBC Driver for NetSuite.
- On the License tab, enter the trial or purchased activation key from your registration email or the Devart Customer Portal; the trial needs activating too.
- On the General tab, choose the authentication type, enter the Account ID and credentials, tick Sandbox if you're connecting to one, add proxy details if needed, and click Test Connection.
- In Excel, Power BI or your tool, choose ODBC and pick the DSN. A DSN-less basic connection string looks like
DRIVER={Devart ODBC Driver for NetSuite};User ID=myUser;Password=myPassword;Account ID=myAccountId;Application ID=myAppId.
Tip
Every query becomes SuiteTalk API calls. Filter on dates or status in the WHERE clause rather than pulling whole transaction tables, turn on the metadata cache, and switch off ReturnForeignKeys if a tool is slow to list tables.
Where It Falls Short
- Windows only. There's no macOS or Linux build of the NetSuite driver, so Mac analysts and Linux servers need another route.
- API speed, not database speed. Large pulls and complex JOINs run through web service calls, so they take far longer than the same query on a real database, and NetSuite's API limits still apply.
- Role permissions decide what you see. A table that comes back empty or a failed write is often the NetSuite role, not the driver.
- Pricier than Devart's database drivers. At $179.95 a year per user, it costs more than the $139.95 drivers for PostgreSQL or SQLite, and a shared server needs Server Standard at $999.95 a year.
What Users Say
We found no reviews of the NetSuite 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, test speed and the records you need against your own account during the 30-day trial.
Comparisons
Devart driver vs. SuiteAnalytics Connect
SuiteAnalytics Connect is NetSuite's own ODBC access, an add-on you have to enable on your account, and it is read-only. Devart ODBC Driver for NetSuite costs $179.95 a year per Desktop user, connects through the standard API you already have, and can also insert, update and delete records.
Devart driver vs. saved searches and CSV exports
Saved searches and exports cost nothing extra and are fine for occasional reports. Devart ODBC Driver for NetSuite adds live refresh, SQL across record types and write-back, at the price of a license and slower queries on very large data sets.
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 | $179.95 | $349.95 | One user at a time on one computer |
| Server Standard for Windows | $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 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
Do I need SuiteAnalytics Connect to use Devart ODBC Driver for NetSuite?
No. Devart ODBC Driver for NetSuite connects through NetSuite's standard SuiteTalk web services API over HTTPS, so the SuiteAnalytics Connect add-on doesn't need to be enabled.
Which NetSuite login should I use with the driver?
Devart ODBC Driver for NetSuite defaults to token-based authentication with a Consumer Key and Secret and a Token ID and Secret. OAuth 2.0 is also supported, and basic login needs a user, password and Application ID.
Can Devart ODBC Driver for NetSuite connect to a sandbox account?
Yes. Devart ODBC Driver for NetSuite has a Sandbox checkbox in the DSN, so you can test reports and especially write operations before pointing them at production.
Does the NetSuite ODBC driver work on a Mac?
No. Devart ODBC Driver for NetSuite runs only on 32-bit and 64-bit Windows. Mac users can run it inside a Windows virtual machine or use a Windows server with the Server edition.
Does it work with a SQL Server linked server?
Yes. Devart ODBC Driver for NetSuite lists Linked Server in SQL Server among its tested uses, and several releases since 2.1.2 fixed linked-server compatibility and license checks.
What happens when the subscription ends?
Devart ODBC Driver for NetSuite 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.
Can I share one license with my team?
Not on a Desktop license: Devart ODBC Driver for NetSuite Desktop allows one user at a time, directly or remotely. Several simultaneous users need Server Standard or Server Enterprise.
System Requirements
- Windows Vista or later, 32-bit or 64-bit, including Windows Server and Terminal Server
- .NET Framework 4.5 or later
- 45.50 MB EXE or 49.43 MB MSI installer; only one version of the driver installed at a time
- A NetSuite account with API access and credentials for token-based, OAuth 2.0 or basic login
- Internet access to NetSuite over HTTPS (or through a proxy), and to activate a subscription license
Conclusion
Devart ODBC Driver for NetSuite is worth $179.95 a year if you report on NetSuite regularly and want live data in Excel, Power BI or SQL Server without paying for SuiteAnalytics Connect, or if you need to write changes back in bulk, which Connect can't do. It's actively maintained, with two releases in 2026 and a release history going back to 2017.
The main reason not to buy: it's Windows-only and every query runs at API speed. Use the 30-day trial on a sandbox account, check that the records your role can see are there, and time your biggest report before you pay.
Download Free Trial Buy Now