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:
|
Following operations are supported:
|
|
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
Hi Ankur,
this is good information.
Do you know how to copy file from FTP server to other FTP server eg .csv file?????
Hi,
During configuring FTP adapter don't select the schema. In mapping just map the FileReference -> FileReference
Hi, check out below blog
https://www.techsupper.com/2019/05/copy-files-from-one-sftp-to-another.html
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!
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.
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.
Hi Ankur,
Can i use FTP adapter to transfer file from on premise server to cloud.
Thanks.
Hi,
File adapter is used to read/write file from on-prem and FTP is used to read/write from remote server