[go: up one dir, main page]
Scribd
Upload
90 views4 pages

Info Cargaguid

This document provides instructions for running ODI scenarios and integration processes for a project. It includes details like the FTP server hostname and credentials, names of files and directories used, commands to run scenarios that update status tables, and logging failures.

Uploaded by

Lizbeth Sarahi Soto Arzate
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
90 views4 pages

Info Cargaguid

This document provides instructions for running ODI scenarios and integration processes for a project. It includes details like the FTP server hostname and credentials, names of files and directories used, commands to run scenarios that update status tables, and logging failures.

Uploaded by

Lizbeth Sarahi Soto Arzate
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 4

Es el FTP de DEV

La ruta es; /E_1/SOA_to_ODI

DEv sftp

hostname: 129.150.218.85

port: 7522

username: SOACSDev1

password: FfDthU6clfl9IufCG0Vz

NOmbre del archivo Worker.dat


NOmbre del archivo en zip GBTalent_GUID_DDMMYY_IDODI.zip
ruta para dejar el zip:/E_1/HCM /E_1/Salary_ExpVacations

OdiStartScen "-SCEN_NAME=UPDATE_TBL_CONTROL_STATUS" "-SCEN_VERSION=001" "-


INTEGRACIONS_PROJECT.GBT_ENDDATE_VALUE='21/JUN/19 12:17:01'" "-
INTEGRACIONS_PROJECT.GBT_STATUS_VALUE='SUCCESS'" "-
INTEGRACIONS_PROJECT.SESSION_NO=625833" "-
INTEGRACIONS_PROJECT.GBT_INTEGRATION_NAME='GBTALENT_GUID'"

OdiStartScen "-SCEN_NAME=UPDATE_TBL_CONTROL_STATUS" "-SCEN_VERSION=001" "-


INTEGRACIONS_PROJECT.GBT_ENDDATE_VALUE=#INTEGRACIONS_PROJECT.GBT_ENDDATE_VALUE" "-
INTEGRACIONS_PROJECT.GBT_INTEGRATION_NAME=#INTEGRACIONS_PROJECT.GBT_INTEGRATION_NAM
E" "-INTEGRACIONS_PROJECT.GBT_STATUS_VALUE='ERROR_ODI'" "-
INTEGRACIONS_PROJECT.GBT_SESSION_NO=#INTEGRACIONS_PROJECT.GBT_SESSION_NO"
*
*
*

EmindI_GBTalentGUID

EmindI_GBTalentGUID

Emindl_GBTalentGUID_[date(yyyymmdd)]_[integrationid].zip
Emindl_GBTalentGUID_#INTEGRACIONS_PROJECT.GBT_DATE_TO_FILE_#INTEGRACIONS_PROJECT.GB
T_INTEGRATION_ID.zip

OdiStartScen "-SCEN_NAME=FTP_DOWNLOAD_ARCHIVE_GBT " "-SCEN_VERSION=001" "-


#INTEGRACIONS_PROJECT.GBT_VAC_FILE_NAME=#INTEGRACIONS_PROJECT.GBT_VAC_FILE_NAME"

OdiOSCommand "-FILE_APPEND=YES" "-CAPTURE_OUT_STREAM=ON_ERROR,10,50" "-


CAPTURE_ERR_STREAM=ON_ERROR,10,50"
cd #BIMBO_INTEGRATION_HCM_VACATIONS.VAC_DIR_HDL
zip #BIMBO_INTEGRATION_HCM_VACATIONS.FILE_NAME_DELETE_ZIP
#BIMBO_INTEGRATION_HCM_VACATIONS.VAC_NAME_HDL

OdiOSCommand "-FILE_APPEND=YES" "-CAPTURE_OUT_STREAM=ON_ERROR,10,50" "-


CAPTURE_ERR_STREAM=ON_ERROR,10,50"
cd #INTEGRACIONS_PROJECT.GBT_DIR_HDL
zip #INTEGRACIONS_PROJECT.FILE_NAME_MERGE_ZIP #INTEGRACIONS_PROJECT.GBT_NAME_HDL

OdiOSCommand "-CAPTURE_OUT_STREAM=ON_ERROR,10,50" "-


CAPTURE_ERR_STREAM=ON_ERROR,10,50"
cd #INTEGRACIONS_PROJECT.GBT_DIR_HDL
rm #INTEGRACIONS_PROJECT.FILE_NAME_MERGE_ZIP

