Production Monitoring for Flink

by Onibex

Provides real-time and historical visibility into invoicing data, enabling monitoring and analysis of performance across plants, sales areas, and divisions.

Reference: onibex-streamingsolutions-productionmonitoring-confluent Platform: Confluent Created by: Onibex

TECHNICAL SPECIFICATIONS

Streaming Method Flink
Streaming Time Real time
Script Language Flink SQL
Implementation Time 15 hours
Tech Layers Data Engineering​ / AI Data Foundation

DESCRIPTION

Improves real-time tracking of production orders, planned, in-process, delayed,​ and completed; rejections, downtime, and lead-time deviations versus plan.​ Provides a clear view of shop floor control, enabling faster decision-making and​ facilitating production planning.



Dependencies: ​

    • One Connect for SAP + ​
    • One Connect Stream +
    • Databricks and Snowflake Dynamic Tables



STREAMING SOLUTION ASSET DETAILS







FLINK SCRIPTS INCLUDED: ​

  • onibex-dp-production-s4h-OI_SILVER_PP_PRODUCTION_ORDER_TEC.flinkcloud.sql
  • onibex-dp-production-s4h-OI_GOLD_PP_PRODUCTION_AVG_TEC.flinkcloud.sql
  • onibex-dp-production-s4h-OI_GOLD_PP_PRODUCTION_COMPONENT_DETAIL_TEC.flinkcloud.sql
  • onibex-dp-production-s4h-OI_GOLD_PP_PRODUCTION_MONTHLY_SUMMARY_TEC.flinkcloud.sql



STREAMING SOLUTION SOURCE DATA PRODUCTS



CATEGORY

FUNDATIONAL DATA PRODUCT

PLANT TO PRODUCE

PRODUCTION ORDER

SALES AND DISTRIBUTION

TRADING GOODS

ORGANIZATIONAL STRUCTURE

SHIPPING CONDITION

ORGANIZATIONAL STRUCTURE

SALES ORGANIZATION

ORGANIZATIONAL STRUCTURE

DISTRIBUTION CHANNEL

ORGANIZATIONAL STRUCTURE

CUSTOMER SALES DISTRICT

ORGANIZATIONAL STRUCTURE

PLANTS

ORGANIZATIONAL STRUCTURE

SALES OFFICE

ORGANIZATIONAL STRUCTURE

SALES DIVISION

ORGANIZATIONAL STRUCTURE

MATERIAL GROUP

ORGANIZATIONAL STRUCTURE

MATERIAL HIERARCHY

OTHER PRODUCTS FROM SAME CATEGORY