1. Using File Server in Oracle Integration 3
  2. Get Started with File Server
  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.

You have the following options for connecting to File Server:

  • File server action

    See Interact with Files in File Server in Using Integrations in Oracle Integration 3.

  • FTP Adapter

    An administrator can 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 3.

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. In the navigation pane, click Settings, then File Server, then Users.
  2. Configure an end user for File Server access.
    1. Search for and find a user.

      Only users who have been configured Oracle Identity Cloud Service appear in the list.

    2. Hover over the user, and click Configure Edit icon.
    3. In the Property panel, enable the user for access, upload a public key for authentication, and configure a default home folder.
    4. After you finish making changes, click Save.
  3. Set folder permissions for the user's default home folder.
    1. Hover over the user, and click Open Details Expand icon
    2. Next to Home Folder Permissions, click Go to Home Folder Permissions Permissions icon.
    3. On the Permissions page, grant all permissions to the user.
    4. Click Save.
    5. Click Go Back Back icon to return to the Users page.
  4. Provide connectivity information to the end user.

    The end user needs to enter this information into their SFTP client so they can connect to File Server.

    1. In the navigation pane, click Settings.
    2. In the General section, copy the IP address and port number, and share this information with the user.

End user steps:

  1. Connect to File Server from an SFTP client.
    1. Launch the SFTP client.
    2. Connect to File Server using the IP address and port number shared by the admininstrator, and your Oracle Integration username and password.
  2. View your home folder, which the administrator configured, 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. In the navigation pane, click Settings, then File Server, then Folders.
  2. Find a folder and configure its permissions.
    1. Hover over the folder, and click Permissions Permissions icon.
    2. 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.
    • In the navigation pane, click Design, then Connections.
  2. Create a source connection based on the FTP Adapter that points to a standalone SFTP server.

  3. Complete one of the following tasks:

    • Add a File server action to the integration.

    • 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 Observability area, monitor the integration’s run.

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