I want to automate below tasks

haleem02

New Member
Joined
Dec 6, 2019
Messages
3
Reaction score
0
Credits
0
* 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.
 
Last edited:


If you can automate it in VB, then it should be possible to automate in Linux using pretty much any scripting language.

So yes - you could do it with shellscript. But you should be aware that you aren't necessarily limited to using shell-scripting. You could also use Perl, Python, Ruby, Lua etc etc.

Perl or Python would be good choices because they're installed by default on most Linux distros.
 
If you can automate it in VB, then it should be possible to automate in Linux using pretty much any scripting language.

So yes - you could do it with shellscript. But you should be aware that you aren't necessarily limited to using shell-scripting. You could also use Perl, Python, Ruby, Lua etc etc.

Perl or Python would be good choices because they're installed by default on most Linux distros.
Noted. Thanks for the advice!
 

Members online


Latest posts

Top