* SFTP reports from multiple source locations to multiple target locations based on few conditions like daily/weekly/monthly reports, country code, holiday calendar check etc
* I have an oracle table which stores source locations(columnx), target locations(columny) etc. Below are the column names.
ID, FT_SOURCE_NAME, FT_COUNTRY_CODE, FT_TARGET_APPL, FRQ_SW, FT_FIL_NME_BUSS_SYSDTE, FT_BUSS_DTE_FIL_NME, FT_BACKUP, FT_FOLDER, FOL_NO_OF_FIL, FT_CMD_IN_OUT, FT_EXE_CMD, FT_EXIT_CODE, FT_TRAN_CODE, FT_SOURCE_PATH, FT_TARGET_PATH, FT_LST_UPD_DTE, PRIOR_SW, FLAG, FT_STATUS, BIZ_DATE, FT_ERR_DESC, FT_REMARKS, FT_COMMENTS, FT_START_TF, FT_END_TF, FT_FOLDER_SIZE, UPDATED_BY, REQ_USER, REQ_DATE, REGULATORY_Y_N, RPT_LOCATION
Note: currently above job is automated in VB with oracle database
Requirement: automate above job in linux shell scripting with oracle database. Is this possible or not?
note: We need to take input from oracle table like source location, target location etc and after the file transfer the oracle table should be updated accordingly.
* I have an oracle table which stores source locations(columnx), target locations(columny) etc. Below are the column names.
ID, FT_SOURCE_NAME, FT_COUNTRY_CODE, FT_TARGET_APPL, FRQ_SW, FT_FIL_NME_BUSS_SYSDTE, FT_BUSS_DTE_FIL_NME, FT_BACKUP, FT_FOLDER, FOL_NO_OF_FIL, FT_CMD_IN_OUT, FT_EXE_CMD, FT_EXIT_CODE, FT_TRAN_CODE, FT_SOURCE_PATH, FT_TARGET_PATH, FT_LST_UPD_DTE, PRIOR_SW, FLAG, FT_STATUS, BIZ_DATE, FT_ERR_DESC, FT_REMARKS, FT_COMMENTS, FT_START_TF, FT_END_TF, FT_FOLDER_SIZE, UPDATED_BY, REQ_USER, REQ_DATE, REGULATORY_Y_N, RPT_LOCATION
Note: currently above job is automated in VB with oracle database
Requirement: automate above job in linux shell scripting with oracle database. Is this possible or not?
note: We need to take input from oracle table like source location, target location etc and after the file transfer the oracle table should be updated accordingly.
Last edited: