Enter your keyword

post

FTP adapter in Oracle Integration Cloud(OIC)

The FTP adapter in Oracle Integration Cloud is one of the out of box adapters that help you to interact with FTP or SFTP. Using FTP adapter available in OIC, we can read, write, list, etc. files from the FTP server accessible over the internet as well as the FTP that is running behind the firewall with the help of connectivity agent.

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 or within on-premise with the help of connectivity agent.
  • 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 an FTP connection in Oracle Integration Cloud Service.
  • Login into the Oracle OIC
  • Select Connection tile from home page and select Create button from the upper right side corner
  • Search FTP and Select FTP adapter

FTP adapter in Oracle Integration Cloud (OIC)

  • 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

  • In the Connection Properties section enter below information
    • Enter FTP Server Host Address
    • Enter FTP Server Port
    • Select Yes from SFTP Connection drop down

  • Configure below properties from the Security section
    • Policy: Select FTP Public Key Authenitcation PolicyYou can select any policy depending on Security Policy of the FTP or SFTP
    • Enter User Name
    • Upload Private key file. This option is only visible if you select “FTP Public Key Authenitcation” policy.
    • Enter PassPhrase if any of the Private key file

FTP adapter in Oracle Integration Cloud

  • All other properties are optional hence leave it for the time being.
  • Under the Agent Group section, configure Agent if FTP or SFTP is behind the firewall. Since my SFTP is accessiable over the internet hence it is not required.
  • Click Save and Test the connection from top right corner.

FTP adapter in Oracle Integration Cloud

  • Select the Save & Close button from the upper right corner
Now the FTP connection is ready to be used in the Integration.
Subscribe to my YouTube channel to get the latest updates.
For more details about FTP adapter, please see Oracle official documentation

Some Toughts (7)

  1. Karim
    added on 18 Apr, 2018
    Reply

    Useful info 🙂

  2. added on 2 Nov, 2018
    Reply

    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.

  3. added on 6 Nov, 2018
    Reply

    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

  4. added on 7 Nov, 2018
    Reply

    Thanks Ankur

  5. added on 30 Apr, 2019
    Reply

    SENT our encrypted file transfer app is your best choice to send files of any size to any amount of recipients. We're easier and more secure than any other.
    Tranfer Large Files Free | Secure & Encrypted

  6. added on 14 Jun, 2019
    Reply

    Thank you for providing this useful post which is really helpful for me in encryption side. Your article was quite awesome to read.

  7. added on 18 Jul, 2019
    Reply

    Thankyou for sharingerp software companies

Leave a Reply

Your email address will not be published.