Netsuite Integration
We are just beginning our requirements analysis for NetSuite. We have a home grown CRM that must be integrated with NetSuite to push and pull a large amount of data. I am curious as to what others use. We currently have PeopleSoft and use SSIS and stored procedures. Our consultants are recommending either Boomi (I am thinking this is an expensive choice) , mulesoft and SSIS. We do not need real time. Thanks!
For pulling data out of NetSuite, we use SuiteAnalytics Connect (which is basically a Read Only ODBC connection to the Netsuite database). Via the ODBC, we have created a Linked Server on our MS SQL Server and can perform OPENQUERY sql queries against it.
For pushing data into NetSuite, we have built our own point to point REST integration from MS SQL Server to NetSuite using NetSuite Scripting RESTlets.
We built custom flows using SuiteScript when we needed full logic control, but middleware usually wins for quick setups. We tried a few options, and one platform that really stood out was Skyvia – it let us sync data bi‑directionally, map fields intuitively, and only push changes without custom code, which saved us a ton of time and headaches.
