Exploitation - Daily

Overview :

BO Exploitation is the data loading, script environment management for application PPE, PPS, SAFIR, ICARE, RAP.

Automator : Schedule of BO exportation.
(Maintain by Adagio team is-qpsupport@solvay.com, IBM)

ISIS Tool : The tools to maintain & transfer the Oracle script, run the exploitation job by manual, Enhance the Unix Env

All the technical doc in : https://drive.google.com/drive/folders/0BwtAGBKWM-z-djFZLXBXd3NKcW8

I-SIS Tool & 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/0B8RFN88sxfy5QVpTUVVIYTJsc1k

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

The Graph - PPE - 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

The Graph - PPS - 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.

I-SIS Tool, 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