REMOTELY MONITORING AND SCHEDULING A DATA INTEGRATION JOB

• US 20170185446A1
• Filed: 03/14/2017
• Published: 06/29/2017
• Est. Priority Date: 12/24/2008
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Aggarwal, Chandan
• Granted Patent: US 10,565,007 B2
• Time in Patent Office: Days
• CPC Class Codes: G06F 16/254 Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
• CPC Class Codes: G06F 9/451 Execution arrangements for user interfaces
• CPC Class Codes: G06F 9/4843 by program, e.g. task dispatcher, supervisor, operating system
• CPC Class Codes: G06F 9/5005 to service a request
• CPC Class Codes: G06F 9/541 via adapters, e.g. between incompatible applications
• CPC Class Codes: G06F 9/542 Event management; Broadcasting; Multicasting; Notifications
• CPC Class Codes: G06F 9/546 Message passing systems or structures, e.g. queues

Abstract

Methods for deriving an integration module using an electronic computing device, the method are presented, the methods including: providing a framework coupled with a system of computer hardware for remotely monitoring and scheduling a number of data integration (DI) jobs between a number of enterprise applications, where the framework provides an extensible and reusable architecture for the integration module; adding to the integration module at least one function or component corresponding with a user specified requirement via the framework; deploying the integration module as an embedded client to one of the number of enterprise applications by the framework.

Claims

1. A method for deriving an integration module using an electronic computing device, the method comprising:

providing a framework coupled with a system of computer hardware for remotely monitoring and scheduling a plurality of data integration (DI) jobs between a plurality of enterprise applications, wherein the framework provides an extensible and reusable architecture for the integration module;

adding to the integration module at least one function or component corresponding with a user specified requirement via the framework;

deploying the integration module as an embedded client to one of the plurality of enterprise applications by the framework.

2. The method of claim 1, wherein the framework further provides functionalities selected from the group consisting of:

a unified security model and transaction control mechanisms.

3. The method of claim 1, wherein the framework provides the one of the plurality of enterprise applications with the integration module serving as an embedded client in communication with a listener agent, serving as a server in a DI environment.

4. The method of claim 3, wherein the listener agent, by employing a job-control API and a DI server, extends the ability of remotely executing the plurality of DI jobs in one of the plurality of enterprise applications to all other enterprise applications.

5. The method of claim 1, wherein the integration module provides selectable interfaces to configure any of the plurality of DI jobs and at least one associated parameter.

6. The method of claim 5, wherein the at least one associated parameter is selected from the group consisting of:

scheduled time, output format, and notifications.

7. The method of claim 1, wherein the integration module provides selectable options for generating notifications periodically.

8. The method of claim 1, wherein the integration module provides batch mode notifications for the plurality of DI jobs selected from the group consisting of:

an email, a popup, and a dialog box.

9. The method of claim 1, wherein the integration module is configured to process any of the group consisting of:

a user request, a user credential, and a selected option.

10. The method of claim 9, wherein the integration module appends relevant parameters to the user request.