Work with Files on FTP Servers

Use these recipes to work with files on FTP servers.

Note:

These recipes are available as FTP Bulk Import and FTP Read-Write Files List in the Integration Store. Oracle provides these recipes as samples only. These recipes are meant only for guidance, and are not warranted to be error-free. No support is provided for these recipes.

Overview

The FTP recipes use the FTP Adapter to read and write files to an FTP server. These recipes enable you to import bulk files and modify their content in Oracle Integration, or copy a list of files from one directory to another on an FTP server.

You can store the set of files to import or work with 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.

Recipe Name Description

FTP Bulk Import

Retrieves a zip file (a set of files) from an FTP server, modifies the content of each file, and writes the transformed zip file back to the server.

Note:

For the files to be successfully read and transformed, you must provide the schema files (comma-separated value (CSV) or .txt files) that contain the required data structures in the Stage File actions for reading and writing files.

FTP Read-Write Files List

Copies a list of files from one directory to another on an FTP server.

System and Access Requirements

  • Oracle Integration

  • A secure FTP (sFTP) server or File Server

  • An FTP client to access the external sFTP server

Install, Configure, and Run the Recipes

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

To use the collection of FTP recipes, you must configure the Oracle FTP Connection. You only need to configure this connection once. All the FTP recipes listed above use the same connection.

For prerequisites to configure the connection, see Prerequisites for Creating a Connection.

For details on configuring the FTP connection, see Create an FTP Connection.