RE: 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.
