Tuesday, 11 July 2017

FTP adapter in Oracle Integration Cloud Service

FTP adapter in Oracle ICS enables the integration of File Transfer Protocol(FTP) and Secure Shell File(SSH) Transfer Protocol. Using FTP adapter available in ICS, we can read and write files from ICS integration on the remote FTP server.

Capabilities of FTP adapter
  • Read and write files in either binary or ASCII format to any FTP server that is accessible on the open internet. FTP adapter is not capable to connect to FTP & sFTP that resides in organization premises.
  • Streaming support for transferring large files.
  • The adapter allows us 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 us to encrypt a file that is being uploaded to remote FTP / sFTP servers using Pretty Good Privacy (PGP) cryptography.
  • Enables us to decrypt a file that is being read or downloaded from a remote FTP / sFTP server using Pretty Good Privacy (PGP) cryptography.
Let's see how to create a FTP connection in Oracle Integration Cloud Service.
  • Login into the Oracle ICS
  • Select Connection tile from home page and select Create button from the upper right side corner
  • Search FTP and Select FTP adapter
  • Enter below information and click Create button
    • Enter Name
    • Identifier would be automatically picked up based on name entered however we can edit it.
    • Select Role as Trigger and Invoke depending on the requirement.
    • Enter Description
  • Select Configure Connectivity button and enter below information and click OK button
    • Enter FTP Server Host Address
    • Enter FTP Server Port
    • Select Yes from SFTP Connection drop down
  • Select Configure Security button and enter below information and Click OK button
    • Select FTP Server Access Policy from Security Policy drop down
    • Enter User Name
    • Enter Password & Confirm Password
  • Select Test button from the upper right corner. If all the details are correct then we will see the connection is successful and the progress bar will reach 100%
  • Select Save & Close button from the upper right corner
We are ready to use FTP adapter in the integration.

For more details about FTP adapter, please see Oracle official documentation

4 comments:

  1. The FTP Adapter can be used as Trigger or Invoke. Can you help explain which scenario we use the adapter as "Trigger" and as "Invoke". It will help clarify my understanding. I did read the Oracle documentation. Appreciate your help.

    ReplyDelete
    Replies
    1. Hi Marc,

      FTP adapter can't be dropped as a "Trigger" point however if you want to treat FTP adapter as a Trigger then create a Scheduler integration then drop FTP adapter as a Invoke Activity.

      Regards,
      Ankur

      Delete