Skip to Content

Wiki source code of H3A Bronze Lakehouse

Version 2.1 by Dimitri Rupp on 2026/06/11 09:16
Show last authors
1 {{box cssClass="floatinginfobox" title="**On this page**"}}
2 {{toc/}}
3 {{/box}}
4
5 = H3A Bronze Lakehouse =
6
7 {{info}}
8 **Source system:** H3A — third-party operational system
9 **Stage:** Bronze (raw landing zone)
10 **Owner:** Fabric team (restricted access)
11 {{/info}}
12
13 == Overview ==
14
15 |=(% style="width:80px" %)📋 **What**|Tables from the **H3A Data Warehouse**. Acts as the **landing zone** for all H3A-related data. No transformations are carried out here.
16 |=(% style="width:80px" %)🔄 **How**|Data is copied via **Fabric Data Pipelines**.
17 |=(% style="width:80px" %)🔐 **Who**|Access is **restricted to the Fabric team**.
18
19 == Orchestration ==
20
21 |=Property|=Value
22 |🛠️ Tool|Fabric Data Pipeline
23 |🆔 Pipeline name|(% style="font-family:monospace" %)getH3ADWH(%%)
24 |ℹ️ Function|Copy data from H3A DWH to (% style="font-family:monospace" %)h3a_bronze_lh(%%)
25 |⚡ Trigger|(% style="font-family:monospace" %)0400_Daily_h3a(%%) pipeline
26 |🕞 Time|04:00 AM daily
27
28 {{mermaid}}
29 flowchart LR
30 H3A[(H3A DWH<br/>Source database)] -->|getH3ADWH<br/>Fabric Data Pipeline| LH[(h3a_bronze_lh<br/>Bronze Lakehouse)]
31 LH -->|consumed by| SIL[Silver Lakehouse]
32 TRG[⚡ Trigger:<br/>0400_Daily_h3a<br/>04:00 AM daily] -.->|schedules| H3A
33
34 classDef src fill:#e3f2fd,stroke:#1976d2,stroke-width:1px
35 classDef brz fill:#f4a261,stroke:#b85c00,stroke-width:1px,color:#000
36 classDef sil fill:#c0c0c0,stroke:#555,stroke-width:1px
37 classDef trg fill:#fff3cd,stroke:#b85c00,stroke-width:1px
38
39 class H3A src
40 class LH brz
41 class SIL sil
42 class TRG trg
43 {{/mermaid}}
44
45 == List of tables ==
46
47 The (% style="font-family:monospace" %)h3a_bronze_lh(%%) currently exposes 13 tables. All sit in the **(% style="font-family:monospace" %)dbo(%%)** schema.
48
49 |=Name|=Schema
50 |(% style="font-family:monospace" %)public_otbstockorder(%%)|dbo
51 |(% style="font-family:monospace" %)public_otbstoragedepot(%%)|dbo
52 |(% style="font-family:monospace" %)public_sdmbssoutboundstockorder(%%)|dbo
53 |(% style="font-family:monospace" %)public_sdmcustomizedstockorder(%%)|dbo
54 |(% style="font-family:monospace" %)public_sdminboundstockorder(%%)|dbo
55 |(% style="font-family:monospace" %)public_sdminboundstockordertype(%%)|dbo
56 |(% style="font-family:monospace" %)public_sdmlistelement(%%)|dbo
57 |(% style="font-family:monospace" %)public_sdmlogisticscanitem(%%)|dbo
58 |(% style="font-family:monospace" %)public_sdmmatdemandorder(%%)|dbo
59 |(% style="font-family:monospace" %)public_sdmmobilelocation(%%)|dbo
60 |(% style="font-family:monospace" %)public_sdmoutboundstockorder(%%)|dbo
61 |(% style="font-family:monospace" %)public_sdmperson(%%)|dbo
62 |(% style="font-family:monospace" %)public_sdmpurchaseorder(%%)|dbo
63
64 == Functional groups (orientation) ==
65
66 |=Prefix / pattern|=Area|=Typical content
67 |(% style="font-family:monospace" %)public_otb*(%%)|Operational tables (Storage / Stock Orders)|Storage depots, stock orders
68 |(% style="font-family:monospace" %)public_sdmbss*(%%)|BSS — Business-Support|Outbound stock orders
69 |(% style="font-family:monospace" %)public_sdminbound*(%%)|Inbound stock|Inbound orders + types
70 |(% style="font-family:monospace" %)public_sdmoutbound*(%%)|Outbound stock|Outbound orders
71 |(% style="font-family:monospace" %)public_sdmcustomized*(%%)|Customer-specific|Customized stock orders
72 |(% style="font-family:monospace" %)public_sdmlogisticscanitem(%%)|Logistics|Scan items
73 |(% style="font-family:monospace" %)public_sdmmatdemandorder(%%)|Material|Material demand orders
74 |(% style="font-family:monospace" %)public_sdmmobilelocation(%%)|Mobile|Mobile location data
75 |(% style="font-family:monospace" %)public_sdmperson(%%)|People|Person master
76 |(% style="font-family:monospace" %)public_sdmpurchaseorder(%%)|Purchase|Purchase orders
77 |(% style="font-family:monospace" %)public_sdmlistelement(%%)|Reference data|Lookup / list elements
78
79 == Operational notes ==
80
81 * **Schedule:** Die Pipeline (% style="font-family:monospace" %)0400_Daily_h3a(%%) laeuft taeglich um 04:00 Uhr — als **erste** Pipeline am Morgen (vor BMD um 04:35 und Board um 04:30).
82 * **No transformations:** Bronze-Standard.
83 * **Access:** Restricted to the Fabric team. Power-BI-Reports konsumieren aus Silver/Gold.
84
85 == Related pages ==
86
87 * [[Bronze Lakehouse (Hub)>>doc:IT-Wiki.01-Data.Ingestion.Bronze-Lakehouse.WebHome]]
88 * [[Fabric Lakehouse Hub>>doc:IT-Wiki.01-Data.Processing.Lakehouse.WebHome]]
89 * [[Microsoft Fabric Datenarchitektur im SPL>>doc:IT-Wiki.01-Data.Microsoft-Fabric-Datenarchitektur-im-SPL.WebHome]]
90 * [[Silver Lakehouse>>doc:IT-Wiki.01-Data.Processing.Lakehouse.Fabric-Silver-Lakehouse.WebHome]]
91 * [[Gold Lakehouse>>doc:IT-Wiki.01-Data.Processing.Lakehouse.Fabric-Gold-Lakehouse.WebHome]]
92
93 ----
94
95 {{info}}
96 **Migration footer**
97 **Source:** [[H3A Bronze Lakehouse (SharePoint)>>url:https://spltele.sharepoint.com/sites/WikiPowerBI/SitePages/H3A-Bronze-Lakehouse.aspx]]
98 **Original author:** Bukkerji Sreejith — Sreejith.Bukkerji@spl-tele.com
99 **Original last-modified:** 2025-10-15
100 **Migration date:** 2026-05-24
101 **Migrated by:** Dimitri Rupp via ClaudeAI
102 **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).
103 {{/info}}
104
105
106 ----
107
108 == Verwandte Themen ==
109
110 //Kuratiert — kann direkt im Editor ergänzt werden://
111
112 * [[BMD Bronze Lakehouse>>doc:IT-Wiki.01-Data.Ingestion.Bronze-Lakehouse.BMD-Bronze-Lakehouse.WebHome]]
113 * [[Board Bronze Lakehouse>>doc:IT-Wiki.01-Data.Ingestion.Bronze-Lakehouse.Board-Bronze-Lakehouse.WebHome]]
114 * [[Rimo Lakehouse>>doc:IT-Wiki.01-Data.Ingestion.Bronze-Lakehouse.Rimo-Lakehouse.WebHome]]
115
116 {{include reference="IT-Wiki.Makros.Verwandte-Themen.WebHome"/}}
117
118 ----
119 **Status:** Migriert — Team-Review ausstehend · **Owner:** //(festlegen)// · **Letzter Review:** 2026-06-11