Data reporting - process integration tool

Patent metadata

Field	Value
Publication number	US-9906536-B1
Application number	US-201615354256-A
Country	US
Kind code	B1
Filing date	Nov 17, 2016
Priority date	Nov 17, 2016
Publication date	Feb 27, 2018
Grant date	Feb 27, 2018

Abstract

A reporting tool includes a retrieval engine, a context switching engine, a reporting engine, a publication engine, and a subscription engine. The retrieval engine retrieves a request for subscription data. The context switching engine receives security information indicating whether a user is authorized to view reporting data. The reporting engine generates a plurality of batches of reporting data. The publication engine generates the data report by processing the batches. The subscription engine communicates the data report.

First claim

What is claimed is:

1. A reporting tool comprising:
a hardware processor;
a retrieval engine implemented in the hardware processor, the retrieval engine configured to retrieve a request for a subscription to a data report comprising a summary of reporting data, the request for the subscription comprising:
reporting data information indicating the reporting data to include in the data report;
frequency information indicating a frequency to communicate the data report to a first user;
authentication information, authenticating an identity of the first user;
a priority indication; and
a proxy;

a context switching engine implemented in the hardware processor, the context switching engine configured to:
communicate a request for security information to one or more databases, the request for security information comprising the authentication information; and
receive the security information from the one or more databases, the security information indicating whether the first user is authorized to view the reporting data;

a reporting engine implemented in the hardware processor, the reporting engine configured to:
receive the reporting data from the one or more databases, wherein an error in the reporting data corrected based on collected analytics for a job;
determine a table load status indicating whether the reporting data is current;
upon a determination that the reporting data is not current, wait to retrieve the reporting data;
upon a determination that the reporting data is not current, communicate an alert to the first user, the alert indicating that the reporting engine is waiting to receive the reporting data;
retrieve the reporting data upon a determination that the reporting data is current; and
generate a plurality of batches, wherein each batch comprises a subset of the retrieved reporting data;

a publication engine implemented in the hardware processor, the publication engine configured to:
generate the data report before generating another data report which has a second priority indication that is lower than the priority indication, wherein generating the data report comprises:
processing the plurality of batches in parallel; and
aggregating the processed batches to generate the data report; and

determine whether the request for the subscription comprises a request to communicate the data report to one or more additional users; and

a subscription engine implemented in the hardware processor, the subscription engine configured to:
communicate the data report to the first user and to the proxy; and
upon a determination that the request for the subscription comprises a request to communicate the data report to additional users, communicate the data report to the one or more additional users.

2. The reporting tool of claim 1 , wherein, the publication engine publishes the data report in one of HTML format and XML format.

3. The reporting tool of claim 1 , wherein the subscription engine is operable to communicate the data report via one of email, FTP, and a user interface.

4. The reporting tool of claim 1 , wherein the subscription engine is further configured to generate a burst and communicate the burst to the first user, wherein generating the burst comprises:
receiving the data report, wherein the user is not authorized to view the data report;
extracting a subset of data from the data report, wherein the user is authorized to view the subset of data; and
generating a burst report comprising the subset of data.

5. A method comprising:
retrieving a request for a subscription to a data report comprising a summary of reporting data, the request for the subscription comprising:
reporting data information indicating the reporting data to include in the data report;
frequency information indicating a frequency to communicate the data report to a first user;
authentication information, authenticating an identity of the first user;
a priority indication; and
a proxy;

communicating a request for security information to one or more databases, the request for security information comprising the authentication information;
receiving the security information from the one or more databases, the security information indicating whether the first user is authorized to view the reporting data;
receiving the reporting data from the one or more databases;
correcting an error in the reporting data based on collected analytics for a job;
determining a table load status indicating whether the reporting data is current;
upon a determination that the reporting data is not current, waiting to retrieve the reporting data;
upon a determination that the reporting data is not current, communicating an alert to the first user, the alert indicating that the reporting engine is waiting to receive the reporting data;
retrieving the reporting data upon a determination that the reporting data is current;
generating a plurality of batches, wherein each batch comprises a subset of the retrieved reporting data;
generating the data report before generating another data report which has a second priority indication that is lower than the priority indication, wherein generating the data report comprises:
processing the plurality of batches in parallel; and
aggregating the processed batches to generate the data report;

determining whether the request for the subscription comprises a request to communicate the data report to one or more additional users;
communicating the data report to the first user and to the proxy; and
upon a determination that the request for the subscription comprises a request to communicate the data report to additional users, communicating the data report to the one or more additional users.

6. The method of claim 5 , wherein, the publication engine publishes the data report in one of HTML format and XML format.

7. The method of claim 5 , wherein the data report is communicated via one of email, FTP, and a user interface.

8. The method of claim 5 , further comprising generating a burst and communicate the burst to the first user, wherein generating the burst comprises:
receiving the data report, wherein the user is not authorized to view the data report;
extracting a subset of data from the data report, wherein the user is authorized to view the subset of data; and
generating, a burst report comprising the subset of data.

9. A system comprising:
a database; and
a reporting tool comprising a hardware processor, the hardware processor configured to:
retrieve a request for a subscription to a data report comprising a summary of reporting data, the request for the subscription comprising:
reporting data information indicating the reporting data to include in the data report;
frequency information indicating a frequency to communicate the data report to a first user;
authentication information, authenticating an identity of the first user;
a priority indication; and
a proxy;

communicate a request for security information to the database, the request for security information comprising the authentication information;
receive the security information from the database, the security information indicating whether the first user is authorized to view the reporting data;
receive the reporting data from the one or more databases, wherein an error in the reporting data corrected based on collected analytics for a job;
determine a table load status indicating whether the reporting data is current;
upon a determination that the reporting data is not current, wait to retrieve the reporting data;
upon a determination that the reporting data is not current, communicate an alert to the first user, the alert indicating that the reporting engine is waiting to

Assignees

• Bank Of America

Inventors

• Abraham John

Classifications

• H04L63/102 Primary

  Entity profiles · CPC title

• H04L63/0428

  wherein the data content is protected, e.g. by encrypting or encapsulating the payload · CPC title

• H04L63/08 Primary

  for authentication of entities (cryptographic mechanisms or cryptographic arrangements for entity authentication H04L9/32) · CPC title

• H04L63/0281

  Proxies · CPC title