ODI 11g & 12c (Oracle Data Integrator) Training
Viswa Online Trainings is one of the world’s leading online IT training providers. We deliver a comprehensive catalog of courses and online training for freshers and working professionals to help them achieve their career goals and experience our best services.
Learners : 1080
Duration : 30 Days
About Course
Our ODI 11g & 12c (Oracle Data Integrator), the latest version of Oracle’s strategic Data Integration offering, provides superior developer productivity and improved user experience with a redesigned flow-based declarative user interface and deeper integration with Oracle GoldenGate.
ODI Training Course Syllabus
✔ ETL And ELT Architectures
✔ Introduction To ODI
✔ ODI Components
✔ Topology Manager
✔ Repositories
✔ Master Repository
✔ Work Repository
✔ Physical and Logical Architectures
✔ Data servers
✔ Schema
✔ Agents
✔ Contexts
✔ Security Manager
✔ Users
✔ Hosts
✔ Objects
✔ Profiles
✔ Designer
✔ Models
✔ Projects
✔ Variables
✔ Sequences
✔ User Functions
✔ Knowledge Modules
✔ Markers
✔ Interfaces
✔ Packages
✔ Procedures
✔ Others
✔ Global Variables
✔ Global Sequences
✔ Global User Functions
✔ Global Markers
✔ Operator
✔ Session List
✔ Hierarchical Sessions
✔ Scheduling
✔ Scenarios
✔ Creating mappings with different scenarios
✔ ODI Setup
✔ ODI Installation
✔ Creation of DB Schemas for repositories
✔ Creation of Master Repository
✔ Creating a Connection to Master Repository
✔ Creation of a Work Repository
✔ Topology-Connection Creation
✔ Creation of a Context
✔ Creation of Data Servers
✔ Creation of Physical & Logical Schema
✔ Creation of Physical and Logical Agents
✔ Grouping Logical schema & logical Agents with the Context
✔ Designer
✔ Creation of Data Models
✔ Importing Source and Target tables metadata
✔ Creation of an ODI Project
✔ Importing Required Knowledge modules
✔ Creation of an Interface
✔ Mapping Source and Target columns in the Interface
✔ Creating a Scenario
✔ Executing the interface
✔ Operator
✔ Monitoring the Session Logs
✔ Knowledge Modules
✔ Reverse-Engineering Knowledge Modules (RKM)
✔ Check Knowledge Modules (CKM)
✔ Load Knowledge Modules (LKM)
✔ Integration Knowledge Modules (IKM)
✔ Journalizing Knowledge Modules (JKM)
✔ Service Knowledge Modules (SKM)
✔ Working with
✔ Filters
✔ Joins
✔ Procedures
✔ Functions
✔ Variables
✔ Sequences
✔ Set Operations
✔ Lookup
✔ Scheduling
✔ ODI Tools
✔ OS Command
✔ OdiBeep
✔ OdiSendMail
✔ OdiSleep
✔ OdiStartScen
✔ OdiWaitForData
✔ SCD Types Understanding
✔ SCD Type-1
✔ SCD Type-2
✔ SCD Type-3
✔ Load Plans
✔ Import/export & versioning
✔ Case Studies
✔ BI APPS Understanding
Live Instructor Based Training With Software |
Lifetime access and 24×7 support |
Certification Oriented content |
Hands-On complete Real-time training |
Get a certificate on course completion |
Flexible Schedules |
Live Recorded Videos Access |
Study Material Provided |
ODI Training - Upcoming Batches
Coming Soon
8 AM IST
Coming Soon
AM IST
Coming Soon
8 AM IST
Coming Soon
AM IST
Don't find suitable time ?
CHOOSE YOUR OWN COMFORTABLE LEARNING EXPERIENCE
Live Virtual Training
-
Schedule your sessions at your comfortable timings.
-
Instructor-led training, Real-time projects
-
Certification Guidance.
Self-Paced Learning
-
Complete set of live-online training sessions recorded videos.
-
Learn technology at your own pace.
-
Get access for lifetime.
Corporate Training
-
Learn As A Full Day Schedule With Discussions, Exercises,
-
Practical Use Cases
-
Design Your Own Syllabus Based
ODI Online Training FAQ'S
Oracle acquired Sunopsis in 2006 and with it “Sunopsis Data Integrator”.
Oracle Data Integrator (ODI) is an E-LT (Extract, Load and Transform) tool used for high-speed data movement between disparate systems.
The latest version, Oracle Data Integrator Enterprise Edition (ODI-EE) brings together “Oracle Data Integrator” and “Oracle Warehouse Builder” as separate components of a single product with a single license.
Our Page: VISWA Online Trainings
ELT is an innovative approach to extracting, loading, and Transforming data. Typically ETL application vendors have relied on costly heavyweight, mid-tier servers to perform the transformations required when moving large volumes of data around the enterprise.
ODI delivers unique next-generation, Extract Load and Transform (ELT) technology that improves performance and reduces data integration costs, even across heterogeneous systems by pushing the processing required down to the typically large and powerful database servers already in place within the enterprise.
“Oracle Data Integrator” comprises of:
1) Oracle Data Integrator + Topology Manager + Designer + Operator + Agent
2) Oracle Data Quality for Data Integrator
3) Oracle Data Profiling
Oracle data integration suite is a set of data management applications for building, deploying, and managing enterprise data integration solutions:
- Oracle Data Integrator Enterprise Edition
- Oracle Data Relationship Management
- Oracle Service Bus (limited use)
- Oracle BPEL (limited use)
- Oracle WebLogic Server (limited use)
Additional product options are:
- Oracle Goldengate
- Oracle Data Quality for Oracle Data Integrator (Trillium-based DQ)
- Oracle Data Profiling (Trillium based Data Profiling)
- ODSI (the former Aqualogic Data Services Platform)
ODI offers a unique design approach through the use of Contexts and Logical schemas. Imagine a development team, within the ODI Topology manager a senior developer can define the system architecture, connections, databases, data servers (tables, etc), and so forth.
These objects are linked through contexts to ‘logical’ architecture objects that are then used by other developers to simply create interfaces using these logical objects, at run-time, on the specification of a context within which to execute the interfaces, ODI will use the correct physical connections, databases + tables (source + target) linked the logical objects being used in those interfaces as defined within the environment Topology.