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.
- An adapter reads a trigger file from an FTP server using an existing FTP connection.
- 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.
- 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.
- A stage file action creates a list file identifying the available formatted file or files and assigns those values for use.
- 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.
- A map and an adapter action write the composite ZIP file to an FTP location for archive or reuse.
- A map and an adapter action write the trigger file to an FTP location for archive or reuse.