Service oriented architecture for a loading function in a data integration platform
View Patent ↗A loading function of an extract-transform-load data integration process is deployed as a service in a services oriented architecture by providing a module, the module being a data loading module for loading data into a target database that is associated with a data integration platform; by providing a registry of services; and by providing an interface for the data loading module; and identifying the data loading module in the registry; wherein the data loading module can be accessed as a service in a services oriented architecture.
1. A computer-implemented method executed in a facility, the method comprising:
providing a module, the module being a data loading module containing a plurality of instructions to cause a processor of a computer to load a plurality of data from an application into a target database that is associated with a data integration platform;
providing a registry of services in the data integration platform;
providing an interface for the data loading module; and
identifying the data loading module for the target database in the registry;
loading the plurality of data from the application into the target data base using the data loading module;
wherein the data loading module is accessed by the interface as a service in a services oriented architecture, the service forming part of an infrastructure of a business enterprise and configured to be a building block for development of a plurality of applications and deployment of the plurality of applications, and to avoid redundant code, while embodying a set of business logic bound to the target database; and
wherein when the computing environment of the application changes, the plurality of data is loaded into the target database using a different data loading module identified in the registry that is appropriate for the new computing environment.
2. The computer-implemented method of claim 1 further comprising providing an identified data extraction module in the registry.
3. The computer-implemented method of claim 1 further comprising providing an identified data transformation module in the registry.
4. The computer-implemented method of claim 1 further comprising providing an identified target mapping module in the registry.
5. The computer-implemented method of claim 1 further comprising providing an identified metadata management module in the registry.
6. The computer-implemented method of claim 1 further comprising providing an identified data profiling module in the registry.
7. The computer-implemented method of claim 1 further comprising providing an identified mapping module in the registry.
8. The computer-implemented method of claim 1 further comprising providing an identified data quality module in the registry.
9. The computer-implemented method of claim 1 further comprising providing an identified data cleansing module in the registry.
10. The computer-implemented method of claim 1 further comprising providing an identified atomic data repository module in the registry.
11. A system comprising:
a plurality of computers connected by a network to a target database associated with a data integration platform, a data integration platform, and a registry of services;
a data loading module, stored in a memory connected to a computer, configured for an interface and to cause a processor of the computer to load a plurality of data from an application into the target database, wherein the memory is in a facility;
wherein the registry of services and the interface are in the facility; and
wherein the data loading module is identified in the registry of services; and
wherein the plurality of data is loaded from the application into the target database using the data loading module;
wherein the data loading module is accessed by the interface as a service in a services oriented architecture, the service forming part of an infrastructure of a business enterprise, the service configured for a development of a plurality of applications, for a deployment of the plurality of applications, and for avoiding redundant code, while embodying a set of business logic bound to the target database; and
wherein when the computing environment of the application changes, the plurality of data is loaded into the target database using a different data loading module identified in the registry that is appropriate for the new computing environment.
12. The system of claim 11 further comprising an identified data extraction module in the registry.
13. The system of claim 11 further comprising an identified data transformation module in the registry.
14. The system of claim 11 further comprising an identified target mapping module in the registry.
15. The system of claim 11 further comprising an identified metadata management module in the registry.
16. The system of claim 11 further comprising an identified data profiling module in the registry.
17. The system of claim 11 further comprising an identified mapping module in the registry.
18. The system of claim 11 further comprising an identified data quality module in the registry.
19. The system of claim 11 further comprising an identified data cleansing module in the registry.
20. The system of claim 11 further comprising an identified atomic data repository module in the registry.