- 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.