FTP Adapter Capabilities

The FTP Adapter enables the integration of the File Transfer Protocol (FTP) and the Secure Shell (SSH) File Transfer Protocol (sFTP) into Oracle Integration Cloud Service. Using the FTP Adapter, Oracle Integration Cloud Service can retrieve files for processing in Oracle Integration Cloud Service and can upload files and messages from Oracle Integration Cloud Service to a directory on a remote FTP server.

The FTP Adapter has the following capabilities:
  • Transfers (reads and writes) files to any publicly accessible server in either binary or ASCII format. The FTP Adapter can connect to FTP and sFTP servers that are publicly available on the internet. The adapter cannot be used to connect to FTP and sFTP servers behind company firewalls.

  • Streaming support for transferring large files.

  • Enables the integration developer to build an orchestration pattern-based flow for retrieving files from remote FTP and sFTP servers as well as for uploading the files onto remote FTP / sFTP servers.Oracle Integration Cloud Service provides the capability for scheduling the time and the frequency at which these integration flows will run. See Scheduling Integration Runs.

  • Supports a synchronous one-way request message exchange pattern. There is no response from the FTP Adapter.

  • Enables you to create a schema file format to use for the files to transfer. The schema can be created (sampled) from either a comma-separated value (CSV) file or from an existing schema file. Supported delimiters in the file are single spaces, commas, semicolons, or tabs.

  • Enables the integration developer to encrypt a file that is being uploaded to remote FTP / sFTP servers using Pretty Good Privacy (PGP) cryptography.

  • Enables the integration developer to decrypt a file that is being read or downloaded from a remote FTP / sFTP server using Pretty Good Privacy (PGP) cryptography.

  • Supports FTP over OpenSSL through the upload of a Public-Key Cryptography Standard (PKCS) format certificate. The FTP adapter supports both sFTP and FTP over SSL.

    See Using Secure FTP with the Oracle FTP Adapter.

  • The adapter provides the following specific capabilities when used with the orchestration template:

    • Connection to an FTP server, FTP Over SSL (User can upload .p12 keys to connect), and an sFTP server

    • Host Key authentication before connecting to an sFTP server

    • Public Key authentication for sFTP servers

    • The FTP Adapter is only supported as an invoke connection in the following orchestrated integration scenarios:
      • Schedule: The adapter can be invoked using the scheduler.

      • Application event or business object: The adapter can be invoked using the REST or SOAP adapter as a trigger.

    • FTP Adapter provides List File, Read File, Write File, Download File, Move File, Delete File operations.

    • User can use Format Definition page to generate schema for file format.

    • All the operations are synchronous and provide the response.

    • All the operations support dynamically passing the headers (Directory, File Name etc in mapping)

Note:

The FTP Adapter does not support the processing of files from the same folder by two integrations. File deletion causes a conflict. For example, if one integration deletes a file, the second integration cannot find the file to delete and fails.
The FTP Adapter is one of many predefined adapters included with Oracle Integration Cloud Service. You can configure the FTP Adapter as a connection in an integration in Oracle Integration Cloud Service. For information about Oracle Integration Cloud Service, connections, and integrations, see the following sections: