From the course: Oracle DB Cloud Database Migration and Integration Workshop

Unlock this course with a free trial

Join today to access over 23,300 courses taught by industry experts.

Oracle Data Integrator

Oracle Data Integrator

From the course: Oracle DB Cloud Database Migration and Integration Workshop

Start my 1-month free trial Buy for my team

Oracle Data Integrator

“

Welcome to Oracle University's lesson: Oracle Data Integrator. I'm your host, Naji. Let's get started. In this lesson, I'm going to show you basics of data integration and transformation, ELT architecture, ODI design, followed by the source and target connectivity, ODI platform, ODI evolution, ODI listings in OCI Marketplace and its use cases. Data source is really in the form useful for target applications. For example, data gets generated in various ERP systems, marketing, CRM, etcetera. Nowadays, there are other data sources as well from social media, IoTs, etcetera. Now, in order to make use of this data, the data needs to be moved to some other place where we are going to do something else with it. For example, analytics. In this case, we are transporting the data into a different physical location. Also, the data as it is not very useful, needs to be transformed into something, for example for warehousing purposes. In that case, data may need to be joined with each other…

Contents