The diagram shows an orchestration pattern for importing and converting large data files from third-party sources for use with Oracle Cloud ERP. The orchestration is a linear process divided into seven stages.

  1. An adapter reads a trigger file from an FTP server using an existing FTP connection.
  2. A map identifies the location and schema of the file-based data import (FBDI) file. An adapter copies the file to Oracle Integration and assigns file name and location values.
  3. An outer loop with a stage file action iterates through the each of the data files, while an inner loop iterates through each record of a given file to identify the number of, and create, the corresponding formatted files. Map and stage file actions create a directory for the individual files.
  4. A stage file action creates a list file identifying the available formatted file or files and assigns those values for use.
  5. A loop iterates through the list file, assigning and mapping individual data files and their corresponding properties (manifest) files. A stage file action creates the files and an adapter action stages the resulting files.
  6. A map and an adapter action write the composite ZIP file to an FTP location for archive or reuse.
  7. A map and an adapter action write the trigger file to an FTP location for archive or reuse.