Methods and systems for integrating external systems of records with final report

Patent metadata

Field	Value
Publication number	US-2024086416-A1
Application number	US-202217930925-A
Country	US
Kind code	A1
Filing date	Sep 9, 2022
Priority date	Sep 9, 2022
Publication date	Mar 14, 2024
Grant date	—

Abstract

A method of accessing data from disparate data sources at a data access layer, the method comprising: receiving a request to ingest raw data from a plurality of systems of record; ingesting raw data from the plurality of systems of record based on the received request to ingest raw data; mapping the ingested raw data to a plurality of unpopulated enterprise object models to standardize the ingested raw data and to populate the enterprise object models; storing the standardized data and the plurality of populated enterprise object models; and providing the plurality of populated enterprise object models to the data access layer for accessing the standardized data.

First claim

1 . A method of accessing data from disparate data sources at a data access layer, the method comprising:
receiving a request to ingest raw data from a plurality of external systems of record; ingesting raw data from the plurality of systems of record based on the received request to ingest raw data; mapping the ingested raw data to a plurality of unpopulated enterprise object models to standardize the ingested raw data and to populate the enterprise object models; storing the standardized data and the plurality of populated enterprise object models; providing the plurality of populated enterprise object models to the data access layer for accessing the standardized data; and creating one or more objectified view of a workflow by using the standardized data based on the request.

2 . The method of claim 1 , wherein the plurality of enterprise object models is mapped from the ingested raw data to a common lexicon.

3 . (canceled)

4 . The method of claim 1 , further comprising transforming the collected raw data before the data is mapped to the plurality of enterprise object models, and wherein the collected and transformed raw data is deleted at a given time frame after a project completion.

5 . (canceled)

6 . (canceled)

7 . (canceled)

8 . The method of claim 1 , wherein the collected raw data is mapped to the plurality of enterprise object models within a data lake.

9 . The method of claim 1 , wherein the plurality of external systems of record are the systems of record of a client and each of the plurality of external systems of record is accessible through an application programming interface, and wherein the plurality of external systems of record include one or more of a manufacturing execution system, an enterprise resource planning system, an electronic batch record system, and a quality management system.

10 . The method of claim 1 , wherein the data access layer is configured to receive one or more electronic validations to validate the provided plurality of enterprise object models.

11 . A method for providing data for presentation in a report through a data access layer, the method comprising:
ingesting raw data from a plurality of external systems of record based on a received request to ingest raw data; providing the ingested raw data to an integration framework for integration of the raw data to a plurality of enterprise object models as integrated data; storing the integrated data; populating a plurality of enterprise object models with the integrated data based on a user request; providing the plurality of populated enterprise object models to a data access layer for accessing the integrated data and generating one or more reports based on the integrated data; and creating one or more objectified view of a workflow by using the integrated data based on the user request.

12 . The method of claim 11 , wherein the integration framework includes a common lexicon for converting raw data to a common framework.

13 . The method of claim 11 , wherein the plurality of external systems of record include one or more of a manufacturing execution system, an enterprise resource planning system, an electronic batch record system, and a quality management system.

14 . The method of claim 11 , wherein the ingested raw data is ingested over a particular time frame.

15 . (canceled)

16 . The method of claim 11 , wherein the ingested raw data is real-time data that is provided to the integration framework for real-time integration of the raw data to the plurality of enterprise object models to provide real time enterprise object models to the data access layer.

17 . The method of claim 16 , wherein the real time enterprise object models are used to generate a real time report through the data access layer.

18 . A system for providing processed data to a data access layer for the generation of a data-based product, the system comprising:
a processor communicatively coupled to a plurality of external systems of record; a memory including one or more instructions that when executed by the processor cause the system to:
ingest raw data from at least one of the plurality of systems of record based on a received request to ingest raw data;
provide the ingested raw data to an integration framework for integration of the raw data to a plurality of enterprise object models as integrated data;
store the integrated data;
populate a plurality of enterprise object models with the integrated data based on a user request;
provide the plurality of populated enterprise object models to a data access layer for accessing the integrated data and generating one or more reports based on the integrated data; and
create one or more objectified view of a workflow by using the integrated data based on the user request.

19 . The system of claim 18 , wherein the data access layer is configured to receive one or more electronic validations to validate the provided plurality of enterprise object models.

20 . The system of claim 18 , wherein the ingested raw data is integrated to the plurality of enterprise object models within a data lake and the ingestion of the raw data is based on a multi-factor authentication.

21 . The method of claim 1 , further comprises:
auditing the raw data to monitor one or more services performed by the plurality of external systems to locate a source of an error associated with the raw data; providing access to the workflow to define customizable features, and wherein the customizable features are at least one of: charts, graphs, and texts; autopopulating the one or more enterprise object models for viewing in a report; and allocating one or more tasks to generate one or more schedules and assign one or more tasks.

22 . The method of claim 1 , wherein creating the one or more objectified view of the workflow comprises creating at least one of: a work process, work products, behaviors, outcomes, and other data.

23 . The system of claim 18 , wherein the plurality of external systems of record includes one or more of a manufacturing execution system, an enterprise resource planning system, an electronic batch record system, and a quality management system.

24 . The system of claim 18 , wherein the system further comprises at least one of: a data storage module, an identity management module, a data transformation module, an audit logging module, a domain models module, and a permissions module, and wherein the data storage module further comprises one or more storage drives configured to retrieve the integrated data, and wherein the identity management module is configured to provide one or more identity services, and wherein the data transformation module is configured to translate the raw data, and wherein the audit logging module is configured to track one or more services performed by the users of the system, and wherein the domain models module is configured to store one or more relationships of the raw data in a lexicon, and wherein the permission module is configured to determine whether the user is configured to access one or more parts of the integrated data.

25 . The system of claim 18 , wherein the system further comprises a workflow engine, wherein the workflow engine is further configured to: allocate one or more tasks, generate one or more schedules, and assign one or more tasks.

Assignees

• Honeywell Int Inc

Inventors

• Singh Ankit
• Sneed Timothy
• Ramasubrahmanyan Arun
• Fainor Judith

Classifications

• G06F16/254 Primary

  Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses · CPC title