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