Mastering Oracle Data Integrator (ODI)
Focused View
Dien Pham,Quan Pham
6:31:12
9 View
1. Introduction.mp4
04:28
2.1 Mastering Oracle Data Integrator (ODI) - Comprehensive ETL and Data Integration v1.0.pdf
2. Materials.html
1. Data integration usage scenarios.mp4
05:44
2. ODI Product Overview.mp4
03:47
3. ODI product architecture - Part 1.mp4
04:21
4. ODI product architecture - Part 2.mp4
03:23
5. ODI product architecture - Part 3.mp4
05:42
6. ODI Studio - Part 1.mp4
03:24
7. ODI Studio - Part 2.mp4
04:20
8. ODI Agent.mp4
04:01
9. WebLogic Enterprise Manager.mp4
02:50
10. Execution Context - Part 1.mp4
04:54
11. Execution Context - Part 2.mp4
04:14
12. Knowledge Modules.mp4
05:27
13. Models.mp4
04:16
14. Mappings.mp4
03:56
15. Packages & Scenarios.mp4
04:11
16. Connect to Repository.mp4
03:32
17. Demonstration Introduction to Oracle Data Integrator (ODI).mp4
11:28
1. Variable location and scopes.mp4
02:32
2. Refreshing variables.mp4
02:56
3. Assigning a value to a variable.mp4
02:43
4. Referencing variables.mp4
01:46
5. Variables in models.mp4
01:39
6. Variables utilization in Package.mp4
03:21
7. Demonstration Mastering Variables and Packages.mp4
14:20
1. ODI Sources, Targets, and Knowledge Modules.mp4
03:23
2. Defining physical data servers.mp4
02:53
3. Defining Physical Schemas (Data Sources).mp4
03:04
4. Defining Physical Schemas (Target Data Source).mp4
01:14
5. Defining Logical Schemas and Contexts.mp4
01:59
6. Reverse-engineering metadata into ODI models.mp4
02:07
7. Reverse-engineering metadata into ODI models -Example.mp4
03:01
8. Custom reverse-engineering.mp4
01:52
9. Knowledge Modules Using Example.mp4
05:56
10. Detail Importing a Knowledge Module.mp4
04:25
1. Topology configuration - Data Server, Schema, Model Reverse Engineering.mp4
05:44
2. Create project & Do ODI Mappings.mp4
02:42
3. Perform moving the data using an ODI Mappings.mp4
05:18
4. Operator Navigator - Monitor ODI Mappings process.mp4
02:46
5. Demonstration ODI Sources, Targets, and Knowledge Modules & Working with Databa.mp4
28:00
1. Source MySQL Table example.mp4
02:37
2. Create Data Server on Source and Target.mp4
02:15
3. Physical Schema, Logical Schema.mp4
01:57
4. Reverse Engineering Models.mp4
04:08
5. Mappings.mp4
02:48
6. Monitor Mappings running process - Operator Navigator.mp4
02:28
7. MSSQL Database Loading by using ODI.mp4
04:57
8. MSSQL Loading Monitor - Operator Navigator.mp4
02:00
9. Demonstration Working with Specific Databases - Microsoft SQL Server & Oracle.mp4
35:19
10. Demonstration Working with Specific Databases - MySQL & Oracle.mp4
22:43
1. File Loading by using ODI - Topology Configuration.mp4
04:54
2. File Loading by using ODI - Mapping Running and Monitoring.mp4
03:13
3. Demonstration Integrating File Data.mp4
13:16
1. Packages and Load Plans - Mastering Workflows.mp4
08:25
2. Demonstration Creating Workflows Packages and Load Plans.mp4
09:07
1. Slowly Changing Dimension Configuration.mp4
03:38
2. Slowly Changing Dimension Mapping.mp4
03:27
3. Slowly Changing Dimension - Running and Monitoring.mp4
04:38
4. Demonstration ODI ETL with Slowly Changing Dimension (SCD).mp4
18:10
1. Oracle GoldenGate Overview.mp4
04:03
2. Oracle GoldenGate Example with Core Banking System.mp4
05:21
3. Oracle GoldenGate Commands.mp4
07:02
4. Oracle GoldenGate - Demo Extract Process.mp4
03:41
5. Oracle GoldenGate - Demo Pump Process.mp4
03:59
6. Oracle GoldenGate - Demo Replicate Process.mp4
02:58
7. Oracle GoldenGate - Results.mp4
01:44
8. Oracle ODI CDC.mp4
04:51
9. Oracle ODI CDC Realtime Movement.mp4
07:28
10. Real-time ETL with Change Data Capture (CDC) and Oracle Golden Gate (OGG)-Part 1.mp4
08:51
1. Recap what have you learnt!.mp4
03:35
Description
Comprehensive ETL, Data Integration and Change Data Capture (Oracle Golden Gate)
What You'll Learn?
- Gain expertise in Oracle Data Integrator (ODI) and its architecture
- Master the use of variables, packages, and workflows for effective data integration
- Learn to work with diverse databases, including MySQL, Microsoft SQL Server, Oracle Database
- Understand handling flat files and integrating file data in ODI
- Learn to work with Slowly Changing Dimension (SCD) techniques in ODI
- Explore real-time ETL through Change Data Capture (CDC) and Oracle GoldenGate
- Acquire practical skills for building ETL mappings, monitoring operations, using ODI for comprehensive data integration
Who is this for?
What You Need to Know?
More details
DescriptionThe "Mastering Oracle Data Integrator (ODI) - Comprehensive ETL and Data Integration" course is designed for individuals aspiring to excel in data integration and ETL processes. Throughout the course, participants will explore ODI's robust features, enabling them to create and manage ETL mappings efficiently. They will learn to define schemas, work with contexts, and reverse-engineer metadata into ODI models. Practical demonstrations will cover variable usage, package creation, and working with Knowledge Modules (KMs) for optimized data processing.
The course includes a detailed exploration of working with specific databases such as MySQL, Microsoft SQL Server and Oracle Database, along with integrating file data seamlessly. Participants will master the intricacies of creating workflows, including packages and load plans, ensuring streamlined ETL processes. Furthermore, the course provides a comprehensive understanding of Slowly Changing Dimensions (SCD), a crucial aspect of data warehousing.
A key focus is on real-time ETL using Change Data Capture (CDC) and Oracle GoldenGate. Participants will gain hands-on experience with CDC configurations and leveraging Oracle GoldenGate for real-time data replication. This comprehensive curriculum ensures that learners develop a proficiency in orchestrating end-to-end ETL processes, making them adept in data integration tasks across diverse database environments. Upon completion, participants will possess the skills to implement efficient and real-time data integration solutions, positioning them as valuable professionals in the realm of data management and analytics.
Who this course is for:
- Database developers and administrators seeking to master Oracle Data Integrator (ODI) for comprehensive ETL and data integration
- Data engineers and integration professionals looking to enhance their skills in real-time data movement and replication
- Business intelligence professionals or data architect aiming to leverage ODI for efficient data warehousing solutions
- Data Engineer interested in mastering Slowly Changing Dimensions (SCD) and Change Data Capture (CDC) techniques
- Data Engineer aspiring to implement real-time ETL using Oracle GoldenGate in conjunction with ODI
- Students and professionals aiming to advance their careers in data management and integration
The "Mastering Oracle Data Integrator (ODI) - Comprehensive ETL and Data Integration" course is designed for individuals aspiring to excel in data integration and ETL processes. Throughout the course, participants will explore ODI's robust features, enabling them to create and manage ETL mappings efficiently. They will learn to define schemas, work with contexts, and reverse-engineer metadata into ODI models. Practical demonstrations will cover variable usage, package creation, and working with Knowledge Modules (KMs) for optimized data processing.
The course includes a detailed exploration of working with specific databases such as MySQL, Microsoft SQL Server and Oracle Database, along with integrating file data seamlessly. Participants will master the intricacies of creating workflows, including packages and load plans, ensuring streamlined ETL processes. Furthermore, the course provides a comprehensive understanding of Slowly Changing Dimensions (SCD), a crucial aspect of data warehousing.
A key focus is on real-time ETL using Change Data Capture (CDC) and Oracle GoldenGate. Participants will gain hands-on experience with CDC configurations and leveraging Oracle GoldenGate for real-time data replication. This comprehensive curriculum ensures that learners develop a proficiency in orchestrating end-to-end ETL processes, making them adept in data integration tasks across diverse database environments. Upon completion, participants will possess the skills to implement efficient and real-time data integration solutions, positioning them as valuable professionals in the realm of data management and analytics.
Who this course is for:
- Database developers and administrators seeking to master Oracle Data Integrator (ODI) for comprehensive ETL and data integration
- Data engineers and integration professionals looking to enhance their skills in real-time data movement and replication
- Business intelligence professionals or data architect aiming to leverage ODI for efficient data warehousing solutions
- Data Engineer interested in mastering Slowly Changing Dimensions (SCD) and Change Data Capture (CDC) techniques
- Data Engineer aspiring to implement real-time ETL using Oracle GoldenGate in conjunction with ODI
- Students and professionals aiming to advance their careers in data management and integration
User Reviews
Rating
average 0
Focused display
Category
Dien Pham
Instructor's CoursesI am an experienced and accomplished author with a deep passion for data strategy and management. With over 15 years of hands-on experience in the IT industry, I have gained extensive knowledge and expertise in various domains, including banking, insurance, retail, and more.Throughout my career, I have held several senior positions such as:- Data Division Director of an insurance company- Deputy Data Governance & Analytics of the Group (Real Estate, Retail, Hospitality, Commerce, ...)- Deputy Chief Data Officer cum Senior IT Strategy Expert- Head of Data & Analytics Service- Project Director/ Project Manager- Enterprise & Solution Architect of bankThat have allowed me to make significant contributions to the field. And right now, as a director of Data Division, I played a pivotal role in shaping data initiatives and driving the effective use of data within organizations. Additionally, as a Data Governance & Analytics expert, I focused on establishing robust data governance frameworks and harnessing the power of analytics to drive actionable insights.With my diverse background and extensive industry experience, I have developed a strong understanding of the challenges and opportunities in the data management landscape. Through my work as an author, I am dedicated to sharing my knowledge, insights, and practical strategies with students like you.
Quan Pham
Instructor's CoursesData expert with 15 yeas experience in banking industry.Data engineer for banking industry.With 15 years working as IT expert in banking, data engineer, I have gained extensive knowledge and expertise in data domain.Focusing on building data architecture, data model (data warehouse/datalake) and integrating between variuos system in banking, e.x configurate ETL system, ETL pipeline for datawarehouse, datalake for bankingExperience with modern data technologies: datalake, datavaults, data opps, bigdata processing, data processing on cloud...
Udemy
View courses UdemyStudents take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.
- language english
- Training sessions 70
- duration 6:31:12
- Release Date 2024/04/14
