PaaS Partner Community

May 14, 2017

FTP Adapter Configuration for SFTP by Emiel Paasschens

Juergen Kress
PaaS & Middleware Partner Adoption

Introduction

At my current project incoming data files, located at a third party FTP server, have to be read using SFTP.
Despite of several blog posts and the FTP Adapter documentation of Oracle, it took us a full day to get a working SFTP configuration. I use this blogpost to document this for myself in case I have to do it again, and for others who need to do (about) the same.
Prerequisite

First of all start with ensuring that no firewall is blocking traffic from the weblogic server to the FTP server using the specified SFTP port (default this is 22). On a linux (or unix) server you can verify this by opening a command prompt on the weblogic server (eg. with Putty) and use command “ssh “.

SFTP Configuration

Two configuration steps are required now:
A. Create a private and public key file
B. Add a FTP Adapter Outbound Configuration for SFTP

A. Create a private and public key file (linux/unix):

Log in with a command prompt as the oracle user (the user under which weblogic runs) on the weblogic server
Navigate to the .ssh directory under the user home directory: cd ~/.ssh
Generate a public and private key with ssh-keygen (and accept defaults): ssh-keygen (4 x Enter).
Two files are created: id_rsa and id_rsa.pub
Add the public key to the ‘autorized keys’: cat id_rsa.pub >> authorized_keys

In a production environment these files should be write protected (even for the oracle account itself).

B. Add a FTP Adapter Outbound Configuration for SFTP:

1. Log in with admin privileges on the weblogic console
2. Click on “Deployments” (second item in menu on left side of page)
3. Search in the list of deployments for the “FtpAdapter” (you may have to navigate to the next page with “Next”) and click on its name (it’s a link): (hint: Customize this table -> Number of rows 100 -> Apply) Read the complete article here.

SOA & BPM Partner Community

For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter LinkedIn Facebook Wiki