Recently, we encountered the need to import data from data files supplied by a third-party cloud system for financial reporting. Following a thorough evaluation of potential solutions, the approach we implemented involves:
- Establishing a dedicated SFTP server and instructing the data provider to upload the required data files.
- Creating an Oracle Data Integrator (ODI) flow to retrieve data files from the SFTP server and load them into a locally hosted server within Oracle Cloud Infrastructure (OCI). In the event of file reading errors, an email notification is automatically sent to the support team.
- Designing a second ODI flow to extract data from the files and populate custom tables set up in Autonomous Data Warehouse (ADW).
- Archiving processed files upon successful completion of the data loading process."
No comments:
Post a Comment