Data Flow
- BW(Workforce + Payroll) → Xtract → Talend → GCP → Qlik
- Pulse(gsheet) → Talend → GCP → Qlik
Data Source
| Query | Description |
|---|---|
| DO_BW_QRY_CPHRPAHDM_0005 | People at Solvay |
| DO_BW_QRY_CPHRPY002_0001 | Labor Cost - People Insight |
| Engagement Index 2022/2024 - Solvay Pulse | Pulse Survey Result |
Talend Loading
| Job | Frequency | Start Time | Duration |
|---|---|---|---|
| BW | Monthly | ~20:30pm CET | ~3.5h |
| Pulse | On Demand | ~4:00am CET | ~2min |
Data Quality Controls
Data comes from SAP system. To compare data between BW and sources systems, check propagation layers.
Operational Documentation
Procedures
<Describe the recurring procedures needed to operate the application (eg. start/pause/terminate/restart the app processes, data preparation, data ingestion, ETL, data visualization, data export, other manual activities)>
Scheduling
<Describe the scheduling in place for the application (eg. existing jobs, trigger time/event based, dependencies)>
Monitoring
<Describe the monitoring checks to confirm the application is performing well (eg. check the overall status, check performance metrics like runtime/data volume/memory/disk/CPU, maintain and react to alerts/notifications)>
Error Handling
<Describe how to handle errors (eg. error codes, description and respective resolution, alert users)>
Known Bugs
<List the existing bugs, its criticality, workarounds and resolution plan.>
Roadmap
<List past & future evolutions for the application (including links to MED/FSD/TSD)>