============================================================
============================================================
BO Exploitation is the data loading, script environment management for application PPE, PPS, SAFIR, ICARE, RAP.
AUTOMATOR : Schedule of jobs (Maintain by Adagio team is-qpsupport@solvay.com, team WQM at IBM)
ISIS : maintain & transfer the SQL scripts, run the exploitation job by manual, Enhance the Unix Env
All the technical doc in : https://drive.google.com/drive/folders/0BwtAGBKWM-z-djFZLXBXd3NKcW8
https://drive.google.com/drive/folders/0B8RFN88sxfy5VGFXNUNmbVI1bGM
ISIS Tool Connection Configuration
Automator link to Production server:
Automator link to Dev server:
/home/isis/ICles/FTP/V1/tab
Netrc : Maintain the Application name, Source server IP, FTP user ID, password.
Livraison : Maintain the file name and folder on Source Server.
/home/isis/ICles/FTP/V1/bin
PC_TRANS_FTP_W : The unix script for FTP file transfer
For more detail read the topic "Add a new sftp transfer" in doc https://drive.google.com/open?id=17rDIbkGKfYEhR-65CuzJENd3Fa2h8YQe_ottuqPNJVo
/home/isis/ICles/PR_ECO/V1/CHAINE_EXPLOIT/bin
PC_CAPSULE : Setup the environment and call a Unix script
PC_CHECK : Check the Oracle is active or not.
It was run in the begin of PPE exploitation in Automator :
a shortcut 'script' is maintained in /exploit/PR_ECO/programs,
So /exploit/PR_ECO/programs/script = /home/isis/ICles/PR_ECO/V1/CHAINE_EXPLOIT/bin
PC_REC_FLUX : Transfer & rename the file in '/exploit/arrivee' to '/exploit/PR_ECO/DW2/data/'
PC_PRE_TRAIT : Run PPE Pre-treatment.
PC_INTEG : Run PPE integ treatment.
........
/home/isis/ICles/PR_ECO/V1
Save the plsql & ctl script
/exploit/arrive
Data File will first save in this folder
/exploit/PR_ECO/DW2/archive
Folder to Archive data file, will save one month data file only.
/home/isis/ICles/VERIF/V1/log
Exploitation log.
For more detail please read the doc : https://drive.google.com/drive/folders/1cMglFRw0Lv44BBm5xhXiMdcVnf03AxKe
Configuration : Config the Automator env
Modeling : Create, Modify the Graph
Processing Tracher : Monitor the Automator Job
All the BO Graph are under category PREMIER_PILOTAGE
Application :
TR_TRANS_FTP_PR_ECO : Transfer data file for other server to BO server
VERIFICATION : Check Oracle active or not
TRANSFERT : Transfer & rename the file in '/exploit/arrivee' to '/exploit/PR_ECO/DW2/data/'
PRE-TRAITEMENT : Run the Pre-treatment script
INTEGRATION : Run the Integration-treatment script
POST-TRAINTEMENT : Run Post treatment scirpt
GBRTRAITEMENT : Trigger by PPS exploitation, transfer the GBR data from PPS to PPE

PPE exploitation, Graph PR_ECO & PR_ECO_ASIA are trigger by RCS_FI_PREMIER_PILOTAGE in category EXPLOITATION_RCS
W158ABXXXX Run in every day except last day of month, It will generate 2 month data(current month and previous)
W158BBXXXX Run in last day of month, it will generate YtD data.
W158AB_RES Run in first 3 day of the month, it work for Asia month end closing.
This job will provide the data for Graph PR_ECO_ASIA

Graph PR_ECO_MBI, load the integrate margin data, which generate by BW(WBP) PC
Graph PR_ECO_QL, load the QL data, at 13:00 FR time
Application :
TRANSFERT_TAUX_DEVISE, transfer the exchange rate data file from BFC system
TRANSFERT_BW_VC_ESTIMATION, transfer the value stream data from BW.
PPS exploitation, Graph PR_PIL are trigger by RCS_OC_PREMIER_PILOTAGE in category EXPLOITATION_RCS
Login in Solution Manager, Create the SLV Request, Set Project ZGEN
Set Document type to SLV Admin Change
And write down the detail what you request.
At last send a additional e_mail to Adagio team( is-qpsupport@solvay.com), ask for follow up.
The I-SIS Console
Web console :
http://wdcbiaq01:9000/WebConsole
Read the doc https://drive.google.com/open?id=17rDIbkGKfYEhR-65CuzJENd3Fa2h8YQe_ottuqPNJVo
When the I-SIS Agent is active. the Unix script environment was enhance,
For example in Unix script we can code "Select from Table_Flux" to get the data in table format in file /home/isis/ICles/PR_ECO/V1/COMMUN/tab/Table_Flux
Read the Doc "Application_Evolution_Management" https://drive.google.com/open?id=0B8RFN88sxfy5YmJCT1A2Uk56dk0
Read the topic "Usual maintenance actions" in Doc https://drive.google.com/open?id=17rDIbkGKfYEhR-65CuzJENd3Fa2h8YQe_ottuqPNJVo
Read the Doc "Exploitation_Management" https://drive.google.com/open?id=0B8RFN88sxfy5X09yVzVVcHlCdDg