Netsuite SuiteAnalytics Explained
As of 2027.01, Netsuite's SOAP API endpoints are going to be unavailable. I'm currently building an integration between Netsuite and Planful via Boomi. I've previously written integrations to Netsuite using Python. However, I believe this is the endpoint that will be unavailable. Netsuite say that connections need to move to SuiteAnaltics Connect, however, it is far from clear what exactly Netsuite are referring to.
I think one of my main annoyances is how corporate software is named and the need to get some element of the core product name into everything:
- NetSuite
- SuiteQL
- SuiteTax
- SuiteAnalytics
- SuiteBundler
- SuiteCloud
It feels like it's easy to get turned around in knots around what exactly each feature or module is doing.
Within Netsuite, there is a tab for "Analytics", this appears to be a UI for SuiteAnalytics. Users can create datasets and workbooks with data. Now, the SuiteAnalytics datasets are available over the SuiteTalk (SOAP) API, but do not appear to be available over SuiteAnalytics Connect. The datasets, but not workbooks, are available to export to "SuiteQL TXT" file. I assume that the intended use would be a competent user would create a dataset, which is then handed over to the integrations person to then do the technical work.
As best I can tell, the SuiteAnalytics Connect purely refers to the connection service (ODBC, JDBC, ADO.NET) and not the Analytics UI within Netsuite.
Whilst SuiteQL can be really useful for ultimate control over the data you're selecting, I think that it leaves something to be desired when compared to the hand-holding the saved searches do. For me, saved searches are really powerful and it seems a shame to not be able to pass a search id and get the results. I also think that if Netsuite a promoting SuiteQL through Analytics, really there should be somewhere in the UI to run SuiteQL without having to rely on Tim Dietrich's SuiteQL Tool.. I think my main frustration with SuiteQl is how poorly documented the tables are. It's hard to find a good list of the fields in either the transactionLine or transactionAccountingLine table.