X

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

Leveraging Oracle Integration File Server For File Based Integrations

Kundan Vyas
Principal Product Manager

Introduction 

While most enterprises want to leverage modern API-based integration technologies to automate their business processes , they are also in need of a File-based integration to enable exchange of data through files. Such enterprises often require a secure file storage solution to exchange files with their trading partners, vendors and suppliers. It is very common for these enterprises to use such a file storage solution with File-based integration to schedule and automate the process of reading and transforming files before exchanging them with multiple systems.

There are multiple use cases where enterprises rely on File-based integration. Learn more about the use cases and File-based integration patterns supported by Oracle Integration in this blog from Michael Meiner.

Introducing File Server In Oracle Integration (OIC)

Oracle is introducing a new functionality called File Server which comes embedded within Oracle Integration (OIC) and offers significant advantages to enterprises which are in need of building and rolling out File based integrations. While customers can provision an SFTP server on Oracle Cloud Infrastructure (OCI) compute resource today, they will now have an option to leverage an Oracle managed SFTP server that is tightly coupled with OIC.

File Server is available at all regional data centers on Oracle Integration Generation 2. Learn more about all the features available in Oracle Integration Generation 2 here.

Feature Summary

  1. Embedded SFTP server within Oracle Integration (OIC)

    File Server provides a standard SFTP interface that can be used by any SFTP client to access the files. It also exposes a REST api. You can access the REST API documentation here. Also, the integrations within OIC can read and write files from the File Server using the OIC FTP adapter .

  2. Free Storage – 500 GB per service instance
    Each File Server service instance comes with 500GB of storage which can be used by enterprises to store any number of files. File size is not limited when uploading or downloading files from an SFTP client, although it is subject to allocated storage limits. However, files accessed in an integration are subject to Oracle Integration limits. In integrations, inline message payloads (such an XML string or a JSON string) are limited to 10MB, and files and attachments (such as SOAP attachments) can be up to 1GB.
     
  3. Powerful web admin console to manage and configure server, users and group
     
    • Configure File Settings

      The Settings page can be used by the File Server administrator to monitor overall health, and configure other settings like default home folder for users, and security.


       
    • Configure Users and Groups

      This page is used to configure user's default home folder and public key for authentication. You can also enable or disable File Server access for specific users on this page. 



     
    • Manage Folder Permissions

      File Server administrators can manage permissions for users and groups on specific folders. You can also choose if you want the subfolders to inherit the permissions or not.

    • Manage Custom Folders

      Folders page can be used to manage custom folders and set permissions on these folders. 

  4. Multiple connectivity options to read/write files from File Server
    • Oracle Integration via FTP adapter

      You can connect to the File Server from an Integration through an FTP adapter. The picture shown below shows a simple integration which reads a file from a standalone sFTP server and writes it to the File Server embedded within Oracle Integration.


       
    • SFTP Client or SFTP command line
      Users can also connect to File Server through an sFTP client or sFTP command line interface.  You can learn more about File Server connectivity here.
       
    • REST APIS (Link to API documentation)
      You can learn more about the File Server REST APIs here.

Use Cases

  • #1: sftp server lift-and-shift
    • Enterprises which are hosting an sftp server in cloud to store files for integration can move their files to File Server within Oracle Integration (OIC) . They can then redirect their sftp adapter to point to OIC File Server.
  • #2: Communication with trading partners, customer and suppliers
    • Leverage File Server to receive and store information (PO, invoices, shipping info, etc) from trading partners via sftp. This use case also applies to B2B/EDI.
  • #3: Integration for Customer’s SaaS applications
    • This is a scenario where an enterprise has SaaS (or on-premise) applications that export (bulk) data to a file on an sftp server. OIC can then pick up the file, translate and send to target system.  

Documentation

Learn more about File Server here