APP168 - ADMIN
Code: APP168
Titre: ADMIN
Description: Organization (to be validated by S&OP team):
S&OP team will lead the migration from ODI to GCP.
SQL translator will be used to convert ODI transformations into DBT/BigQuery.
Technical POC has been successfully validated.
S&OP Team will also deliver the CADP for Board.
Analytical use cases: Leverage DBT and BigQuery to transform data from GCP to BOARD
Decommission EDW and ODI (ETL) feeding BOARD.
Feed BOARD from GCP environment (SADP tables mirroring EDW structure from the Data Platform on which S&OP business transformations will be applied)
Avoid BOARD changes (legacy, highly interconnected, big-bang cutover).
Direct translation of ODI SQL logic to DBT (lift-and-shift).
No detailed business rules available for ODI transformations → cannot fully redesign logic now.
Preserves existing transformation behavior, avoiding re-specification.
Minimizes development effort and project duration.
Reduces risk of business disruption by keeping outputs identical.
Enables faster migration while deferring optimization work to a later phase.
Migrate S&OP business parameters table to BigQuery.
GCP environment (physical or logical separation) chosen per data team’s recommendation for storage, transformations and orchestration
DBT + Bigquery in GCP: pyshical vs logical separation with Data Platform
Catégorie: Gestion
Entité responsable: UORG19 - SAD (Interne)
Statut cycle de vie: A décommissionner
Date cycle de vie: 2025-10-10 00:00:00
Cycles de vie
| Date | Statut | | 2025-10-10 00:00:00 | A décommissionner |
Indicateurs
| Indicateur | Valeur | Titre | | IND12 - Criticité | None | Non renseigné |
| IND25 - Impact Passerelle | 3 | None |
| IND27 - test | None | Non renseigné |
| IND36 - tets ind | None | Non renseigné |
| IND35 - xxxxxxx | None | Non renseigné |
Caractéristiques
| Caractéristique | Nature | Valeur | | CARAC32 - aaaa | Propriété | http://www.google.com |
| CARAC36 - app bool | Propriété | False |
| CARAC4 - Disponibilite | Propriété | None |
| CARAC13 - Donnees personnelles | Propriété | None |
| CARAC21 - dsqdqdq | Propriété | None |
| CARAC3 - Hebergement | Propriété | qscscwc |
| CARAC6 - Mode developpement | Propriété | None |
| CARAC31 - sfsff | Propriété | None |
| CARAC5 - Technologie | Propriété | None |
| CARAC33 - test carac violet | Propriété | None |
| CARAC1 - OS | Tag | None |
| CARAC18 - tag 1 app | Tag | None |
| CARAC28 - tag 10 | Tag | None |
| CARAC29 - tag 11 | Tag | None |
| CARAC30 - tag 12 | Tag | None |
| CARAC23 - test tag 3 | Tag | None |
| CARAC24 - test tag 4 | Tag | None |
| CARAC25 - test x1 | Tag | c |
Entités associées
| Code | Titre | Usage | Type | | UORG18 | DCAS | TREL20 - Editeur | Interne |
| UORG34 | UO externe | TREL21 - TMA | Externe |
Processus associés
Couverture fonctionnelle
| Capacité | Composant logiciel | Service |
Composants logiciels
| Composant logiciel | | CLOG74 - Campagne marketing (ADMIN) |
| CLOG56 - Déclenchement de prestations BtC (ADMIN) |
| CLOG48 - Ges cnt prest téléassis (ADMIN) |
| CLOG78 - Gestion des paiements (ADMIN) |
| CLOG58 - Questionnaire en ligne (ADMIN) |
| CLOG44 - SelfCare (ADMIN) |
| CLOG105 - test cmp david (ADMIN) |
| CLOG52 - Vision 360 téléassist (ADMIN) |
Projets associés
