Creating custom exports from NetSuite
When a client needs to export data from one system to any other system, we usually push for the simplest options we can find and only resort to building something custom when those tools just don’t fit the bill. As described in Chapter 17, Analytics, Reports, and Data Exports, our first choice for exports should always be SuiteAnalytics Connect. As a reminder, this is the option that allows a client to connect to NetSuite with one of three industry-standard methods (ODBC, JDBC, or ADO.NET).
They then execute queries to collect any sets of data they need from the system. The client’s technical people can create automation that runs outside NetSuite in a variety of databases, data warehouses, or applications to pull data out on whatever schedule they need. The NetSuite Help page explains how to use the Connect feature, and it’s very popular for this use case. Most developers already know how to use Connect’s SQL...