OdiOSCommand "-CAPTURE_OUT_STREAM=ON_ERROR,10,50" "-


CAPTURE_ERR_STREAM=ON_ERROR,10,50"
cd /u01/INTEGRATIONS/INBOUND/EMIND/EXP_VACATION
rm #BIMBO_INTEGRATION_HCM_VACATIONS.VAC_FILE_NAME

OdiOSCommand "-CAPTURE_OUT_STREAM=ON_ERROR,10,50" "-


CAPTURE_ERR_STREAM=ON_ERROR,10,50"
cd /u01/INTEGRATIONS
rm #INTEGRACIONS_PROJECT.GBT_VAC_FILE_NAME

hay una tabla que se llama Integration_Exec_Control


"GB_INT_SOA"."INTEGRATION_EXEC_CONTROL"
INSERT INTO INTEGRATION_EXEC_CONTROL
(INTEGRATION_ID,"INTEGRATION
_NAME",REPORT_NAME,JOB_EXEC_DATE,ENDDATE,STATUS,SESSIONID)

VALUES
(INTEGRATION_EXEC_CONTROL_SEQ.NEXTVAL,'GBTALENT_GUID','GBTALENT_GUID','16/06/19
20:00:00','17/06/19 20:00:00','SUCCESS',[IDOI]);

ponle algunos status genericos, ya despues podemos ajustar esos valores

UPDATE INTEGRATION_EXEC_CONTROL
SET STATUS = #INTEGRACIONS_PROJECT.GBT_STATUS_VALUE
WHERE
"INTEGRATION _NAME" = #INTEGRACIONS_PROJECT.GBT_VAC_FILE_NAME
AND SESSIONID = #INTEGRACIONS_PROJECT.SESSION_NO

UPDATE INTEGRATION_EXEC_CONTROL
SET ENDDATE = #BIMBO_INTEGRATION_HCM_VACATIONS.VAC_ENDDATE_VALUE,
AUX006 = #BIMBO_INTEGRATION_HCM_VACATIONS.VAC_AUX6_VALUE,
STATUS = #BIMBO_INTEGRATION_HCM_VACATIONS.VAC_STATUS_VALUE,
SESSIONID = #BIMBO_INTEGRATION_HCM_VACATIONS.VAC_SESSION_ID
WHERE
AUX005 = #BIMBO_INTEGRATION_HCM_VACATIONS.VACATIONS_UUID
AND "INTEGRATION _NAME" = #BIMBO_INTEGRATION_HCM_VACATIONS.VAC_INTEGRATION_NAME
(INTEGRATION_ID,"INTEGRATION
_NAME",REPORT_NAME,JOB_EXEC_DATE,ENDDATE,STATUS,SESSIONID)

OdiStartScen "-SCEN_NAME=UPDATE_TBL_CONTROL_STATUS" "-SCEN_VERSION=001" "-


INTEGRACIONS_PROJECT.GBT_STATUS_VALUE='ERROR-ODI'"

OdiStartScen "-SCEN_NAME=VAC_UPDATE_CONTROL_TBL" "-SCEN_VERSION=001"


-INTEGRACIONS_PROJECT.GBT_ENDDATE_VALUE=INTEGRACIONS_PROJECT.GBT_ENDDATE_VALUE" "-
INTEGRACIONS_PROJECT.GBT_STATUS_VALUE='ERROR_ODI'" "-
INTEGRACIONS_PROJECT.GBT_INTEGRATION_NAME='#INTEGRACIONS_PROJECT.GBT_INTEGRATION_NA
ME'" "-INTEGRACIONS_PROJECT.SESSION_NO=#INTEGRACIONS_PROJECT.SESSION_NO" "-
INTEGRACIONS_PROJECT.GBT_JOB_EXEC_DATE=#INTEGRACIONS_PROJECT.GBT_JOB_EXEC_DATE" "-
INTEGRACIONS_PROJECT.REPORT_NAME=#INTEGRACIONS_PROJECT.GBT_INTEGRATION_NAME"

UPDATE INTEGRATION_EXEC_CONTROL
SET ENDDATE = #BIMBO_INTEGRATION_HCM_VACATIONS.VAC_ENDDATE_VALUE,
AUX006 = #BIMBO_INTEGRATION_HCM_VACATIONS.VAC_AUX6_VALUE,
STATUS = #BIMBO_INTEGRATION_HCM_VACATIONS.VAC_STATUS_VALUE,
SESSIONID = #BIMBO_INTEGRATION_HCM_VACATIONS.VAC_SESSION_ID
WHERE
AUX005 = #BIMBO_INTEGRATION_HCM_VACATIONS.VACATIONS_UUID
AND "INTEGRATION _NAME" = #BIMBO_INTEGRATION_HCM_VACATIONS.VAC_INTEGRATION_NAME

UPDATE INTEGRATION_EXEC_CONTROL
SET ENDDATE = #BIMBO_INTEGRATION_HCM_VACATIONS.VAC_ENDDATE_VALUE,
AUX006 = #BIMBO_INTEGRATION_HCM_VACATIONS.VAC_AUX6_VALUE,
STATUS = #BIMBO_INTEGRATION_HCM_VACATIONS.VAC_STATUS_VALUE,
AUX005 = #BIMBO_INTEGRATION_HCM_VACATIONS.VAC_AUX5_VALUE,
SESSIONID = #BIMBO_INTEGRATION_HCM_VACATIONS.VAC_SESSION_ID
WHERE
AUX004 = #BIMBO_INTEGRATION_HCM_VACATIONS.VACATIONS_UUID
AND "INTEGRATION _NAME" = #BIMBO_INTEGRATION_HCM_VACATIONS.VAC_INTEGRATION_NAME

UPDATE INTEGRATION_EXEC_CONTROL set STATUS = '#INTEGRACIONS_PROJECT.STATUS_VALUE',


SESSIONID =#INTEGRACIONS_PROJECT.SESSION_NO,
UPDATEDATE = SYSDATE, AUX001 =
'#INTEGRACIONS_PROJECT.COUNT__STG_HCM_WORKERS__BY_BATCH_ID',
AUX002 = '#INTEGRACIONS_PROJECT.COUNT__ICWE_EMIND_WORKERS_STG' WHERE BATCHID =
'#INTEGRACIONS_PROJECT.WORKER_BATCH_ID

OdiOSCommand "-FILE_APPEND=YES" "-CAPTURE_OUT_STREAM=ON_ERROR,10,50" "-


CAPTURE_ERR_STREAM=ON_ERROR,10,50"
cd #INTEGRACIONS_PROJECT.GBT_DIR_HDL
zip #INTEGRACIONS_PROJECT.FILE_NAME_MERGE_ZIP #INTEGRACIONS_PROJECT.GBT_NAME_HDL

From Luis Esteche to Everyone: 04:34 PM


actualizar tabla OUTBOUND_CONFIG, campos SFTP_REMOTE_HOST, SFTP_REMOTE_USER_NAME,
SFTP_REMOTE_PASSWORD
From Omar Antonio to Everyone: 04:38 PM
PKG_E_CAT_DEPARTAMENTOS
GETWORKERS_E_ETL_PKG_R3_V2
PKG_ABSENCES
PKG_EMIND_BENEFICIOS

OdiOutFile "-
FILE=/u01/INTEGRATIONS/LOGS/ODI_FAIL_#INTEGRACIONS_PROJECT.ID_INTEGRATION_<
%=odiRef.getPrevStepLog("STEP_NAME")%>_<%=odiRef.getSysDate("yyyy-mm-dd")%>.log"
-APPEND "-CHARSET_ENCODING=ISO8859_1" "-XROW_SEP=0D0A"
Step <%=odiRef.getPrevStepLog("STEP_NAME")%> finished in failure.
Error message :
<%=odiRef.getPrevStepLog("MESSAGE")%>
===================================================================================
=
===================================================================================
=

OdiOutFile "-
FILE=/u01/INTEGRATIONS/LOGS/ODI_FAIL_#INTEGRACIONS_PROJECT.ID_INTEGRATION_<
%=odiRef.getPrevStepLog("STEP_NAME")%>_<%=odiRef.getSysDate("yyyy-mm-dd")%>.log"
-APPEND "-CHARSET_ENCODING=ISO8859_1" "-XROW_SEP=0D0A"
Step <%=odiRef.getPrevStepLog("STEP_NAME")%> finished in failure.
Error message :
<%=odiRef.getPrevStepLog("MESSAGE")%>
===================================================================================
=
===================================================================================
=

You might also like