Enter your keyword

post

File vs FTP adapter in Oracle Integration Cloud

There are two inbuilt adapters offered by Oracle Integration Cloud. One is File and another FTP. Users often confused about when to use File and when to use the FTP adapter and what is the actual difference between these two adapters.

 

The common idea behind these two adapters is to handle File-based processing in the integrations.

I am writing this post to describe what is the actual difference between these two adapters?

S. No.
File Adapter
FTP Adapter
1
File can be processed from the FTP or SFTP server that is running behind the firewall with the help of connectivity agent.
File can be processed from any SFTP server which is publicly accessible or behind the firewall with the help of connectivity agent.
    2 Doesn’t allow PGP encryption and decryption on the file Allow PGP encryption and decryption on the files.
3
File adapter can be used to poll files from FTP/sFTP server.
FTP adapter can’t be used to poll files from FTP/sFTP server.
4
Following operations are supported:
  • Read File
  • Write File
  • List File
  • Delete File
  • Move File
  • Download File

 

       
Following operations are supported:
  • Read File
  • Write File
  • List File
  • Delete File
  • Move File
  • Download File  

 

5
File signing support is not there
File signing support is allowed in the adapter
6
No security policy is used to connect the File Server
Different security policy can be used to connect to FTP/sFTP server

Below interesting post related to the FTP adapter

How to write files using OIC FTP adapter

FTP adapter in Oracle Integration Cloud(OIC)

List files from FTP reside in multiple directories: OIC

Subscribe to my YouTube channel to see more videos related to OIC

Some Toughts (8)

  1. added on 8 May, 2019
    Reply

    Hi Ankur,
    this is good information.
    Do you know how to copy file from FTP server to other FTP server eg .csv file?????

  2. added on 9 May, 2019
    Reply

    Hi,

    During configuring FTP adapter don't select the schema. In mapping just map the FileReference -> FileReference

  3. added on 17 May, 2019
    Reply

    Hi Ankur…where is the information about how to create an encrypted file using PGP? I reviewed Oracle documentation and am not able to find it. Thanks!

  4. added on 17 May, 2019
    Reply

    Actually I just noticed that your article is in the context of Oracle Integration Cloud. I am using OSB 12c, which allows the use of the JCA FTP adapter. Do you know if that adapter (or other JCA adapters supported by OSB 12c) support the creation of encrypted files and how? Thanks.

  5. added on 18 May, 2019
    Reply

    Hi Mark,

    Kindly check oracle docs for the info. If FTP adapter doesn't allow you to encrypt the file then you can use Java callout to encrypt the file.

  6. added on 12 Jul, 2019
    Reply

    Hi Ankur,

    Can i use FTP adapter to transfer file from on premise server to cloud.

    Thanks.

  7. added on 14 Jul, 2019
    Reply

    Hi,

    File adapter is used to read/write file from on-prem and FTP is used to read/write from remote server

Leave a Reply

Your email address will not be published.