Creating exports with SuiteAnalytics Connect

When a client needs to access their NetSuite data from another system, we have a few natively supported options for making this happen. I will cover all of the integration options in Chapter 19, Managing Integrations, but when we're talking about more than a little data, and the client needs to access that data regularly, we usually steer them toward SuiteAnalytics Connect. This is NetSuite's built-in, easily enabled option that allows other applications to make industry-standard connections in NetSuite to pull data out of the system. This is a one-way street, if you will; we can't use this feature to make any updates in NetSuite.

Some people call this "ODBC" since that's the most commonly selected option for making the connection to NetSuite at a technical level, but the system offers a couple of other standard options as well – JDBC and ADO.NET. Users running software outside of NetSuite use one...