=======================================================================
=======================================================================
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 :
The loader loads the SOLD_TO_CUSTOMER on 11 digits in the TMP_GL_FORECAST_APO because of an hidden character at the end of the Dynasys file.
With the SQL from TMP to REC and PROD, we get the substring of 10 first digits of the Sold-To code. So in REC and PROD, the customer code is well back on 10 digits.
Archived
==> 