============================================================
| Table of Contents |
|---|
============================================================
OVERVIEW
| Table of Contents |
|---|
...
BO Exploitation is the data loading, script environment management for application PPE, PPS, SAFIR, ICARE, RAP.
Automator AUTOMATOR : Schedule of BO exportation.
jobs (Maintain by Adagio team is-qpsupport@solvay.com, team WQM at IBM)
ISIS Tool : The tools to maintain & transfer the Oracle scriptSQL 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
ISIS
...
&
...
AUTOMATOR INSTALLATION
https://drive.google.com/drive/folders/0B8RFN88sxfy5VGFXNUNmbVI1bGM
...
Automator link to Dev server: 
...
UNIX FOLDER
FTP Script & Setting:
/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.
...
For more detail read the topic "Add a new sftp transfer" in doc https://drive.google.com/open?id=17rDIbkGKfYEhR-65CuzJENd3Fa2h8YQe_ottuqPNJVo/file/d/14lu1nYyyQrc1-PMcy_vreOJNpgLQaKj7BlxSFnw2k0g/view
PPE Unix and SQL script :
/home/isis/ICles/PR_ECO/V1/CHAINE_EXPLOIT/bin
...
For more detail please read the doc : https://drive.google.com/drive/folders/0B8RFN88sxfy5QVpTUVVIYTJsc1k
/1cMglFRw0Lv44BBm5xhXiMdcVnf03AxKe
AUTOMATOR
In interface of Automator
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
==> PPE GRAPH - PR_ECO*
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
==> PPS GRAPH - PR_PIL
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
==> Request to CHANGE the GRAPH
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.
ISIS CONSOLE, Agent
Overview
The I-SIS Console
Web console :
http://wdcbiaq01:9000/WebConsole
I-SIS Agent and Portal management
Read the doc https://drive.google.com/file/d/14lu1nYyyQrc1-PMcy_vreOJNpgLQaKj7BlxSFnw2k0g/view
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
EXPLOITATION Maintaining and Enhance
SQL & CTL Change
Read the Doc "Application_Evolution_Management" https://drive.google.com/file/d/1DMhcHG3DtyfRMkRG6C2cW9TGxvjsEdDA/view
Unix Environment Change
Read the topic "Usual maintenance actions" in Doc https://drive.google.com/file/d/14lu1nYyyQrc1-PMcy_vreOJNpgLQaKj7BlxSFnw2k0g/view
Exploitation Monitor
Read the Doc "Exploitation_Management" https://drive.google.com/file/d/1R_WhoNZtJDkX8ZJ6p4iCa9kXHcL_wTWW/view