• Full package for ETL
  • Automation tool: UC4
  • RMS Server
  • Database
    • These work together; ODI isn’t standalone.
    • All stuffs may be installed in the same RMS server.

Jobs

  • Handled by (ksh) scripts to run different jobs

UC4

  • Scheduler
  • Agent: defined in uc4 to connect to RMS server.
    • defines path of scripts

ODI agent

  • Connect between server & ODI
  • Can also automate UC4 tasks in newer versions.

Architecture

Design

  • Mapping
  • Transform
  • Making of Project

Operator

  • Logging
  • Status of jobs

Topology

  • Defining connections : physical and logical
  • Physical connections ==> Mapped to logical connections
  • Data model ==> Map table columns to table columns and so on.
  • Data Models

    • Sub Folders and data stores
    • Reversing: Ability to sync between data models and database tables

Security

  • Restrict access to Design, Operator, Topology

Metadata Repo

  • Multiple work repository: custom and so on
    • Changes from base into different place so as to debug with ease
    • Good documentation for Base Model
  • Master repo : One
    • Generally not used
    • Mainly for permission related issues.

Console - work in unix the same commands as studio