Automate File Transfer an FTP server to Oracle EPM Cloud

Use this recipe to automate file transfer from an FTP server to Oracle Enterprise Performance Management Cloud (Oracle EPM Cloud).

Note:

This recipe is available as Oracle EPM Cloud — FTP Server | Automate File Transfer in the Integration Store. Oracle provides this recipe as a sample only. The recipe is meant only for guidance, and is not warranted to be error-free. No support is provided for this recipe.

Overview

This recipe demonstrates how easily you can transfer a file from any FTP/sFTP location to Oracle EPM Cloud using Oracle Integration.

The integration uses a scheduled orchestration pattern to automatically transfer the file on a regular basis. It uses the standard FTP and REST adapters available in Oracle Integration to read the file from the source location (FTP server) and then transfer it to the destination (Oracle EPM Cloud).

You store the file to be transferred on File Server, an embedded sFTP server within Oracle Integration. To use File Server, you must enable it for your Oracle Integration instance. See Enable File Server in Using File Server in Oracle Integration Generation 2.

System and Access Requirements

Oracle Integration, 18.1.5 or later
Oracle EPM Cloud, 18.03 or later
A secure FTP (sFTP) server or File Server.

Install, Configure, and Run the Recipe

For more information and steps to install, configure, and run recipes, see Get Started with Integration Accelerators and Recipes.