Skip to Content

H3A Bronze Lakehouse

Version 2.1 by Dimitri Rupp on 2026/06/11 09:16
Warning
For security reasons, the document is displayed in restricted mode as it is not the current version. There may be differences and errors due to this.
On this page

H3A Bronze Lakehouse

Information

Source system: H3A — third-party operational system
Stage: Bronze (raw landing zone)
Owner: Fabric team (restricted access)

Overview

📋 WhatTables from the H3A Data Warehouse. Acts as the landing zone for all H3A-related data. No transformations are carried out here.
🔄 HowData is copied via Fabric Data Pipelines.
🔐 WhoAccess is restricted to the Fabric team.

Orchestration

PropertyValue
🛠️ ToolFabric Data Pipeline
🆔 Pipeline namegetH3ADWH
ℹ️ FunctionCopy data from H3A DWH to h3a_bronze_lh
⚡ Trigger0400_Daily_h3a pipeline
🕞 Time04:00 AM daily
flowchart LR
    H3A[(H3A DWH
Source database)] -->|getH3ADWH
Fabric Data Pipeline| LH[(h3a_bronze_lh
Bronze Lakehouse)]
    LH -->|consumed by| SIL[Silver Lakehouse]
    TRG[⚡ Trigger:
0400_Daily_h3a
04:00 AM daily] -.->|schedules| H3A

    classDef src fill:#e3f2fd,stroke:#1976d2,stroke-width:1px
    classDef brz fill:#f4a261,stroke:#b85c00,stroke-width:1px,color:#000
    classDef sil fill:#c0c0c0,stroke:#555,stroke-width:1px
    classDef trg fill:#fff3cd,stroke:#b85c00,stroke-width:1px

    class H3A src
    class LH brz
    class SIL sil
    class TRG trg

List of tables

The h3a_bronze_lh currently exposes 13 tables. All sit in the dbo schema.

NameSchema
public_otbstockorderdbo
public_otbstoragedepotdbo
public_sdmbssoutboundstockorderdbo
public_sdmcustomizedstockorderdbo
public_sdminboundstockorderdbo
public_sdminboundstockordertypedbo
public_sdmlistelementdbo
public_sdmlogisticscanitemdbo
public_sdmmatdemandorderdbo
public_sdmmobilelocationdbo
public_sdmoutboundstockorderdbo
public_sdmpersondbo
public_sdmpurchaseorderdbo

Functional groups (orientation)

Prefix / patternAreaTypical content
public_otb*Operational tables (Storage / Stock Orders)Storage depots, stock orders
public_sdmbss*BSS — Business-SupportOutbound stock orders
public_sdminbound*Inbound stockInbound orders + types
public_sdmoutbound*Outbound stockOutbound orders
public_sdmcustomized*Customer-specificCustomized stock orders
public_sdmlogisticscanitemLogisticsScan items
public_sdmmatdemandorderMaterialMaterial demand orders
public_sdmmobilelocationMobileMobile location data
public_sdmpersonPeoplePerson master
public_sdmpurchaseorderPurchasePurchase orders
public_sdmlistelementReference dataLookup / list elements

Operational notes

  • Schedule: Die Pipeline 0400_Daily_h3a laeuft taeglich um 04:00 Uhr — als erste Pipeline am Morgen (vor BMD um 04:35 und Board um 04:30).
  • No transformations: Bronze-Standard.
  • Access: Restricted to the Fabric team. Power-BI-Reports konsumieren aus Silver/Gold.

Related pages

Information

Migration footer
Source: H3A Bronze Lakehouse (SharePoint)
Original author: Bukkerji Sreejith — Sreejith.Bukkerji@spl-tele.com
Original last-modified: 2025-10-15
Migration date: 2026-05-24
Migrated by: Dimitri Rupp via ClaudeAI
Notes: EN-Original preserved; 3-card-WHAT-HOW-WHO layout converted to summary table; Mermaid orchestration diagram added; 13 Tabellen extrahiert, funktionale Gruppen-Tabelle fuer schnelle Orientierung ergaenzt; Schedule-Note ergaenzt (H3A laeuft als erste Pipeline am Tag).

Verwandte Themen

Kuratiert — kann direkt im Editor ergänzt werden://

Failed to execute the [velocity] macro. Cause: [The execution of the [velocity] script macro is not allowed in [xwiki:IT-Wiki.Makros.Verwandte-Themen.WebHome]. Check the rights of its last author or the parameters if it's rendered from another script.]. Click on this message for details.

Status: Migriert — Team-Review ausstehend · Owner: (festlegen) · Letzter Review: 2026-06-11