About This Recipe

This recipe 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.

To use the recipe, you must install the recipe and configure the connection and other resources within it. For the recipe to successfully read and transform the files, you must provide the schema files (.CSV or .txt files) that contain the required data structures in the Stage File actions for reading and writing files.

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 3.

System and Access Requirements

  • Oracle Integration, Version 24.04 or higher

  • A secure FTP (sFTP) server or File Server

  • An FTP client to access the external sFTP server