Why doesn't oracle natively support SFTP?
Bryan, February 01, 2011 - 9:40 am UTC
I have observed that the majority of companies have set in IT policy stone that new batch process development utilize SFTP or SCP versus FTP.
So why is Oracle behind the eight ball on this one and not released a PL/SQL implementation of SFTP?
I recognize that it might not be trivial to implement, but the protocol has been around for years now, and its not like the Oracle development team is incapable of building this kind of support into Oracle.
This is a feature which many oracle developers have been asking for, so why won't the powers that be at Oracle make it happen for us?
Pass that up the chain if you can...
February 01, 2011 - 5:13 pm UTC
we never released a plsql version of ftp - so not sure what you mean???
When I said above "like we did with ftp" - I meant "we as in you and me". Someone wrote a plsql routine to implement ftp - Oracle never did.
If you want something out of the box, use a java stored procedure - many sftp implementations around.
sam, February 01, 2011 - 5:47 pm UTC
CLG, February 02, 2011 - 4:05 pm UTC
...... SFTP should not be completely out the box in Oracle.
I think the s in sftp means the primary responsibility goes to DBA/LAN/WAN team.
They should own certs/authentication standards.
MAYBE. I SAID MAYBE.
Oracle should provide a java based solution with an PL/SQL wrapper.
But actually there should be "something" else to handle the sftp management on your LAN.
My two cents.
David Aldridge, February 03, 2011 - 9:36 am UTC
A DBMS_Scheduler job is pretty handy for invoking scp, or any other os command. You do really want to do that whole key swapping thing first to keep it straightforward, but it's working nicely for me.
Code for SFTP from pl\sql program
Developer, February 27, 2012 - 9:13 am UTC
I have a pl\sql procedure thatr creats the csv file using utl_file. now i need to transfer the files to the EFT server .I am thinking to extend the existing procedure to transfer the files to EFT lcoation . Kindly give me the code to do the sftp transfer
February 28, 2012 - 7:11 am UTC
Kindly give me the code to do
the sftp transfer
neat. Wouldn't life be grand if it worked that way?
Kindly reread the original answer above. And then do what programmers are supposed to do - analyze the possible approaches, decide which one makes the most sense, and then implement it.
Calling ksh from oracle
Developer, February 27, 2012 - 9:17 am UTC
my goal is to transfer the csv files from db server to another server from Pl\sql procedure. I have two options
1. invoke ksh script from pl\sql or
2. ftp it to EFT location directly .
Kindly provide code to either of the ways possiable.
BillC, February 28, 2012 - 8:22 am UTC
You should read Tom's answer directly above your request. All the required information is contained there.