Last post Feb 24, 2012 05:03 AM by emayevski
Feb 23, 2012 09:45 AM|india2pa|LINK
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 oracle ) 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 oracle ) 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 .
Feb 24, 2012 05:03 AM|emayevski|LINK
1. Is there a way to Code
in C# (.Net) which willl SFTP *.CSV files(from DB server) to EFT location(another server) ?
There exists plenty of components for SFTP transfer in C#. You can check comparison
of main alternatives here.