Patent Number 8,375,010
United States Patent 8,375,010 provides a way for Sesame Software’s Relational Junction replication offerings to create related records in Salesforce, NetSuite, and QuickBooks in one pass, keeping the child records pointing to the parents as new parents are created in the SaaS system. This technique allows a user of the system to create new parent-child records with temporary keys in the relationship fields. As the new parent records are created in the SaaS system during replication, the replication process is notified of the new key generated by the SaaS application. The replication process updates the local database with this key. Database triggers generated ahead of time are knowledgeable of the relationships in the data model, and look for related record with the old key, updating the key values where found.
A computer-implemented method for integrating applications with a network service application is provided. A database management system automatically updates a local database of a computer with information contained within a remote database and an application is enabled to generate a new record in the local database with temporary values in the relationship fields such that the child records are logically related to one or more parent records by virtue of having the same relationship values. A new record is created by the web service for the parent record. When a changed value of the parent record’s key is detected, a value of the key of relevant changed parent record is written into one or more local related record’s relationship field.
Method of integrating applications with a network service application by creating new records in a relationship field
Awarded February 12, 2013