ANS-0395 · WEB SERVICES & INTEGRATIONS
How to Query NetSuite Data from a Website Using ODBC/JDBC?
Explore the capabilities and limitations of using SuiteAnalytics Connect for integrating NetSuite data with external web applications.
Short answer
Yes, NetSuite can be queried from a website using an ODBC or JDBC data connection, provided the application supports these protocols. This functionality requires the SuiteAnalytics Connect add-on, which is a paid subscription. It's crucial to note that SuiteAnalytics Connect offers read-only access, meaning data cannot be written back to NetSuite.
Scenario
Organizations often seek to integrate NetSuite data with external web applications for reporting, dashboards, or custom functionalities. A common inquiry involves determining if NetSuite can be accessed and queried directly from a website using standard data connection methods like ODBC or JDBC.
Solution
NetSuite data can be queried from a website application if the application is capable of connecting via ODBC. For Java-based JEE web applications, the JDBC driver with NetSuite can also be utilized. To enable this functionality, organizations must acquire the SuiteAnalytics Connect add-on, which encompasses both ODBC and JDBC capabilities. This add-on is a paid service, estimated to cost around 6000$ per year. It is important to understand the following considerations regarding SuiteAnalytics Connect: * Performance: SuiteAnalytics Connect is not necessarily faster than using NetSuite's webservices or restlets for data retrieval. * Data Access: It provides READ-ONLY access. It is impossible to write data back to NetSuite using SuiteAnalytics Connect.
Expert NetSuite Support
Need help with this NetSuite issue?
Web Services & Integrations consulting and configuration support