X

The Integration blog covers the latest in product updates, best practices, customer stories, and more.

  • August 10, 2020

Embedded File Server (SFTP) in Oracle Integration

We will be talking about how to leverage embedded File Server in Oracle Integration in this blog.

Prerequisites: Basic knowledge of Oracle Integration.

Targeted audience: Oracle Integration Developers OR Oracle Integration Users.

File Server Overview

File Server provides an embedded SFTP server within Oracle Integration, enabling organizations to focus on building integrations without needing to host and maintain a separate SFTP server.

 

Enable File Server in OIC

Before use, File Server must be enabled for the Oracle Integration instance. Enabling File Server is a one-time action completed in Oracle Cloud Infrastructure by an administrator with manage access to the instance. See Enable File Server

 

File Server Users

The primary users of File Server include:

  • Oracle Integration administrators, who use File Server to manage server settings and configure users, groups, and folders, including permissions. To administer File Server as described in this guide, you must be assigned the ServiceAdministrator role in Oracle Integration. See Oracle Integration Service Roles in Provisioning and Administering Oracle Integration and Oracle Integration for SaaS, Generation 2.

  • Oracle Integration developers, who use File Server along with the FTP adapter in integrations to read and write files.

  • Oracle Integration users, who access File Server using an SFTP client. These users must be configured and enabled as users in File Server. Their access is controlled by their assigned folders and folder permissions.

USECASE BACKGROUND

This use case reads the file from Standalone SFTP server and writes into Oracle Integration(OIC) File Server. As part of this blog, you will also learn how to create a folder, provide permission and get the File Server details.

Let us say I want to implement the above use case, I need Standalone SFTP Server(Source system) details like IP address/Host, Port number, username, password and hope you know how to get all those details. And I also need to get File Server details which is provided as part of Oracle Integration.

Now, we will talk about how to get into the File Server of OIC and get all the details which are required to connect like IP Address, Port. For username and password, you could use your OIC Username and password.

How to get IP and PORT information?

Login to OIC àHomeàSettingsàFile Server àSettings àGeneral Tab

 

How to create a folder?

Login to OIC àHome àSettings àFile Server àFolders àClick on home àclick on users àclick on the folder which is created with your name/emailed àclick on Create to create a folder

After creating the folder, you will have to give permissions to that folder, select the folder, on your right hand side, you can see the option called Permissions. Click on the Permissions àClick on Add Permissions àSearch for the user to whom you have to give permission àSelect the user and click on Add àand Select All checkbox if you have to give full access or enable specific permission which you want to give and click on Save.

Go back to Home page, click on Integrations to implement your use case by following the below steps.

  1. Create a connection based on the FTP adapter that points to a standalone SFTP server

  2. Create one more connection based on the FTP adapter that points to File Server..

  3. Create an integration based on the scheduled file transfer pattern that reads files from the standalone SFTP server and writes them to File Server

  4. Invoke SFTP Server to read the file and select the operation and provide Input Directory and File Name

 

5. Write the file to OIC File Server, while writing, you will have to provide the relative path of your directory starting from the /home directory, screenshot given below.

6. Edit “Map to writeFile” and map the the file reference from source to target as per the screenshot given below and click on Validate and click on Save to save your integration flow.

7. Define Business Identifiers for tracking and click on Save and close the integration

8. Activate the integration and run it by clicking on Submit Now

9. Monitor the instance. If it is successful, you can login to OIC File Server using FileZilla to verify the file. Otherwise, fix the error and execute it again.

10. Install FileZilla client, Open FileZillaàClick on FileàSite Manager àClick on New Site àSelect Protocol as “SFTP” and provide the remaining details like OIC File Server IP, PORT, Username and password and click on Connect

11. Go to the folder which you have specified as part of the Integration and could see the output file generated from OIC. 

Documentation

Learn more about File Server here

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.