Exploitation - Daily

============================================================

OVERVIEW

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

ISIS & AUTOMATOR INSTALLATION

https://drive.google.com/drive/folders/0B8RFN88sxfy5VGFXNUNmbVI1bGM

ISIS Tool Connection Configuration

Automator link to Production server:

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.

/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

PPE Unix and SQL script :

/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

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/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

EXPLOITATION Maintaining and Enhance

Page tree