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