# US 2019/0318282 A1 · Enterprise framework for efficient and adaptable workflow application data distribution > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 2019/0318282 A1 - Document ID: US20190318282A1 - Status: Published application - Kind: A1 - Application number: 15/954,228 - Filed: 2018-04-16 - Published: 2019-10-17 - Earliest claimed: 2018-04-16 - Assignees: Bank of America Corporation - Applicants: Bank of America Corporation - Inventors: Rinken Patel; Mahesh K. Krishnaswamy; Chaudhri Nadeem Hassan; Ravindra Gudimella; Giri Babu Sripati - Web page: https://patentgrep.com/patent/US20190318282A1 ## CPC - G06Q 10/0633: Workflow analysis - G06F 8/34: Graphical or visual programming - G06F 8/35: model driven - G06F 8/60: Software deployment - G06F 8/65: Updates (security arrangements therefor G06F21/57) - G06Q: INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR - G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N) ## Abstract A system and methods for an enterprise framework for efficient and adaptable workflow application data distribution using a Software Deployment Management (SDM) environment such as Pega® are described. Workflow data is received by the system from a workflow management application and modeled for downstream use. Use of a consumer data provisioning point (CDPP) agent includes utilization of a central control table that assists with the extraction, transformation and loading of workflow data from a proprietary format to a modeled relational forma. An end to end (E2E) automation process is controlled by the CDPP agent which facilitates extraction of data from upstream Pega® applications with configurable frequency for the transformed data. Embodiments of the invention provide efficiency improvements by automating numerous steps and eliminating the need for human input for various steps in the process of workflow data distribution and enable near-real-time data distribution and analytics. ## Claims ### Claim 1 A system for executing an enterprise framework for efficient and adaptable workflow application data distribution using a Software Deployment Management (SDM) environment, the system comprising: one or more memory devices; one or more processing devices operatively coupled with the one or more memory devices comprising instructions executable by the one or more processing devices to: transmit instruction to a proprietary workflow management application requesting workflow data tables; receive the workflow data tables comprising workflow data, each workflow data table having a plurality of corresponding parameters from a plurality of workflow applications; determine the corresponding parameters for each of the workflow data tables; stage the workflow data in a process batch for relational modeling; based on the determined parameters, extract workflow data from the proprietary workflow data tables; model the workflow data in a relational format for downstream consumption; and transmit the relational format data in standardized data tables to a plurality of downstream platforms. ### Claim 2 (depends on 1) The system of claim 1, wherein modeling the workflow data in a relational format for downstream consumption further comprises: determining a standardized relational format for storing relational data tables; based on the standardized relational format, generating one or more model conversion tables configured for transforming workflow data into the standardized relational format; transforming the workflow data by applying the one or more model conversion tables, thereby resulting in relational format data; and populating a plurality of data tables with the relational format data, thereby resulting in the standardized data tables. ### Claim 3 (depends on 1) The system of claim 1, wherein the proprietary workflow management application is a Pega® application. ### Claim 4 (depends on 1) The system of claim 1, wherein the workflow data tables are formatted in extensible markup language. ### Claim 5 (depends on 1) The system of claim 1, wherein the workflow data tables are received from a Pega® system Business Intelligence Exchange process. ### Claim 6 (depends on 2) The system of claim 2, wherein modelling the workflow data in a relational format for downstream consumption and transmitting the relational format data to a plurality of downstream platforms occurs in near-real-time. ### Claim 7 (depends on 1) The system of claim 1 further comprising: storing historical data lineage information about the workflow data and relational format data that includes origin of the data and how it is transformed by the system. ### Claim 8 A computer program product for executing an enterprise framework for efficient and adaptable workflow application data distribution using a Software Deployment Management (SDM) environment, wherein the computer program product comprises at least one non-transitory computer readable medium comprising computer readable instructions, the instructions comprising: transmit instruction to a proprietary workflow management application requesting workflow data tables; receive the workflow data tables comprising workflow data, each workflow data table having a plurality of corresponding parameters from a plurality of workflow applications; determine the corresponding parameters for each of the workflow data tables; stage the workflow data in a process batch for relational modeling; based on the determined parameters, extract workflow data from the proprietary workflow data tables; model the workflow data in a relational format for downstream consumption; and transmit the relational format data in standardized data tables to a plurality of downstream platforms. ### Claim 9 (depends on 8) The computer program product of claim 8, wherein modeling the workflow data in a relational format for downstream consumption further comprises: determining a standardized relational format for storing relational data tables; based on the standardized relational format, generating one or more model conversion tables configured for transforming workflow data into the standardized relational format; transforming the workflow data by applying the one or more model conversion tables, thereby resulting in relational format data; and populating a plurality of data tables with the relational format data, thereby resulting in the standardized data tables. ### Claim 10 (depends on 8) The computer program product of claim 8, wherein the proprietary workflow management application is a Pega® application. ### Claim 11 (depends on 8) The computer program product of claim 8, wherein the workflow data tables are formatted in extensible markup language. ### Claim 12 (depends on 8) The computer program product of claim 8, wherein the workflow data tables are received from a Pega® system Business Intelligence Exchange process. ### Claim 13 (depends on 9) The computer program product of claim 9, wherein modeling the workflow data in a relational format for downstream consumption and transmitting the relational format data to a plurality of downstream platforms occurs in near-real-time. ### Claim 14 (depends on 8) The computer program product of claim 8, further comprising: storing historical data lineage information about the workflow data and relational format data that includes origin of the data and how it is transformed by the system. ### Claim 15 A computer implemented method for executing an enterprise framework for efficient and adaptable workflow application data distribution using a Software Deployment Management (SDM) environment, the computer implemented method comprising: transmitting instruction to a proprietary workflow management application requesting workflow data tables; receiving the workflow data tables comprising workflow data, each workflow data table having a plurality of corresponding parameters from a plurality of workflow applications; determining the corresponding parameters for each of the workflow data tables; staging the workflow data in a process batch for relational modeling; based on the determined parameters, extracting workflow data from the proprietary workflow data tables; modelling the workflow data in a relational format for downstream consumption; and transmitting the relational format data in standardized data tables to a plurality of downstream platforms. ### Claim 16 (depends on 15) The computer implemented method of claim 15, wherein modeling the workflow data in a relational format for downstream consumption further comprises: determining a standardized relational format for storing relational data tables; based on the standardized relational format, generating one or more model conversion tables configured for transforming workflow data into the standardized relational format; transforming the workflow data by applying the one or more model conversion tables, thereby resulting in relational format data; and populating a plurality of data tables with the relational format data, thereby resulting in the standardized data tables. ### Claim 17 (depends on 15) The computer implemented method of claim 15, wherein the proprietary workflow management application is a Pega® application. ### Claim 18 (depends on 15) The computer implemented method of claim 15, wherein the workflow data tables are received from a Pega® system Business Intelligence Exchange process. ### Claim 19 (depends on 16) The computer implemented method of claim 16, wherein modelling the workflow data in a relational format for downstream consumption and transmitting the relational format data to a plurality of downstream platforms occurs in near-real-time. ### Claim 20 (depends on 15) The computer implemented method of claim 15, further comprising: storing historical data lineage information about the workflow data and relational format data that includes origin of the data and how it is transformed by the system.