Mastering Oracle Data Integrator (ODI)

Explore how ODI handles data integration scenarios across data warehouses, data lakes, cloud, and real-time pipelines, powering ETL, data quality, and master data management.

Explore how ETL and ELT tools consolidate dispersed data across applications and data warehouses to enable centralized data integration, coherence, and sharing of information across entities with ODI and MDM.

Explore the Oracle Data Integrator 12c architecture, including the repository, ODI Studio, ODI Agent, ODI Web Console, master and work repositories, security, and the OEM plugin for monitoring ODI environments.

Explore the ODI product architecture, from the studio to the repository and the agent, which orchestrates task execution, updates the repository with results, and reports metrics like rows processed.

Explore the ODI Studio core tools, focusing on the security navigator and topology navigator to empower developers and operators to manage roles, credentials, and system declarations for seamless data integration.

Explore the designer navigator and operator navigator in ODI Studio, importing and enriching metadata, defining mappings and workflows, and orchestrating packages for data integration.

Master ODI agent orchestrates data integration by executing processes from studio, console, command line, or web service, with schedules tied to agents for seamless ETL workflow control.

Explore the topology navigator to understand execution contexts in ODI, mapping logical schemas to physical schemas across development, production, and test, and using the reverse engineer feature to retrieve metadata.

Master ODI knowledge modules (KMS) scaffold code templates for data integration, boosting productivity and enabling customization with six module types (LCM, IKM, CM, RCM, JQM, SKM) and CDC/web services support.

Explore ODI models as repositories for database metadata, enabling selective import, organized structures, diagrams to design tables, translate data types, and generate mappings for streamlined data integration.

Explore how mappings in Oracle Data Integrator 12c orchestrate data extraction, transformation, and loading, with visual diagrams and drag-and-drop tools to design data flows.

Explore how ODI 12c packages orchestrate data integration workflows. Discover reusable containers for mappings, procedures, and scenarios, with parameters and diagrams to design robust workflows.

Define and use variables in Oracle Data Integrator to create dynamic integration processes. Infuse variables into models, mappings, packages, and load plans to adapt workflows.

Associate variables with single-value SQL queries in Oracle Data Integrator to refresh at runtime, automatically assign results, and review history for debugging and analysis.

Explore how variables in ODI extend models to handle dynamic flat-file names, enabling a variable-driven resource name alongside a meaningful environment identifier in the model tree.

Explore variables inside an ODI package by inspecting the designer module, mappings, and scenarios. See how variable values flow through steps with true or false evaluations guiding dynamic control flow.

Watch a demonstration on mastering variables and packages in Oracle Data Integrator (ODI). Gain practical techniques for using variables and organizing packages.

Explore ODI sources, targets, and knowledge modules; define physical schemas through topology navigator contexts. Reverse engineer metadata from databases and flat files, understand ODI data flow, and select knowledge modules.

Link physical and logical schemas through a context and environment alias in ODI to drive models and mappings, aligning source_db_employee with source_db.APS and target_db_employee with target_db.EDW in the global context.

Reverse engineer metadata to create ODI models that are abstract, platform-independent, and aligned with the topology, enabling accurate, seamless integration across databases, files, JMS, and queues.

Reverse engineer metadata from the Oracle employee table into an ODI model, then view data to validate the source structure for data integration.

Master customized reverse engineering in ODI using reverse engineering knowledge modules (rcms) to access system tables and extract metadata, enabling E-Business suite, PeopleSoft, JD Edwards, SAP, Siebel, and Hyperion.

Show how to load data from MySQL and a pricing correction dot txt file into an Oracle order summary using lcm and ikm, then append to order summary dot csv.

Learn how to import knowledge modules in ODI by selecting KMS in the knowledge modules node and completing the import dialog; explore CMS, editor, and step details.

Explore ODI sources and targets, configure knowledge modules, and learn to work with databases to streamline data integration workflows.

Explore data integration between MySQL and Oracle Database with Oracle Data Integrator, focusing on product, category, and warehouse stock tables and data synchronization.

Configure ODI studio to create MySQL and Oracle data servers, supply credentials and jdbc details, test connections, and enable seamless data integration between source MySQL and target Oracle.

Navigate ODI topology to create a new physical schema and a corresponding logical schema for the MySQL data server, configuring catalogs and the logical schema name.

Build and reverse engineer ODI models by selectively reverse engineering MySQL tables in ODI studio, then reverse engineer Oracle tables into a target datamart for data integration.

Create a mapping named load underscore product in ODI Studio, connect MySQL source tables to the target data mart, and run the mapping with default execution parameters.

Configure a Microsoft SQL Server data source in ODI, build source and target models, design an incremental load mapping with Ikm for incremental update and staging data, and simulate session.

Monitor ODI session executions with the operator navigator in ODI Studio, review execution status and logs, and verify data migration to the target sale_underscore_person table.

Explore how to demonstrate ODI workflows by connecting and working with MySQL and Oracle databases, highlighting integration strategies within Oracle Data Integrator.

Load the partners.txt flat file into oracle data warehouse table using odi, configure topology and data servers for flat file and oracle, and apply lcm and ikm for incremental updates.

Learn to create and run mappings in ODI, connect a flat file source to an Oracle target, configure IKM and LCM, and monitor execution to validate data loading.

Demonstrate integrating file data with Oracle Data Integrator (ODI) through a hands-on demonstration, illustrating data flow, source configuration, and file format handling.

Create and orchestrate ODI workflows and load plans by building packages with variables and data pipelines, executing steps sequentially, generating and running scenarios, and monitoring real-time data loads.

Join a demonstration on creating workflows in ODI, focusing on building packages and load plans to orchestrate efficient data processes.

Load data into a slowly changing dimension table in ODI, configuring the employee_scd target with is current flag, starting timestamp, ending timestamp, and effective date columns.

Create a mapping named load_employee_sqd in ODI designer to load data into slowly changing dimension employee_sqd, using IKM Oracle slowly changing dimension and ski column from Sysdate, then run.

Monitor ODI sessions using the operator navigator to review execution status and logs, verify results, and confirm slowly changing dimension data movement from source to target.

Explore Oracle GoldenGate, a real-time data integration and replication solution that moves data across heterogeneous systems with transactional consistency, enabling high performance, bidirectional replication, and near-zero downtime.

See how Oracle GoldenGate captures real-time changes from the Temenos core banking system and streams them to staging, while ODI uses CDC-based ETL and XML parsing for the ODS.

Learn essential Oracle GoldenGate commands to manage the integration. Start Ghci, connect to the manager, and control extract, pump, and replicate processes, view statuses, and trail files.

Explore essential Oracle GoldenGate commands to register and configure an extract process, capture real-time transaction changes, manage the trail, view parameters, and start the extract in a live demo.

oracle golden gate demonstrates real-time data replication from source t24 uat db.t24 master.php and k__customer_card to target audit_uat_stg.fbnc_be_customer_card, keeping customer 10995418's type prospect a in sync.

Enable change data capture with Oracle ODI CDC on the audit UAT schema and start journaling. Configure ODI models and verify CDC setup for the replication to the ODS target.

Set up Oracle ODI for CDC real-time movement from staging to the operational data store, creating the model, configuring mappings, and monitoring the package to ensure accurate replication.

Master real-time ETL with change data capture (CDC) and Oracle Golden Gate (OGG) in ODI, part 1.