...

The data source is the Pure server (ftp.credit360.com), which Talend will load the file via FTP (more detail from PURE click on this link).  The Talend project EHS_PURE load these data first and keep to GCP project solvay-ind-conso-[env] on the dataset ehs_pure_[env]_mig, which is existing and not part of Operational Dashboard project. 

Source FTP server = "ftp.credit360.com"  / User = "solvay" by using Private key file and it keep in remote engine GCP at this folder \DATA\DEV\EHS\Pure\InOut\pure_sftp_ssh_key (control by context variable l_CNX_EHS_PURE_SFTP_private_key )

...

GCP dataset = solvay-ind-conso-dev.DS_prj_data_industrial_dash

V_core_hd_monthly  → prj-data-industrial-dash-[env].DataOcean_solvay_conso.V_core_hd_monthly → DPL.V_core_hd_monthly

v_core_hd_quarterly →  prj-data-industrial-dash-[env].DataOcean_solvay_conso.V_core_hd_quarterly → DPL.V_core_hd_quarterly

V_os_data →  prj-data-industrial-dash-[env].DataOcean_solvay_conso.V_os_data → DPL.V_os_datat

V_ps_data

Note: OS =  Occupational safety incidents

          PS = Process Safety

V_ts_data →  prj-data-industrial-dash-[env].DataOcean_solvay_conso.V_ts_data → DPL.V_ts_data

V_ps_data →  After that project IND_DASHBOARD just create views in dataset prj-data-industrial-dash-dev[env].DataOcean_solvay_conso → DPL.  There is no Talend jobs. .V_ps_data → DPL.V_ps_data

NOTE:

• OP = Occupational Safety
• PS = Process Safety
• TS = Transport Safety