Today, let's explore the Data Loader Task in Oracle Cloud Infrastructure Data Integration. The Data Loader Task enables the use-cases where one to one loading of data is required between two systems with minimal/no transformations. This task is required for Data Preparation, Data Migration, or for loading diverse data into Data Lakes like Oracle Object Storage.
With the Data Loader Task, the entire process is now done with few clicks without worrying about the complexity of the underlying steps. All the user needs to do is create a Data Loader Task, which entails having to specify the source and target with the option to specify transformations, publish and run it. Let us consider an example where data is loaded from Oracle Database to Autonomous Data Warehouse (ADW). Here in this use case, the following are the steps performed to load table data from Oracle Database to ADW.
After running the task the executed jobs can be seen under Task Runs with the number of processed records, Duration, Executed By, Execution Date, etc.
As shown above, the Data Loader Task has drastically simplified the loading of the data between two systems. Now, users can implement such an end-to-end scenario without needing deep data integration expertise.
Have you seen some of our other blogs? Check out all the blogs related to Oracle Cloud Infrastructure Data Integration - https://blogs.oracle.com/dataintegration/oracle-cloud-infrastructure-data-integration. To learn more, check out some Oracle Cloud Infrastructure Data Integration Tutorials and Documentation.