=======================================================================
...
| Table of Contents |
|---|
=======================================================================
MFT
One MFT task that checks Dynasys folder every 10 min from 6.30 pm CET to midnight.
If the file SAFIRZD30.csv exists, then :
1/ MFT catch this file and sends it to BI4
2/ MFT moves this file in the Dynasys archive folder (mandatory action, otherwise MFT will send the same file every 10 min) and renames it by adding a timestamp
| Type | Name | DNS | IP address |
| DEV | WDCWMAD02 | WDCWMAD02.eua.solvay.com | 150.251.113.105 |
| PRE-PROD | WDCWMAV11 | WDCWMAV11.eua.solvay.com | 150.251.113.119 |
| PRE-PROD | WDCWMAV12 | WDCWMAV12.eua.solvay.com | 150.251.113.120 |
| PROD | WDCWMAP11 | WDCWMAP11.eua.solvay.com | 150.251.113.131 |
| PROD | WDCWMAP12 | WDCWMAP12.eua.solvay.com | 150.251.113.132 |
One archive folder exists on Dynasys servers :
| Environment | Server | Directory |
| DEV | WDCDYAD21 | \\wdcdyad21.eua.solvay.com\DynaSys\DEV\ITF\Files\Out\Archives |
| TEST | WDCDYAD21 | \\wdcdyad21.eua.solvay.com\DynaSys\TEST\ITF\Files\Out\Archives |
| PROD | WDCDYAP21 | \\wdcdyap21.eua.solvay.com\DynaSys\ITF\Files\Out\Archives |
FTP
Dynasys file loading moved from FTP to MFT
Contacts on Dynasys side
Developper :
Laura Labbadi
Exploitation :
LAURE PICHOT-PLASSE <laure.pichot-plasse@solvay.com>,
"Min(mark) Yu" <min.yu@solvay.com>,
Lei Shen <lei.shen@solvay.com>,
Pablo Prieri <pablo.prieri@solvay.com>,
Olivier Descamps <olivier.descamps@solvay.com>,
Etienne Ribet-ext <etienne.ribet-ext@solvay.com>,
Maggie MA <maggie.ma@solvay.com>
File received
...
Frequency of export of file SAFIRZD30.CSV from DynaSys : generate the file two times per day:
- 23h00 CET
- 18h15 CET (so that Asian could see the data D+1 in their morning)
Contain Forecasts from the current month.
Loader and SQL
remark Remark :
The loader oads loads the SOLD_TO_CUSTOMER on 11 digit digits in the TMP_GL_FORECAST_APO because of an hidden character at the end of theDynasys the Dynasys file.
With the update SQL from TMP to REC and PROD, we get the substring of 10 first digits . And of the Sold-To code. So in REC and PEODPROD, the customer code is well back on 10 digits.
...
Archived
==> 