How to know if any system can integrate with Netsuite or Not?

Hi All,

 

 

This post is for newbie or people who want to know if we can integrate new system with Netsuite, Netsuite is #1 erp system, it also has CRM, PS, Ecom, BI. Use this link to read more.

 

 

However companies use Sales Force for CRM, Open air for PS and many Ecom systems. They definitely have many reasons to use different systems.With so many systems comes issue in integrating it to Netsuite. Usually all orders flow into Netsuite, Billings, time sheets, invoicing etc happens in Netsuite. So companies are required to integrate their other Software System with Netsuite.

There are 3 ways user can add data or process data in Netsuite:

1. Integration using Rest APIs and Netsuite APIs:If system you are integrating with Netsuite provides Rest APIs, this is best way to develop/integrate functionality. 

   To Send Data : You can use User Event Script to send data instantly to another system from Netsuite. If you want to send data every 30 min or 1 hour or as per need, use Scheduled Script. 

    To Accept/Get Data: You can use scheduled Script to call Rest APIs at certain period of time and get data from another system to Netsuite. If your system allows to call rest APIs, use Suitelet or Restlets to get data and create Records in Netsuite.

*** Please Note: You have to manage External Id to avoid duplicating records. Primary Key for one system usually work as External Id for another system. Design your functionality accordingly.

2.Using Web services or Using tools like Boomi, celigo etc: There are chances you don't want to go into complication of developing scripts in Netsuite and Another System or your company is already using tools like Boomi or Celigo, it is always good idea to use these easy to MAP tools. This reduce development times, get and update data in both systems. One tool is enough to MAP many systems. 

You can also use SuiteTalk and develop your web services using C#, Java or PHP. 

3. CSV Uploads: In case, your system does not allow Rest APIs or Integration using tools, manual efforts are required. Netsuite allows Export and Import functionality. You can export data as per your need and import it into your system, you can create CSV and import into Netsuite to create records. You can also use combination of tool and CSVs to integrate systems. 

We hope this will help you in understanding if you can integrate Netsuite or Not. Let us know if you have any query. Do let us know if you are using some other way to integrate Netsuite.

Thanks

Netsuite Guru

 

 

Download Netsuite Guru Android App
Follow Me on Linkedin
Our FB Page