Oracle Data Integrator Essentials
What you'll learn
- Get to know the difference between ETL and ELT
- Find out how to make the best use of ODI objects such as joins, datasets, filters, and sequences
- Build workflows based on packages to execute a process
- Define your strategy with Knowledge Modules and adapt these module to your needs
- Create reusable pluggable procedures for recurring tasks
- Perform your daily tasks such as administration, maintenance, and deployment easily
- Understand how the architecture of ODI can be set up and how and where ODI stores its metadata
- Comprehend the use of scenarios as the smallest deployments units in ODI
- Discover how solutions are used to resolve dependencies between different ODI objects
Course content
- Preview02:53
- 01:42Differentiating between ETL and ELT
- 04:38Exploring the Graphical UI
- 08:00ODI Basics
- Preview02:53
- 04:09The ODI Staging Area
Requirements
- A practical guide bursting with tips and real-world best practices to get you on your way with Oracle Data Integrator and help you make the most of this tool.
Description
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.
Who this course is for:
- If you are a database administrator or data warehouse developer wanting to broaden your skills in data integration tasks and transformations using Oracle Data Integrator, this is the course for you.
Instructor
![Packt Publishing](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 3.9 Instructor Rating
- 57,914 Reviews
- 349,095 Students
- 1,420 Courses
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.