3.1 - Source Descriptions
3.1.1 BW servers
WBP (BW production server):
Several BW queries are extracted on the server ACEW1PQLIKAPP02
| XTRACT JOB | BW QUERY | COMMENT |
|---|---|---|
| TALEND_QV_BW_QRY_MVDYN11_0005 | QV_BW_QRY_MVDYN11_0005 | we retrieve the last 2 years of data UoM = VKG |
| TALEND_QV_BW_QRY_MVSDSO57_0003 | QV_BW_QRY_MVSDSO57_0003 | we retrieve data of current and previous year Intra GBU = '#' |
| TALEND_QV_BW_QRY_MVSDSO57_0001 | QV_BW_QRY_MVSDSO57_0001 | we retrieve data of current and previous year Intra GBU = '#' |
| TALEND_QV_BW_QRY_CPSDCH01_0001 | QV_BW_QRY_CPSDCH01_0001 | we retrieve data of current and previous year |
| TALEND_QVSCE_BW_QRY_MVSDTR01_0010 | QVSCE_BW_QRY_MVSDTR01_0010 | we retrieve data of current and previous year |
| TALEND_QVSCE_BW_QRY_MVSDTR01_0012 | QVSCE_BW_QRY_MVSDTR01_0012 | we retrieve data of current and previous year |
| TALEND_QVSCE_BW_QRY_MVSDTR01_0013 | QVSCE_BW_QRY_MVSDTR01_0013 | we retrieve data of current and previous year |
| TALEND_PROD_QVSCE_BW_QRY_MVSDSO51_0001 | QVSCE_BW_QRY_MVSDSO51_0001 | we retrieve data of current and previous year |
| TALEND_QV_BW_QRY_CPSDSO51_0001 | QV_BW_QRY_CPSDSO51_0001 | we retrieve data of current and previous year. UoM = VKG |
| TALEND_PROD_BW_QRY_MVSDSO45_SD0001 | BW_QRY_MVSDSO45_SD0001 | we retrieve data of current and previous year GBU = 'TS' and Intra GBU = '#' |
| TALEND_QV_BW_QRY_MVSDTR01_0011 | QV_BW_QRY_MVSDTR01_0011 | we retrieve data of current and previous year |
Files are stored in the folder G:\XtractUniversal Talend Extraction for Talend remote engine to read them.
3.1.2 Salesforce
We retrieve information from Salesforce for the calculation of the Perfect Order Rate.
The connection is done using the sbs-is-appli-qlikview.support@solvay.com.crm service account.
The target system is : https://solvay-crm.my.salesforce.com/services/Soap/u/39.0
The following objects are extracted:
| Salesforce object | Filter |
|---|---|
| Case | IsDeleted=false |
| RecordType | IsActive=true |
| Account | IsDeleted=false |
| User | |
| SLV_Involved_GBU__c | SLV7_GCS_GBU__c!=null and IsDeleted=FALSE and RecordTypeId = '01224000000TaO2AAK' |
3.1.3 Google Sheets
GSHEETS:
l
Responsible & contact points:
- Application Owner - Mathieu Pourqué
- Delivery Manager - Donia Rachidi
- Project Manager - Vitaly
- Data Architect - Joao Fonseca
- Tableau Dev - Maxime Marboeuf
- Data Engineer - Virgil Lissassi ; replaced by Matteo Menghetti