Thursday, 22 November 2018

Difference between File and FTP adapter in Oracle Integration Cloud

There are two inbuilt adapters offered by Oracle Integration Cloud. One is File and another one is FTP. Users often confused when to use File and when to use 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.

We are 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 server where the connectivity agent is installed
File can be processed from any SFTP server which is publicly accessible
2
The adapter can be used to connect to the server which is having the network restrictions
The adapter cannot be used to connect to FTP and sFTP servers behind company firewalls
3
File adapter is supported for both trigger and invoke connections
FTP Adapter is only supported as an invoke connection
4
Following operations are supported:
  • Read File
  • Write File

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

5
Doesn’t allow to create encrypted file
Allows developer to create encrypted file using Pretty Good Privacy (PGP) cryptography
6
Doesn’t allow to decrypt the files
Allow developer to decrypt a file that is being read or downloaded from a remote FTP / sFTP server using Pretty Good Privacy (PGP) cryptography

8 comments:

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

    ReplyDelete
    Replies
    1. Hi,

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

      Delete
    2. Hi, check out below blog

      https://www.techsupper.com/2019/05/copy-files-from-one-sftp-to-another.html

      Delete
  2. 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!

    ReplyDelete
    Replies
    1. 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.

      Delete
    2. 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.

      Delete
  3. Hi Ankur,

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

    Thanks.

    ReplyDelete
    Replies
    1. Hi,

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

      Delete