Configuring an FTP Adapter in Oracle Integration Cloud Service (ICS)

Oracle FTP Server provide a long list of the functionalities to upload the file to any available server over the internet.  Its very much similar to ftp adapter in the Oracle SOA suite. But its different from File Adapter because file adapter was capable of working on the file on same server, where soa suite is running.  Here are some features of the file adapter. 

• It supports  upload of an XSD file without a target namespace. it add a surrogate namespace is added to the XSD file that all messages then use:

  http://xmlns.oracle.com/cloud/adapter/nxsd/surrogate

• Transfers (reads and writes) files to any publicly accessible server in either binary or ASCII format. The FTP Adapter can connect to FTP and sFTP servers that are publicly available on the internet. The adapter cannot be used to connect to FTP and sFTP servers behind company firewalls. 
• Streaming support for transferring large files. Which mean your file will be divided into chunks and trasferred. 
• Enables the integration developer to build an orchestration pattern-based flow for retrieving files from remote FTP and sFTP servers as well as for uploading the files onto remote FTP / sFTP servers.Oracle Integration provides the capability for scheduling the time and the frequency at which these integration flows will run.
• Supports a synchronous one-way request message exchange pattern. There is no response from the FTP Adapter.
• Enables you 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 the integration developer to encrypt a file that is being uploaded to remote FTP / sFTP servers using Pretty Good Privacy (PGP) cryptography.
• Enables the integration developer to decrypt a file that is being read or downloaded from a remote FTP / sFTP server using Pretty Good Privacy (PGP) cryptography.
• Supports explicit FTP over SSL. Implicit FTP over SSL is not supported.
• Supports FTP over OpenSSL through the upload of a Public-Key Cryptography Standard (PKCS) format certificate. The FTP Adapter supports both sFTP and FTP over SSL. When using FTP over SSL, note that only explicit TLS/SSL encryption is supported.
• Supports self-diagnosing connectivity issues that may occur when integrating with external sFTP servers.

Configuring an FTP Server 

1. Login to your OIC server and now clock on the connections, once this screen visible, click on the create. 

2. Now it open up the connection crate page, in the adapter select ftp adapter and provide the connection name like I have provided ORCU16_E001_FTP_ADP

3. Provide the connection name like I have provided ORCU16_E001_FTP_ADP, keep the Trigger and invoke to as it is.

     

It will open up the page to configure the connection parameter. Here thing to remember it connection is normally a reusable thing, hence we are just providing generic parameter not all the parameter. 

Connection Properties

   Provide the information about your server and its location and where does it exists, port information and also if its sftp. If you want to connect using any keys then also options are there. Minimum information required is 

1. Host 
2. Port
3. SFTP - Yes or No

Close once all the information been key in.

Credentials 

 Last part of the configurations is credentials mapping, provide minimum is username for the ftp server and password. If using any other way then other details also required.

Once all the information is done, its ready for testing.  

Please save and test it, and connection is ready to be used.