Extraction of Release Management Plan and Demand Data into Data Lake

As part of the multi-tenant (MT) cloud environment, Infor Data Lake provides a data connection with all tenants. This allows for the integration of plan and demand data from Release Management with Data Lake. The extracted data from Release Management includes single plans and combined plans. Plan updates, along with the demand revisions, integrate with Data Lake. Plan and demand data is synchronized with the Data Catalog in Data Lake upon each occurrence of a plan update. Key fields link the demand data to the corresponding plan, which ensures the plan and demand data remain in sync.

Each plan record has its own unique revision number to identify the Plan version and its corresponding demands to interpret metrics.
Note: Existing historic plans and demand revisions are not integrated with Data Lake.

The key benefit of this integration is to record the continuous stream of plan updates that result from EDI messages, as well as manual revisions to plan demands. In addition, the integration provides a near real-time data pipeline for operational reporting on sale release, plan, and demand data.

The information is stored in Data Lake as newline-delimited JSON objects (for example, demand.json and plan.json). The metadata for the plan and demand data objects is defined in the Data Catalog, and the metadata is defined through ION.

Infor Data Fabric provides several tools to retrieve the data in Data Lake:

  • JDBC adapter
  • API
  • Compass SQL

For detailed instructions about how to create data catalog schema definitions for Release Management plans and demands, see KB 2304755 on the Infor Customer Portal. Refer to Infor Data Fabric User Guide for information about managing data in Data Lake.