1. Using File Server in Oracle Integration Generation 2
  2. File Server Overview
  3. File Server Use Cases

File Server Use Cases

File Server users use SFTP to work with files stored on File Server based on their folder access and permissions.

Typically, administrators configure the Oracle Integration FTP Adapter to use File Server to manage and retrieve files for use in Oracle Integration. See FTP Adapter Capabilities in Using the FTP Adapter with Oracle Integration Generation 2.

Common Use Cases

File Server can be used in a variety of scenarios. Here are some common use cases.
Use Case Description

Communication with trading partners

Communication with trading partners such as customers and suppliers. In these cases, File Server enables trading partners to send information such as purchase orders, invoices, and shipping information using SFTP.

Integration with SaaS applications

SaaS (or on-premises) applications often export bulk data to files on an SFTP server such as File Server. For example, Oracle E-Business Suite generates a zip file with external transactions, which need to be bulk uploaded to ERP. Oracle Integration can pick up the files, process them, and send them to a target system.

SFTP server lift-and-shift

If your organization is running an on-premise SFTP server with Oracle Integration using the FTP Adapter, you may want to move this SFTP server to the cloud. Move the SFTP files into the Oracle Integration File Server, and redirect the FTP Adapter.

Scenario 1: Write files from an SFTP client to File Server

This scenario configures an individual user access to use an SFTP client to write files to File Server.

This simple end-to-end scenario involves two personas:

  • an Oracle Integration administrator who configures a user’s folder and its permissions in File Server

  • an end user who uses an SFTP client to connect to File Server and upload files to his or her configured folder.

Oracle Integration administrator steps:

  1. Navigate to File Server.

    1. Sign in to Oracle Integration as an administrator.

    2. From the navigation pane of the Oracle Integration home page, choose Settings, then File Server.

  2. Search and find an end user, and configure the user for File Server access.

    1. Choose Users from File Server's options.

    2. Search and find a user from those configured for Oracle Identity Cloud Service.

    3. Click Edit Configuration for the user.

    4. Enable the user for access, configure a default home folder, and upload a public key for authentication.

  3. Set folder permissions for the user's default home folder.

    1. Click Expand icon to view the user's details.

    2. Click Home Folder Permissions and grant all permissions.

  4. Provide connectivity information to the end user, which is needed in the SFTP client to connect to File Server.

    1. Choose Settings in the navigation pane.

    2. View the File Server's IP and Port, and provide by email to the user.

End user steps:

  1. Connect to the Oracle Integration File Server from an SFTP client.

    Launch the SFTP client and connect using the connectivity information (IP address and port number) shared by the admininstrator, and your Oracle Integration username and password.

  2. View your home folder (configured by the administrator) and upload files to it.

Scenario 2: Configure an integration to read files from a standalone SFTP server and write them to File Server

This scenario uses an integration based on a scheduled file transfer that reads files uploaded to a standalone SFTP server and write them to File Server.

This end-to-end scenario involves these personas:

  • an Oracle Integration administrator who configures a user’s folder and its permissions in File Server.

  • an Oracle Integration developer who first creates connections for source (standalone SFTP server) and target (File Server) endpoints, and then creates an integration that reads files from the standalone SFTP server and writes them to File Server.

Oracle Integration administrator steps:

  1. Navigate to File Server.

    1. Sign in to Oracle Integration as an administrator.

    2. From the navigation pane of the Oracle Integration home page, choose Settings, then File Server.

  2. Find a folder and configure its permissions.

    1. Choose Folders from the File Server navigation pane.

    2. Navigate to a folder.

    3. Hover over the folder and click its Permissions icon.

  3. Set folder permissions.

    • Grant all permissions on the user’s home folder permissions, and save.

Oracle Integration developer steps:

  1. In Oracle Integration, navigate to integrations and connections.

    • Sign in to Oracle Integration as a developer.

    • Navigate to Integrations, then Connections.

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

  3. Create a target connection based on the FTP adapter that points to File Server.

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

  5. Run the integration to move the files from source to target. (Run as an ad hoc request to test it.)

  6. In the Integrations Monitoring area, monitor the integration’s run.

    For example, view its run details and its activity stream.