Create an Integration to Import and Process Bulk Files

In this tutorial, you’ll learn how to create a scheduled integration in Oracle Integration to load and transform files from a secure File Transfer Protocol (FTP) location.

For the purpose of this tutorial, let’s consider a simple use case where you’ll require to communicate with an external application through an FTP server, import raw data, and convert it into a standard format. The flow for this scenario is as follows:

1. A user or an application uploads a file or set of files to an FTP server for processing.
2. The scheduled integration imports these files into Oracle Integration using an FTP Adapter.
3. Using a set of relevant of actions, the integration transforms or enriches the data within the files and uploads the modified files back to the FTP server.

Upon completing this tutorial, you’ll be familiar with several important skills in Oracle Integration, such as configuring an FTP Adapter, iterating over repeating elements, staging files, mapping data, and creating schedules.

Topics:

1. Prerequisites to Set Up the Integration

2. Access Your FTP Server and Upload the File

3. Create an FTP Connection

4. Create a Scheduled Integration

5. Configure an FTP Adapter to Download the Zip File

6. Add a For-Each Action to Iterate Over Individual Files

7. Configure a Stage File Action to Read Individual Files

8. Add a For-Each Action to Iterate Over Individual Records

9. Add a Stage File Action to Write Modified Records into a New File

10. Configure Data Mapping to Transform Data in Files

11. Add a Stage File Action to Zip the Modified Files

12. Configure an FTP Adapter to Write the Modified Zip File

13. Activate and Test Your Integration

14. Create a Sample Schedule