Patent ID: 8639653
Filing Date: 2014-01-28
Classification: G06F,G06Q

Abstract:
1. A method for managing batch operations in an enterprise data integration platform environment, comprising: interfacing a process control framework application with a separate extract-transform-load tool, the extract-transform-load tool including a parameter file identifying a process control framework application name accessed by the extract-transform-load tool, wherein the process control framework application name is substituted for a name of an enterprise resource in the extract-transform-load tool such that the extract-transform-load tool accesses the process control framework application identified by the process control framework application name instead of the enterprise resource; the process control framework application executing a method comprising: defining a window of time in which a batch will run, comprising: entering extract-transform-load information into the batch table, the extract-transform-load information including a workflow identifier, a parameter file identifier, and a location identifier; retrieving a workflow from memory via the workflow identifier and the location identifier, and retrieving the parameter file via the parameter file identifier; processing the batch using the process control framework application identified by the parameter file according to the workflow identifier and the parameter file, and within the window of time entered in the batch schedule table, wherein the workflow identifier specifies a workflow designated to execute a process within the batch, the process identifier defining the process, wherein the parameter file identifier specifies the parameter file identifying the process control framework application designated to run the process, wherein the location identifier identifies a location in which the workflow resides; mapping data from the batch table to a batch working table, the batch working table tracking a status of activity for the batch, the batch identifier used as a foreign key to the batch working table; updating the batch working table with results of batch execution; entering a number of retry attempts for the batch in a batch retry table, the batch retry table containing a foreign key identifying the batch identifier from the batch table; entering a wait time for each of the retry attempts in the batch retry table; executing the batch and retrying execution of the batch, when the execution fails, according to the number of retry attempts and wait time entered in the batch retry table; entering a messaging address into a messaging table, the messaging table containing a foreign key identifying the batch identifier from the batch table, the messaging table further containing a batch status field containing a value that specifies a status of the batch; transmitting a message to the messaging address from the messaging table when a batch status for the batch identifier matches the value in the batch status field in the messaging table; entering an event into an event description field of a run event table, the run event table including an event date field that contains a value specifying a date in which the event occurs; performing an activity associated with the event upon determining an occurrence of the event; entering a maximum number of batches that may be launched at a given time into a first field of the parameter file, entering a maximum number of batches that may be simultaneously run in a second field of the parameter file, ranking batches that are validated for execution, the ranking based upon a defined set of rules that include start and end dates of batch schedules and batch dependencies; assigning a priority value to each of the batches; and executing the batches according to the priority value.