NetSuite have had their RESTful API in Beta since early 2020. NetSuite is a highly sophisticated ERP system that can be customised by any business for their specific needs. It can be used as an ERP, CRM, Project Management tool – and more.
Because it is such a flexible system, the data model behind it is also complex. Each business will generally purchase consulting services as well as licenses to set things up. This will involve creating lots of custom data fields and custom data entities within the system. This is a really powerful capability that has allowed NetSuite work with tens of thousands of customers around the world. They are industry agnostic and have a global operational footprint.
NetSuite provide a number of different ways to get data out of NetSuite so that your business can use it within other systems. SuiteTalk Web Services, RESTlet scripts using SuiteScript, Suitelets to build custom pages and now, the new RESTful API. We like the RESTful API above the other options because it is a standard integration that requires no knowledge of NetSuite’s proprietry languages such as SuiteTalk and SuiteScript. We do of course need to understand the data model and work with the Authentication protocols enforced.
We have recently launched our connector for NetSuite using this REST API with our first client on-board and very happy with the solution.
There is a growing eco-system of products around NetSuite for sales, marketing, reporting, logisitcs etc., but often there is a need to use the data outside of the eco-system. A common area that requires NetSuite data is Business Inteligence and Reporting – which is what we focus on at Uniformity. NetSuite has reporting features and a degree of Analytics within their platform. You can also import and plug-in other data sources to NetSuite to create more integrated reports. However, there are times when there is a need to extract the data from NetSuite.
- If your business already has a functioning Data Warehouse and Business Intelligence platform that works with multiple data sources. If NetSuite is introduced to your business, you will want to add that data to the existing BI platform – rather than re-engineer everything to feed into NetSuite.
- If your BI and Analytics needs are more advanced then what can be achieved within the NetSuite platform at an acceptable cost.
- You need to feed the NetSuite data to other external systems in a bespoke manner.
Our general model is to extract all data from NetSuite on the first day and then only extract delta changes thereafter. By doing so we can minimise the calls required to NetSuite and reduce costs of compute in processing. We can send the data to any destination database or file store. We generally send the data to a reporting database or data warehouse. From there the data can be utilised by the relevant teams within your business to create deep analytics or integrations with other systems. We can also help our customers in creating a full solution for Business Intelligence.
For example we can pull the data from NetSuite to a simple standard SQL database on Azure and create transformational Business Intelligence reports on Microsoft Power BI.
If any of this sounds interesting, please drop us a line. We are always happy to provide a free, no commitment consultation.