Recently we integrated Netsuite with a custom designed portal. Our client wanted to use NetSuite data in real-time to prepare custom quotes on the portal. A key requirement was to sync data between NetSuite and the custom MySQL Database without errors and with full data integrity. The purpose of this module was to eliminate manual
Recently we integrated Netsuite with a custom designed portal. Our client wanted to use NetSuite data in real-time to prepare custom quotes on the portal. A key requirement was to sync data between NetSuite and the custom MySQL Database without errors and with full data integrity. The purpose of this module was to eliminate manual and redundant data entry across systems. We implemented the solution in PHP.
Solution:
Database:
Developer analyzed NetSuite Record structure from SOAP response and designed schema in MYSQL to map the required data. A database relationship was created after traversing XML obtained against each record.
Communication Link between NetSuite and Application Server:
NetSuite Suitescript provides a variety of internal and external communication packages. User Event scripting engine was used to notify the application server with all the changes or updates applied to record in NetSuite. Each script was deployed in associated record and bound by event type (Edit, Delete, Create, Append, and View).
NetSuite NLAPI was used to ping the application server if record updated in NetSuite, JSON encoded securing data was captured on restful service consist of a record type and NetSuite id. All pings were logged into a queue for further processing.
Synchronization Process:
All Pings were handed over to the Ping Manager which was running every minute as a Cron Job and was looking for an unprocessed queue. Each ping contain NetSuite primary key of the record called an ‘Internal id’. Object oriented Cron Management process was also implemented to control the processing speed of the queue and prioritizing records within queues.
$objCronMaster->Sync($server);
Communication Link between Application Server and NetSuite:
Connection with NetSuite remained open using SOAP if the queue was unprocessed.
NetSuite search criteria was used to extract SOAP response of the record using NetSuite equivalent keys stored in the queue, after parsing the response, the record was finally updated in the database. Data pull operations were dedicated for this purpose.
One of the essential skills every Python programmer should have is the ability to run Python scripts in a terminal. In this comprehensive guide, we’ll cover various ways to run Python scripts in a terminal and explore different scenarios, including running Python on Windows and executing Python scripts in Linux. Let’s learn more about how
Routers play a pivotal role in segmenting and managing traffic. They are the guardians of data flow, separating and directing it to its intended destination. A fundamental concept in networking is the creation of broadcast domains, which are distinct areas within a network where broadcast traffic is contained. In this blog, we will explore how
Having a dual monitor setup can significantly enhance your productivity, allowing you to multitask efficiently and work on multiple tasks simultaneously. However, encountering the issue of both monitors displaying the same content can be frustrating and hinder your ability to take full advantage of the dual monitor setup. In this blog post, we will explore
This article throws some light on working with Core Data background threads as it is not documented in any of Apple’s Core Data guide: Requirement and Idea: In one of our existing iPad application, we had to implement offline feature that requires storing all data in device’s local storage. We were using Apple’s Core Data,
In this article, we will explore how to add fonts to Google Docs, including custom fonts, and also discuss how to add fonts to Google Slides for added creativity. Additionally, we’ll cover how to access the Extensis Fonts add-on to expand your font choices even further. Let’s dive in! How to Add Fonts to Google
ABOUT THE AUTHOR
Aayan Arif
Content Strategist at vteams - Aayan has over 8 years of experience of working with multiple industries.
0 Comments