SFTP Transfer in Oracle Service Bus 12c

December 20, 2016

Reading time ~2 minutes

Requirement: So, you have a need for transferring files via SFTP in OSB 12c to the client’s SFTP endpoint location. This post can help you in couple of easy steps.

I presume you have access to your weblogic server file system where your integration will be deployed and of course the SFTP host endpoint where the files will be sent to.

“This is a work of fiction. Service names, IP’s, business services, endpoints, hostnames and ports are either the products of the author’s imagination or used in a fictitious manner. Any resemblance to actual public keys, living or dead server IP’s, or actual hosts is purely coincidental.”

Solution: As a first step let’s open the JDeveloper and create/configure everything we need for OSB 12c project part. Inside the OSB project design view in the External Services lane do a right click for an options menu. Here we will use SFTP Transfer option and create a new Business service which will be then used for sending messages via Routing activity. Hover over the ‘Insert Transports’ and click on the ‘SFTP’.

Next step is to setup the Business Service for the SFTP. Just follow the next images from the Wizard.

For the SFTP Host name example let’s use: sftp-endpoint-example-dev.org

Folder name that will contain the sent messages is: folderName

This information will be probably provided by your client/customer.

As a last step we need to configure the business service’s Transport properties. Open your business service and select the Transport Details (image below). Add the Service account with the correct credentials that your SFTP is using. And the most important property to set is the “Preferred Public Key Algorithm”, which you can set based on the what algorithm is used for the Public Key for the SSH. Here in this example I have both ‘dss’ and ‘rss’ key algorithms and I will use rss.

Later on I will show you how you can obtain the Public Key with a simple one liner command.

Now your business service is ready to be used inside OSB 12c pipeline.

Step two:

Now we have to deal with the ‘known_hosts’ file which should be located on weblogic. In 12c this is the location where the ‘known_hosts’ file should be located:

/u01/oracle/config/domains/osbdomain/config/osb/transports/sftp

The main thing is to find ‘osbdomain/config’ folders on the server file system, and probably you will be missing some of the folders ‘osb/transport/sftp’ which you will then need to create. In case you are not missing these folders then probably there is ‘known_hosts’ file already created, if not you will need to create it. Now open the ‘known_hosts’ file and add the ssh Public Key for the rss algorithm including the IP of the server where the messages will be sent.

It has to look something like this:

Handle the ‘known_hosts’ file extra carefully, and make sure that file has no CR/LF at the end. So the file should always be backed up before changing, or might even be added to subversion.

To obtain the SSH Public Key you need to GET public key (login to the weblogic with putty and run command from the root):

ssh-keyscan -t rsa,dsa sftp-endpoint-example-dev.org

As a last step you need to restart the managed servers on weblogic so the changes apply. Now your Service Bus 12c project is ready to send the messages via SFTP.

Denis is a Senior consultant and a part of middleware team at Sysco. He has an Electrotechnical engineering degree and has several Oracle certifications (SOA 12c, Enterprise Manager 12c, Linux, Java SE 8 Associate). Started as Web developer now his main focus is working with Oracle tools and technologies. He worked on numerous international projects for large telecom companies in Turkey and Bosnia & Herzegovina, and Norway in retail sector.




Get “non XML” file on request based on a file name and send it via HTTP POST with OSB 12c

Requirement is fairly simple, there is a need to transfer a “non XML” file (in this specific case .pdf document) based on the file name w...… Continue reading