(858) 586 7777 | About | Testimonials | Contact
vteams vteams vteams vteams
  • How does it work?
    • Startup Process
    • Your First Day
  • Technologies
    • Hire PHP Developer
    • Hire App Developer
    • Hire JavaScript Developer
    • Hire ROR Developer
    • Hire IOS Developer
    • Hire .NET Developer
    • Hire AI Developer
    • Hire Robotics Engineer
  • Sample Budgets
  • Meet The Team
  • Experiments
  • Captain’s Log
  • Blog
vteams vteams
  • How does it work?
    • Startup Process
    • Your First Day
  • Technologies
    • Hire PHP Developer
    • Hire App Developer
    • Hire JavaScript Developer
    • Hire ROR Developer
    • Hire IOS Developer
    • Hire .NET Developer
    • Hire AI Developer
    • Hire Robotics Engineer
  • Sample Budgets
  • Meet The Team
  • Experiments
  • Captain’s Log
  • Blog
Blog
  1. vteams
  2. Blog
  3. Integration of NetSuite with MySQL
May 09

Integration of NetSuite with MySQL

  • May 9, 2014

Ali-Muhammad---NetsuiteRecently 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).

netsuite1

url=www.ourserver.com/nsping.php

response = nlapiRequestURL (url, data, header, “POST”);

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.

netsuite2

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.

$wsdl=”https://webservices.netsuite.com/wsdl/v2013_1_0/netsuite.wsdl”;
$connection=new SoapClient ($host,$wsdl);

Finalizing Synchronization:

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.

$searchItems = new nsComplexObject(“TransactionSearchBasic”);
$searchItems->setFields(array(“tranId” => array(“operator” => “is”,”searchValue”=> $itemid)));
$response=$connection->search($searchItems);
$database->synchronize($response);

  • Facebook
  • Twitter
  • Tumblr
  • Pinterest
  • Google+
  • LinkedIn
  • E-Mail

Comments are closed.

SEARCH BLOG

Categories

  • Blog (490)
  • Captain's Log (1)
  • Closure Reports (45)
  • Experiments (7)
  • How-To (56)
  • Implementation Notes (148)
  • Learn More (156)
  • LMS (8)
  • Look Inside (10)
  • Operations Log (12)
  • Programmer Notes (20)
  • R&D (14)
  • Rescue Log (4)
  • Testimonials (25)
  • Uncategorized (4)

RECENT STORIES

  • GitHub Actions- Automate your software workflows with excellence
  • Yii Framework – Accomplish Repetitive & Iterative Projects with Ease
  • A Recipe for CRM Software Development
  • Are Agile and DevOps the same?
  • The Data Scientist’s Toolset

ARCHIVES

In Short

With the vteams model, you bypass the middleman and hire your own offshore engineers - they work exclusively for you. You pay a reasonable monthly wage and get the job done without hassles, re-negotiations, feature counts or budget overruns.

Goals for 2020

  • Open development center in Australia
  • Complete and Launch the Robot
  • Structural changes to better address Clients' needs

Contact Us

Address: NEXTWERK INC.
6790 Embarcadero Ln, Ste 100,
Carlsbad, CA 92011, USA

Tel: (858) 586 7777
Email: fahad@nextwerk.com
Web: www.vteams.com

© 2020 vteams. All Rights Reserved.

Content Protection by DMCA.com