This article is relevant if you are trying to connect up to NetSuite’s ODBC system.
NetSuite ODBC Connectivity
Recently, we started to experience some permission issues with our NetSuite ODBC connections. Strange, we have been working with ODBC for some time. For example, reference our articles below:
- NetSuite Delivers on ODBC
- Connecting ODBC to Multiple NetSuite Accounts
- NetSuite 64-bit ODBC Setup Instructions
Yet, most of the accounts we work with our development in nature and this is where we tripped up. The good news is we started to work with Simon Miles at Solution 7 in the UK. He has a wicked Excel based Financial Reporting add-in (we’ll write about it shortly) and he clued us into the recent service host changes.
NetSuite Offers Different ODBC Service Host Addresses
You may be getting a permission error when connecting to NetSuite ODBC. This may have to do with the service host address. Use these addresses to connect to specific environments:
- Production Accounts: odbcserver.netsuite.com
- Development / Test Drive Accounts: odbcserver.na1.netsuite.com
- Sandbox Accounts: odbcserver.sandbox.netsuite.com
Related Articles
- NetSuite Updates ODBC to Support 64-Bit Drivers
- NetSuite Delivers on ODBC
- SQL Reporting on NetSuite Data Step-By-Step
- Connecting ODBC to Multiple NetSuite Accounts
- NetSuite 64-bit ODBC Setup Instructions
- Extract NetSuite Data for Backup and Reporting
- Warning: SQL Server Linked Server to NetSuite Issues
- Considering Producing NetSuite Financial Statements using Third Party Tools?
If you need help working with ODBC on NetSuite to drive enhanced reporting, contact us.
See Related Articles
Marty Zigman
Holding all three official certifications, Marty is regarded as the top NetSuite expert and leads a team of senior professionals at Prolecto Resources, Inc. He is a former Deloitte & Touche CPA and has held CTO roles. For over 30 years, Marty has produced leadership in ERP, CRM and eCommerce business systems. Contact Marty to set up a conversation.
More Posts - Website - Twitter - Facebook - LinkedIn - YouTube
Can we use stored procedure?
Hi Mitsha,
NetSuite’s ODBC system is read only and does not support stored procedures.
Marty