Oracle Data Integrator (ODI) is Oracle’s strategic tool covering all your data integration requirements. ODI lets you write custom code easily, extract data from source files, transform data in a staging area, and load this data to your target database. So, if you are a database administrator with an aim to effectively use ODI as a powerful tool for data integration solutions, it’s time you started making the most of it. This video course will show you how to use ODI for your data transformation and integration projects. It will also provide you with valuable input on which methods to use for various ODI objects according to the situation, with examples based on real-life requirements. Covering all the key ODI concepts, this video course shows you how to make the best use of ODI’s declarative approach to define your strategy with Knowledge Modules. First, you are made familiar with the basics of ETL processes and then learn how to use of ODI development objects with the help of practical examples. You then move on to get an understanding of ODI’s transformation vehicles and its interface, followed by how ODI packages can be used to develop more workflow-based data integration tasks. Next we show you how reusable objects can be customized by using variables to suit your needs. The following sections broaden your understanding of topologies, scenarios, load plans, and data integration solutions. By the end of the course, you will have enough knowledge of ODI, development, deployment, and maintenance techniques to give you the confidence to develop your own data integration projects.
Understand the use of ODI as a tool to make your data integration tasks easier.
Avoid ETL, let the database work and use ELT.
Familiarize yourself with the graphical interface of ODI Studio.
Knowing the ODI basics helps you know where you can find what you need to find in ODI.
Strategy is contained in Knowledge Module (KM); so, what are these KMs?
ODI uses temporary objects but where to store them is the question. We'll answer it in this video.
Here you'll get to know when you need to use a project and when you need to use a folder.
The basic element of your transformation is the interface. Get to know what are the components of this interface.
Objects are necessary to develop projects properly in ODI. Learn how you can make the best use of these objects.
For some data transformation tasks, it's mandatory to cascade your interfaces by using temp interfaces. In this video, you'll understand how to use these interfaces.
You need to adjust KMs so that they fit to your strategy by learning how to adapt them.
You always need agents for ODI to be able to execute in ODI Interfaces.
Execution locations have huge impacts on transactions. In this video, you will learn how to execute a mapping on other locations.
You need to execute a process which contains dependencies by learning how to create a workflow in ODI.
Reusability is needed especially if you have a recurring task. Procedures help you with this.
If you need to have enhancements to your KMs, user functions can be really useful. Learn how to use them.
The function of one use case should differ from another use case. This is where customization comes into action.
DQ is very important and in this video you will learn how to use different data quality tools.
Get to know how to use data integrity controls and how you can embed data quality in ODI with the help of packages.
Learn how to load only delta, which is the data that is changed in ODI.
All the ODI versions are stored in the master and the actual version is stored in the work repository. In this video, we will see what can be versioned in ODI.
Smallest deployment units are scenarios. In this video, you'll learn what can be deployed to become a scenario.
Dependencies between different ODI objects need to be resolved. We'll see how "Solutions", which are release bundles, can be used to resolve this.
How do you do that in ODI?
Sometimes you have load dependencies, for which you need to know how to use loadplans to build the process for loading data.
Some of the ODI metadata is not displayed in the GUI, but you can get it from the ODI repository tables.
In ODI, you can grant generic or nongeneric privileges. Get to know how you can do this.
Many of the tasks in ODI are recurring. Learn how you can use some scripting in ODI to generate similar objects.
To estimate future changes, impact and data lineaging is important. Know how this is done.
ODI Studio is the main place where ODI developers work. Familiarize yourself with its additional features.
Packt has been committed to developer learning since 2004. A lot has changed in software since then - but Packt has remained responsive to these changes, continuing to look forward at the trends and tools defining the way we work and live. And how to put them to work.
With an extensive library of content - more than 4000 books and video courses -Packt's mission is to help developers stay relevant in a rapidly changing world. From new web frameworks and programming languages, to cutting edge data analytics, and DevOps, Packt takes software professionals in every field to what's important to them now.
From skills that will help you to develop and future proof your career to immediate solutions to every day tech challenges, Packt is a go-to resource to make you a better, smarter developer.
Packt Udemy courses continue this tradition, bringing you comprehensive yet concise video courses straight from the experts.