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 |
Prerequisites:
BW
- Remote Access should be enabled for the interface query
- Access to the two interface queries should be assigned to the role: ZH_PA_INGESTION and technical user: RFC_TAL_WBP
Pulse
- It's integrated into one gsheet(tab:Pulse) as above and should be shared with sa-talend@prj-data-dm-hr-dev.iam.gserviceaccount.com
- Short text for [Management Level]
- Text for [Cadre, Non Cadre]
Restriction:
- User Name = SACBW_HRD
- HR Roles = WORLDWIDE
- PO2 Flag = #; E;TSAE
Please see here for details.
Xtract Job
| Job | Description |
|---|---|
| TALEND_PROD_DO_CPHRPAHDM_0005 | People at Solvay |
| TALEND_PROD_DO_CPHRPY002_0001 | Labor Cost - People Insight |
Please see here for details.
Talend Job
| Job | Frequency | Start Time | Duration |
|---|---|---|---|
| BW | Monthly | ~20:30pm CET | ~3.5h |
| Pulse | On Demand | ~4:00am CET | ~2min |
GCP Table/View/Procedure
| Table | Description |
|---|---|
| STG.STG_BWH_0000_0000_F001_F_D_qry_cphrpahdm_0005 | Workforce Staging Table |
| STG.STG_BWH_0000_0000_F001_F_D_qry_cphrpy002_0001 | Payroll Staging Table |
| STG.STG_FIL_0000_0000_F003_F_A_pulse_to_hr_peopleinsight | Pulse Staging Table |
| ODS.ODS_BWH_0000_F001_F_D_qry_cphrpahdm_0005 | Workforce ODS Table |
| ODS.ODS_BWH_0000_F001_F_D_qry_cphrpy002_0001 | Payroll ODS Table |
| ODS.ODS_FIL_0000_0000_F003_F_A_pulse_to_hr_peopleinsight | Pulse ODS Table |
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)>