Production Monitoring for Databricks

Name: Production Monitoring for Databricks
Brand: Onibex
SKU: onibex-streamingsolutions-productionmonitoring-databricks

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-databricks Platform: Databricks Created by: Onibex

TECHNICAL SPECIFICATIONS

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

THIS SOLUTION CONTAINS

Trading Goods by Tables

x 1

Reservation Document by Tables

x 1

Production Order by Tables

x 1

Shipping Condition by Tables

x 1

Distribution Channel by Tables

x 1

Customer Sales District by Tables

x 1

Plants by Tables

x 1

Sales Office by Tables

x 1

Sales Division by Tables

x 1

Material Group by Tables

x 1

Material Hierarchy by Tables

x 1

Sales Organization by Tables

x 1

Inventory Movement Stock by Tables

x 1

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

DATABRICKS SCRIPTS INCLUDED:

onibex-dp-production-s4h-silver_production-databricks.py
onibex-dp-production-s4h-OI_GOLD_PP_PRODUCTION_AVG_TEC-databricks.py
onibex-dp-production-s4h-OI_GOLD_PP_PRODUCTION_COMPONENT_DETAIL_TEC-databricks.py
onibex-dp-production-s4h-OI_GOLD_PP_PRODUCTION_MONTHLY_SUMMARY_TEC-databricks.py

STREAMING SOLUTION SOURCE DATA PRODUCTS

CATEGORY	FOUNDATIONAL DATA PRODUCT
PLANT TO PRODUCE	PRODUCTION ORDER
SALES AND DISTRIBUTION	TRADING GOODS
MATERIALS MANAGEMENT	INVENTORY MOVEMENT STOCK
MATERIALS MANAGEMENT	RESERVATION DOCUMENT
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