Granted Patent B1

US 12,229,099 · App. 17/960,736 · Granted Feb 18, 2025

Inventors: Sovane Bin (San Francisco, CA); Saddek Dekoum (Ris Orangis, FR); Raphaël Fonrouge (Chatenay Malabry, FR); Francois Lopitaux (San Carlos, CA); Sohil Sheth (Walpole, MA); Nicolas Roquebert (Villepreux, FR); Omar Albasaiteh (Colombes, FR)

Assignee: Odaseva Technologies SAS

G06F16/2246G06F16/2272

Abstract

Claims (47)

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.

2. The method of claim 1 , wherein, as the user is creating the extraction tree, the system enables the user to set extraction filter criteria for each data object inserted into the extraction tree by the user.

3. The method of claim 2 , wherein the extraction filter criteria comprises one or more of: limiting the rows in a data object from which data will be extracted, limiting the fields in the data object from which data will be extracted, and matching the fields and values in the data object.

4. The method of claim 2 , wherein the extraction filter criteria comprises skipping specified rows or fields.

5. The method of claim 1 , wherein the interface is a graphical user interface.

6. The method of claim 1 , wherein the interface is an application programming interface (API).

7. A non-transitory computer-readable medium comprising a computer program, that, when executed by a computer system, enables the computer system to perform the following steps for extracting entity data from a plurality of related data objects from an external multi-tenant software-as-a-service (SaaS) environment, the steps 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.

8. The non-transitory computer-readable medium of claim 7 , wherein, as the user is creating the extraction tree, the system enables the user to set extraction filter criteria for each data object inserted into the extraction tree by the user.

9. The non-transitory computer-readable medium of claim 8 , wherein the extraction filter criteria comprises one or more of: limiting the rows in a data object from which data will be extracted, limiting the fields in the data object from which data will be extracted, and matching the fields and values in the data object.

10. The non-transitory computer-readable medium of claim 8 , wherein the extraction filter criteria comprises skipping specified rows or fields.

11. The non-transitory computer-readable medium of claim 7 , wherein the interface is a graphical user interface.

12. The non-transitory computer-readable medium of claim 7 , wherein the interface is an application programming interface (API).

13. 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 system comprising:

one or more processors;

one or more memory units coupled to the one or more processors, wherein the one or more memory units store instructions that, when executed by the one or more processors, cause the system to perform the operations of:

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.

14. The computer system of claim 13 , wherein, as the user is creating the extraction tree, the system enables the user to set extraction filter criteria for each data object inserted into the extraction tree by the user.

15. The computer system of claim 14 , wherein the extraction filter criteria comprises one or more of: limiting the rows in a data object from which data will be extracted, limiting the fields in the data object from which data will be extracted, and matching the fields and values in the data object.

16. The computer system of claim 14 , wherein the extraction filter criteria comprises skipping specified rows or fields.

17. The computer system of claim 13 , wherein the interface is a graphical user interface.

18. The computer system of claim 13 , wherein the interface is an application programming interface (API).

Assignments (1)

References Cited (78)

Cited By (3)

US 12,547,758 US 12,717,823 US 12,744,660