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
- 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 Policy. You 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
- 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.
- Select the Save & Close button from the upper right corner
Now the FTP connection is ready to be used in the Integration.