US 12,229,099 B1
System, method, and computer program for extracting entity data from a plurality of related data objects from an external multi-tenant SaaS environment
Sovane Bin, San Francisco, CA (US); Saddek Dekoum, Ris Orangis (FR); Raphaël Fonrouge, Chatenay Malabry (FR); Francois Lopitaux, San Carlos, CA (US); Sohil Sheth, Walpole, MA (US); Nicolas Roquebert, Villepreux (FR); and Omar Albasaiteh, Colombes (FR)
Assigned to Odaseva Technologies SAS, Neuilly-sur-Seine (FR)
Filed by Odaseva Technologies SAS, Neuilly-sur-Seine (FR)
Filed on Oct. 5, 2022, as Appl. No. 17/960,736.
Int. Cl. G06F 16/00 (2019.01); G06F 16/22 (2019.01)
CPC G06F 16/2246 (2019.01) [G06F 16/2272 (2019.01)] 18 Claims
OG exemplary drawing
 
1. A method, performed by a computer system, for extracting entity data from a plurality of related data objects from an external multi-tenant software-as-a-service (SaaS) environment, the method comprising:
extracting metadata related to an entity's data records in the external multi-tenant SaaS environment;
using the metadata to identify a data schema associated with the entity's data in the multi-tenant SaaS environment, wherein the data schema forms a hierarchy of at least three levels of the entity's data in the multi-tenant SaaS environment;
providing an interface for enabling a user to create an extraction tree;
creating the extraction tree in the interface by a user viewing data objects in the data schema and selecting a plurality of data objects in the data schema as nodes in the extraction tree, wherein the extraction tree is stored in memory;
building the extraction tree by the system automatically inserting any connecting data objects that are in between the selected plurality of data objects in the data schema as connecting nodes in the extraction tree;
enabling a user to add any parent and child data objects in the data schema of the selected plurality of data objects and the any connecting data objects that were added as nodes and connecting nodes to the extraction tree to a next level of the extraction tree;
enabling a user to add multiple additional levels to the extraction tree, wherein at each new level of the extraction tree the user is able to add both parent and child data objects in the data schema of data objects corresponding to nodes in a previous level of the extraction tree, enabling a user to traverse up and down the hierarchy of the data schema in adding child nodes to the extraction tree;
creating an extraction plan based on the extraction tree; and
extracting data from the multi-tenant SaaS environment based on the extraction plan.