Current set up is some thing like this: A pl\sql block generates .csv files . a *.ksh script will invoke the pl\sql block to run (& generate *.csv) and also sftp them to EFT location(another server)
I need a similar set up in .Net . I already developed a webform that will call the pl\sql block to run (& generate *.csv file on DB server). NOw for the 2nd part of the requirement where i need to sftp these file(from Db server) to EFT location(another server) i think i have following options
1. Is there a way to Code in C# (.Net) which willl SFTP *.CSV files(from DB server) to EFT location(another server) ?
2. Invoke a *.ksh script from C# ( my *.ksh will take care of the SFTP files to EFTlocation)
3. Can i have a pl\sql block that take care of SFTP *.csv files(from DB server) to EFT location . by which i can invoke this pl\sql block from .Net .
Kindly suggest if there is any other way to acheive my requirement or which out of these three is possiable or HOW to DO it in the above ways .