OIC/Integration/3 → FTP Connection in Oracle Integration Cloud

This is a post on Oracle Integration Cloud highlighting the integration of FTP adapter (SFTP) in the flow.

Integration

(1) Flow: [a] Schedule → [b] Map to poll file → [c] Poll CSV file → [d] End

(2) Flow Description: Here we are creating a simple Scheduled Orchestration flow which when invoked reads file from FTP location.

(3) Steps:

We need to have a FTP set-up for which we will create a FTP account using below.

Register and start 7 days FTP trial in : https://www.files.com

You can use your personal email address to register and get an account. FTP details will be sent to your email address.

Go to OIC console > Integrations > Connections

Create Connection:

Go to OIC console → Integrations → Create a Scheduled Integration with your project name.

[a] Schedule

Nothing to configure here. We will submit an ad hoc request to trigger the flow.

[c] Poll CSV file

Contents of “ftpFile.csv” is like below:

Id,Name,Band
001,AAA,6B
002,BBB,7A
003,CCC,6B

[b] Map to Poll CSV Request

Not required/can override using mapping.

Flow:

Configure the connection in Win SCP and place the test file.

………………………………………………………………………………………………