DWH N&I Consolidation — Executive RAG Board Live

vault-sourced Week 40 · n-and-i-week-40-plan-2026-09-28.md Generated 2026-10-05 03:41
Critical / Blocked
2
active workstreams
At Risk / Waiting
3
active workstreams
On Track / Verified
2
active workstreams
Awareness / Waiting
34
26 secondary · 8 watchers
💡 Status is derived from plan text — correct it via the feedback drawer
Priority 1 — Lead Workstreams
1. CCP 254345 fix: QG PROD connector nodes to AWS RDS
Block: Priority 1 ID: p1-1
🔴 Critical / Blocked

Why first: the QG PROD side has no access to the AWS Oracle RDS targets, and that access is the precondition for the ARCOR target access through QueryGrid. It is also the one open item out of the connectivity verification pair. · Measured state 09.09.2026 03:41 (INC000100651608): all 8 flows time out, silent drop, no TCP handshake. Two sources (dea105yr 198.19.187.171, de6404yr 46.190.226.46) against four targets (BAT 46.108.219.87, ONL 46.108.219.119, CDRCOL 198.18

Work item t_2855c395 ready 2 comments Last 2026-09-29 09:45 · Hermes Check-in: 28.09-29.09: TS call II (CCP 254345 | ARCOR_PRD_Oracle_GQ_AWS) moved out into this week: Peter Hahn unlikely to join (Will Lok), Sanjay rescheduled and cannot attend; Peter to firm up his acceptance. …
Status derived from plan text (signals: 6 red / 3 amber / 3 green). Work items read from vikunja.
2. QueryGrid roles definition ARCOR and user creation
Block: Priority 1 ID: p1-2
🔴 Critical / Blocked

Why: the roles and the users are the precondition for putting the QG nodes into productive use for ARCOR. · State: role concept "one role per DB, assigned to sysadmin" went out 09.09 13:42 to Tadas, Guido, Gaurav and Sven. No reply after 7 working days.

Work item t_663744dd ready 4 comments Last 2026-09-30 06:02 · Hermes Check-in: 30.09: TDV-586 'QueryGrid users unclarity' assigned to Daniel + Tiziana Perla (29.09). Roles/user handover to the Oracle-to-TD user migration workstream (Bruno) unchanged; David's workbook went over 2…
Status derived from plan text (signals: 1 red / 2 amber / 0 green). Work items read from vikunja.
3. Bandwidth alignment with the network team and with Teradata, incl. UMDWH Kerpen
Block: Priority 1 ID: p1-3
🟡 At Risk / Waiting

Why: the bulk loads (ARCOR 7 TB, COPS BI 28 TB, CDWH 90 TB, UMDWH Kerpen open) depend on agreed rates and windows. Without them no transfer time and no target date is defensible. · Basis: Daniel's diagram of 21.09, filed at `programme/bandwidth-overview-2026-09-21.drawio`, with the extraction in `reference/bandwidth-overview-2026-09-21.md`. Figures: ARCOR 7 TB over 5 Gbps = 2.25 TB/h = ~3.1 h; COPS BI 28 TB at 3 Gbps

Work item t_835a00b1 ready 3 comments Last 2026-09-24 07:04 · Hermes Check-in: 24.09: ARCOR VPN bandwidth confirmed by Gabriel Pitis: use the full 5 Gbps on the DRCC to GCP path (not shared on GCP; shared on OCI with very low usage). No dedicated bandwidth limiter exists, effect…
Status derived from plan text (signals: 0 red / 9 amber / 3 green). Work items read from vikunja.
Also This Week
4. TD workshop follow-through: internal governance + HLD
Block: Also this week ID: also-4 Corrected: RAG green (from tracker marker)
🟢 On Track / Verified · corrected

Input: Klaus Meyer 18.09 15:02, retrospective deck `TD DWH Consolidation - TD Workshop Next Steps.pptx` (2 slides, DWH_Consolidation/inbox/email/attachments/). · Three VF-side next steps out of the workshop:

Work item t_ade2c334 ready 1 comment · matched by title Last 2026-09-23 06:11 · Hermes Check-in: 22.09: E2E HLD (Migration view, generic all legacy DWHs) out for review by Klaus Meyer 17:06, due Thu 24.09 eob (migration tasks/capabilities, technologies, processes/SLAs, testing, operations). Works…
Status derived from plan text (signals: 0 red / 2 amber / 0 green). RAG correction applied. Work items read from vikunja.
5. Airflow scheduler: preparation of the management decision
Block: Also this week ID: also-5 Corrected: RAG green (from tracker marker)
🟢 On Track / Verified · corrected

DATE Board recommended Airflow (Cloud Composer) on 15.09 as the MDWH scheduler: add-ons 200k EUR one-time, ~132k EUR recurring, against Control-M licences >1M EUR recurring. · The management decision is NOT taken. What runs now is the preparation of that decision.

Work item t_4e975695 ready 4 comments · matched by title Last 2026-09-22 06:27 · Hermes Check-in: Hermes Check-in 2026-09-22: Public-IP-Herkunft als Entscheidungsvorlage verschickt (Daniel 21.09 12:28 an Tadas/Michael Weichert/Klaus). Empfehlung Option 1: neue Public IP von VCI kaufen (wie bei Que…
Status derived from plan text (signals: 0 red / 1 amber / 0 green). RAG correction applied. Work items read from vikunja.
6. Berlin -> GCP migration pipeline: Octopus and Equinix 10G decision
Block: Also this week ID: also-6 Corrected: RAG amber (from tracker marker)
🟡 At Risk / Waiting · corrected

(carry over from week 38, topic 10; state of 18.09) · Christian Wilkat 12:34: DB transfer over proxy is NOT valid. The only Internet-to-GCP path is an additional local server with a public interface to the Internet and an inside interface to the DB (the Octopus solution that was skipped in the

Work item t_7a9f2cb9 ready 6 comments · matched by title Last 2026-09-22 06:27 · Hermes Check-in: Hermes Check-in 2026-09-22: Equinix-5->10G-Proposal ist seit 21.09 13:40 raus (Adressaten: Michael Weichert, Klaus Meyer, William Lok, Gaurav, Sven, Ana-Maria, Claus Heinze, Bruno, Stefanos); Detail +…
Status derived from plan text (signals: 0 red / 3 amber / 0 green). RAG correction applied. Work items read from vikunja.
7. BODS connectivity: partial implementation go and downstream confirmation
Block: Also this week ID: also-7 Corrected: RAG amber (from tracker marker)
🟡 At Risk / Waiting · corrected

CCP 256924 (BODS DEV) and 256923 (BODS PROD) are with Sanjay for implementation (asked by Stefanos 11.09). Will Lok checking the IDPS/PCS/TD change need. · Routing restriction: two IPs are not permitted (10.32.7.251/32, 10.32.243.141/32). Allowed KDG -> TD set is prefix-set KDG-CSP-TRANSIT-LM (10.32.0.0/22, 10.32.26.0/23, 172.19.129.0/24, 172.28.0.0/16, 10.101.64.0/28, .32/27, .64/26, .160/27,

Work item t_01f6b3de ready 6 comments · matched by title Last 2026-10-01 06:22 · Hermes Check-in: 30.09: BODS change done and testable. Will Lok 12:47 (Daily Alignment thread): "This can now be tested" - VFKDBusinessObjectsDataServices-1.0-BODS DEV-5.1 CM-ID 256924 (INC000100721036) and PROD-5.1 C…
Status derived from plan text (signals: 4 red / 6 amber / 1 green). RAG correction applied. Work items read from vikunja.
Secondary Topics (26)
#RAGTopicStatusNext step
1 AMBER MDWH ETL jumphost (der2ci00200do/00223do) CCP **256274** covers both flows; security exemption **130503** raised 01.09 (Moises to approve). Resolved on the VF side 17.09: Daniel posted "FW has been implemented", Ashish Agrawal confirmed login via the jumphost to 200do and 223do; Kalyan asked Agnivesh Pandey + David Gamble (TD) to verify on their side. Ashish's planned absence 23.-28.09 has ended Confirm the TD-side test result; formal closure/approval of exemption 130503 still open
2 RED CDWH BODS GIANT9931 CCP **256924** (DEV) + **256923** (PROD) **FW flows implemented 22.09** (INC000100721036 / INC000100721038); CCP **255157** pending IDPS (CSR0056801, William to update). **30.09: change Done and testable** (Will Lok 12:47: "This can now be tested"; VFKDBusinessObjectsDataServices-1.0-BODS DEV-5.1 CM-ID 256924 / PROD-5.1 CM-ID 256923, RITM1042862, CSR0057169, 5-day SLA Done); the two blocked IPs stay excluded Start the BODS/TD test, then the TDV-590 retest (Timothy Masila)
3 AMBER CCP 256525 COPS_QG_RAT AFW flows FW freeze UK/DE/IE ended 15.09, automation completes the AFW flows afterwards Watch for the completion announcement
4 AMBER KDG -> Teradata (RITM1021517) Checkpoint call with Will Lok was 10.09; result not recorded. **29.09: Will Lok asked for a catch-up (later this week / early next week): KDG on-prem DB + Berlin DC connectivity; open whether the source moves to AWS, and own GCP deployment vs support from Benjamin; decommissioning dates to coordinate with Christian Wilkat.** Thread `KDG-Database-On-Prem-VF-and-Berlin-DC-network-connectivity.md` Schedule the catch-up; record the outcome
5 GREEN MDWH/AVIDAT IP /28 (IPAM000000007454) Annual-fee-per-IP org model; cost confirmed by Michael, Stefanos asked Sanjay to implement 04.09. [Closed 24.09 on the Vikunja board.] No live action
6 AMBER laura3prd Python libs (Data Governance) Nilesh needs PyPI/proxy, yum/dnf repos, permissions; Daniel's response open. [Closed 24.09 on the Vikunja board.] No live action
7 GREEN AVIDAT answers review + MDWH pipeline status doc Stefanos-owned, document not written. AVIDAT step-by-step v2 reviewed (15 findings, volume basis 83 TB); analysis forwarded to Ana-Maria 16.09. [Closed 24.09 on the Vikunja board.] No live action
8 AMBER MDWH Action Tracker item 200 (Claus Heinze) 14.09 13:44: "Networking for Migration - MDWH: establish source to TGT networking pipeline as documented in the Excel for MDWH, then setup QueryGrid"; asks whether the wording is correct, anything unclear, and whether we are in exchange with TD Answer and confirm against the MDWH Excel
9 GREEN Testing coordination handover Tiziana Perla 14.09: Peter Krempels, Silvia and Ana-Maria take over DWHC testing coordination; access works (SharePoint 17.09). Jira DPT-5828 Handover items transferred
10 AMBER QG PROD flows: CCP IDs and delta CCP **257100** (QGPROD-1, track 1.1) and **257104** (QGPROD-2, track 2.1) released for implementation 16.09 (Timothy "kindly proceed", Sanjay: routing analysis). Tracker status set: COPSBI column L 18 rows 257100 / 9 DELPHIS rows 257104; MDWH column K 8 rows. **22.09 (Sanjay): design team input - most flows are NOT permitted; only the green ones are feasible and sent for routing fix; Daniel: implement what is possible, blockers discussed separately.** In scope and still open: **172.19.129.100:1522** missing in CCP 257100 (draft `DWH_Consolidation/inbox/draft-mail-qg-giant-delta-vis-100-2026-09-16.md`, not sent); **VIS 10.32.66.245:3306** raised as GIANT Track 3 flow 16.09 and rejected by network design the same day, correct IP still pending. Card `t_c11ff593` Wait for the routing fix result; send the delta question; resolve the VIS target IP
11 AMBER DWH Cons / GIANT Requests 1-3 **CCP IDs issued** (the 08.09 "not yet confirmed" note is superseded): **257100** (QGPROD-1, track 1.1) + **257104** (QGPROD-2, track 2.1), raised by Timothy Masila 15.09, released for implementation 16.09 ("kindly proceed"), re-listed 23.09 in the QG call as "to be delivered ASAP"; QG_ARCOR path: **256812** (uploaded 10.09, kept alive although QG-DCT is parked). Source both 46.108.121.16/28. COPSBI tracker column L and MDWH column K set to "requested CCP 257100/257104" on 16.09 Only open part: Moises Margotto's duplicate check against the pre-existing GIANT/exemption records (asked 08.09, no reply in the thread since). No new CCP to be raised
12 GREEN Oracle GoldenGate replication load on MMO3 Peter Hahn will look into it, can take a while (Teradata release upgrades over the weekend). [Closed 24.09 on the Vikunja board.] No live action
13 AMBER QG roles concept One role per DB, assigned to sysadmin; sent 09.09 13:42 to Tadas/Guido/Gaurav/Sven Roles concept still unanswered; user side moved 21.09-25.09 (Bruno has the workbook)
14 GREEN ARCOR AWS RDS connectivity (telnet verification) **CCP 254387 works**: INC000100651202, der2ci00007do/00008do/00012do -> BAT 46.108.219.87 + CDRCOL 198.18.99.173, TCP 33001, all 6 flows connected 09.09 08:35, ticket Resolved 21.09 08:45. **CCP 254345 fails**: INC000100651608, dea105yr 198.19.187.171 + de6404yr 46.190.226.46 -> BAT/ONL/CDRCOL/DEM, TCP 33001, all 8 flows time out 09.09 03:41, ticket still Assigned. 28.09: TS call II pushed to this week (see P1-1) Contrast test from the ETL PRD servers to ONL/DEM; then rule-level check of CCP 254345; re-route INC000100651608 to the FW rule owner
15 GREEN Old 2-working-day follow-ups MMO2 connectivity (10.08), ETL software stacks (11.08), COPSBI-3750 QueryGrid SR02648421 (17.08), BODS Connectivity (10.09), GIANT Requests 1-3 (11.09) All past the 2 WD threshold; decide whether to chase or close
16 RED INC000099972456 (DRCC ETL PRD -> COPSBI ODBs, raised 09.07) **Still open.** 13 of 14 flows verified working on 13.07 (der2ci00007do -> CRADB/DEPEMP/EFFONL/GVFDB/NPSDB/OMSDB/OPMFPRD). Blocked flow: CRADB 10.207.134.39:1599, incomplete ARP on Vlan2207, destination-side issue. 28.09: card field-edited on the board, stays open No agent follow-up scheduled; Daniel chases on demand
17 GREEN COPS-BI delivery plan (Volker Kuhn) 22.09: Daniel supplied the 2-part structure (infrastructure/connectivity + configuration) and the connectivity status: **36 of 38 connections requested** (CCP 257100: 18, CCP 257104: 9, CM 255230: 4, CM 255506: 4, CM 255358: 1; no request: 2 TSC). [Closed 24.09 on the Vikunja board.] No live action
18 GREEN DRCC circuit budget (EUR 163,384/yr) 22.09: Michael Weichert's approval forwarded to Sanjay Singh (12:06). [Closed 24.09 on the Vikunja board.] No live action
19 AMBER COPSBI SAP BODS mini-batch continuation TD architecture (David Gamble, 24.09): SAP BODS stays a central piece of the COPS BI landscape after the Oracle-to-Teradata lift; recommendation to continue the data-export (mini-batch) approach; BODS 4.3 maintenance ends 31.12.2026 (to CSM). [Closed 28.09 on the Vikunja board, silent; Tadas' official notification still expected and will surface as mail.] Watch for Tadas' notification only
20 AMBER ARCOR SIT history-data dry run (TD) Provisional slot **Wed 30.09 ~10:00 CET** stands (no counter-message; today). Daniel sent the network constraints (<5 Gbps mandatory, month-end note) 25.09 15:12. **29.09: TD ready to start the history migration (ARCOR Oracle DWHDB OCI -> Teradata EDW; Sumedh); VF holds MMO3 data migration pending the works-council topic, clarity expected ~22.10 (Gaurav); limited-table test plan requested from TD; Daniel named network-team SPOC.** Weekend-window proposal (Sumedh: Sat/Sun ~7-8h, no ADBA activities) still without detailed schedule + volumes. Card `t_aa8a18fd` Dry-run slot was Wed 30.09 ~10:00 CET; no outcome captured in mail or sessions as of 01.10, confirm with the TD side; detailed schedule + volumes; MMO3 gate (works council ~22.10)
21 AMBER AVIDAT Phase-1: .bak -> GCS -> Cloud SQL -> DCT Approach pinned in the 25.09 grilling; decision record + pipeline diagram filed (`reference/avidat-bak-cloudsql-approach-2026-09-25.md`). Questions sent to the AVIDAT round (Claus) 28.09 09:24: bucket feasibility, bandwidth behaviour vs DMZ routing, DB sizes (largest 40 TB, total 83 TB). Board: SFTP Landing Zone AVIDAT card (id 6) commented Answers -> pilot preparation (smallest DB first)
22 AMBER ARCOR UT on MMO2 (AbInitio) PASS with observations (98 target tables loaded, URF_ODS reruns OK; ALM QC + Jira TDV-605); VF OPS (Subhayan Sen, VOIS) consolidating clarification questions before feedback goes to TD; SAS and Perl UT parts still running UT feedback to TD; gates MMO3 SIT deployment planning
23 AMBER NICE Transformation / 11do migration (OCI) New 29.09: Walid Mortada's call summary: CENT/NICE transformation; the 11do server migration from OCI under review (target options: GCP in the invite, Azure for the Ab Initio part). Open points: share the overall approach with Guido Winzig; Ab Initio licensing/contract reuse OCI -> Azure; future licence ownership (Guido). Daniel invited and attended Await feedback on the open points; no action for us yet
24 AMBER Parallel-run document + CI/CD alignment (all DWH) 29.09 review MOM (Shamal Zurange): ARCOR + MDWH CI/CD to align with the GitHub-based approach; COPSBI strategy still under discussion; all 3 dev teams to validate the parallel-run document (dev comments awaited) Watch dev-team validation + the COPSBI CI/CD decision
25 AMBER SFTP file-exchange requirements (MDWH -> Teradata) 28.09: SFTP requirements review (organizer Paras M Shah); MOM circulated 28.09 15:31 (`projects/vodafone/inbox/email/SFTP.md` + docx). Outcome: requirement confirmed (MDWH inbound/outbound file exchanges incl. external parties continue post-migration); NO architecture/security/governance decision; next: check existing enterprise file-transfer capabilities + governance review; follow-up meeting to be arranged. Board: card `t_37b1c3b8` commented Review the minutes (Paras' open ask); follow-up meeting
26 AMBER DRCC non-prod connectivity review (OCI non-prod 158.179.227.64/28 + hosts .67/.68/.69/.70) 30.09: review built from the FW comms-matrix exports, status 'To implement' only - source side 435 flows / destination side 372 / merged 736 TCP flows; workstream split .67 ARCOR 292, .70 ARCOR-SAS 173, .68 MDWH 3, .69 + /28 shared 268. Share artifact `reference/drcc-VF-DE-DWH-PRE_merged_2026-09-30.xlsx` (Workstream / Source / Destination / TCP port); internal visual aids `reference/drcc-nonprod-connectivity-overview-2026-09-30.drawio` (+ .pdf), FlowSketch projects `drcc-nonprod-connectivity`, `drcc-nonprod-merged-flows`. 01.10: the package is a script run now - `assets/build-review-package.py` (10 raw CommsMatrix exports -> source/destination/merged xlsx; supersede loop, port-1025 flag, workstream column); rebuild against the delivered stand: source 440 / destination 372 / merged 741 (ARCOR 291, shared 274, ARCOR-SAS 173, MDWH 3), 12 port-1025 flows flagged in the Info sheet. New rule: keep the 'To implement' row and flag it instead of deleting on request. Card `vikunja-53` Decide whether the official `reference/` xlsx are regenerated from the builder (rebuild preview under /root/.hermes/cache/scratch/review-test/); decide the 12 port-1025 flows; split the shared rows (now 274) if a single workstream is needed; then hand the merged list to the requester
Awareness

⏳ Waiting on others (8)

  • Teradata connectivity (new thread 30.09): IOD **GIANT4105** for VODADE01/MMO3 supplied by Guido Winzig (for Marian Strüby); Daniel's standing guidance - GIANT alone is not sufficient, the TD catalog request has to be raised first (thread `Connectivity-zu-TERADATRA.md`).
  • QG PROD GIANT26275: blocked on KDG network design approval.
  • QG connector node setup at VCI: ETA pending.
  • AVIDAT CISCO licence account re-allocation: answer from Claus outstanding.
  • ETA INC000100212278/212734: waiting on Renata's return.
  • CCP130225 security exemption review: assigned, detail request from Security.
  • Old-school physical transfer (Leipzig -> Ratingen, ~80 TB): Michael Weichert asked Jörg and Tansu for providers of a secure physical drive service; Daniel follows up once contacts arrive (thread `DWH-Consolidation-Old-school-data-moving.md`).
  • Planner tasks opened 29.09 in CCoE - DWH Conso: KDG routing: explore possibilities for non-routable IPs; E2E Architecture/Flow DCT/DVT -> Kerpen; get Michael's confirmation to proceed.

✅ Closed / removed this week (4)

  • **COPSBI SAP BODS mini-batch continuation (topic 19):** card `vikunja-52` set to done on the Vikunja board 28.09 (silent). TD architecture note stays as reference; Tadas' official notification still expected.
  • **Team handover Reply (Stefanos/Amin) to Ana-Maria + Daniel (card `t_f8d47de2`):** confirmed complete 30.09 (Stefanos 12:13: "we have now successfully handed over all tasks to Ana and Daniel"). The four taken-over areas (BAU connectivity tracker + weekly call, SBR assessment + bi-weekly call, QueryGrid infrastructure and implementation, daily migration pipeline) sit with Ana and Daniel now; card set to done on the Vikunja board 01.10.
  • **Board closes of 24.09 realised in this rebuild:** topics 5 (MDWH/AVIDAT IP), 6 (laura3prd libs), 7 (AVIDAT answers review), 12 (GoldenGate MMO3), 17 (COPS-BI delivery plan), 18 (DRCC circuit budget) are closed on the board; rows kept with a closed marker for traceability.
  • **Carried closures (earlier):** GIANT10501 Track 3.1 (removed 21.09, not Daniel's; no reply from Guido/Edwin and the 15.09 deadline passed unused); QG-DCT node parked 21.09 with CCP 256812 deliberately kept alive; team handover Stefanos/Amin -> Ana-Maria (colleague-owned, reference only).
Timeline — workstreams, cards and due dates
critical / blocked at risk / waiting on track / done running card due date (written in plan)
Loading…
Read-only. The kanban board and the weekly tracker stay the source of truth — every bar is derived from them (JSON). The first bar of each group is the P1 / also-this-week workstream, the ↳ t_… bar below it is its linked kanban card, black bars mark dates written in the plan text. Nothing is estimated — hovering a bar shows where its dates come from.