locked
Calling ksh or sftp files RRS feed

  • Question

  • User-1340536165 posted

    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 .


    -regards,
    Developer

    Thursday, February 23, 2012 9:45 AM

All replies

  • User-869039768 posted

    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.

    Friday, February 24, 2012 5:03 AM