Patent Number 8,375,010
Method of integrating applications with a network service application by creating new records in a relationship field
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.
United States Patent 8,375,010 covers a method for integrating applications with a network service application by creating new records in a relationship field. The invention improves how applications create and associate records across systems when relationships must be maintained automatically. This is particularly relevant in enterprise CRM and SaaS environments where records are connected through relationship objects, linking fields, or relational structures. By enabling automated relationship-based record creation, the method improves data integrity and reduces the need for manual intervention during integration workflows. Organizations benefit from more accurate synchronization, more reliable integration logic, and improved scalability when connecting enterprise applications across networks.
This patent matters because enterprise application integrations often depend on maintaining accurate relationships between records across systems. By creating new records through relationship fields, the invention improves data integrity, reduces manual reconciliation, and enables more scalable synchronization between network service applications and connected systems.
Method for Relationship-Based Record Creation
Awarded February 12, 2013