Oracle Data Integrator (ODI) is – product from Sunopsis acquired by Oracle in 2006 and now part of Oracle Fusion Middleware Family.
1. ODI is built on E-LT(Extract , Load and Transform) Architecture.
2. Oracle Data Integrator 10g (10.1.3.5.0) suite includes three products
a) Oracle Data Integrator
b) Oracle Data Quality and
c) Oracle Data Profiling
3. ODI uses Database as ETL (Extract, Transform & Load) engine thus eliminates requirement of proprietary ELT engine
4. Oracle Data Integrator Enterprise Edition (ODIEE) is combination of ODI (Oracle Data Integrator) and OWB (Oracle Warehouse Builder)
Oracle Data Integrator Architecture
Oracle Data Integrator (ODI) consists of following products
1. Repository – is relational Databases to store objects used/configured or developed by ODI. There are two type of Repository Master Repository (one and only one) and Work Repository (one or more)
a) Master Repository – There is only one Master repository and used to store security information, topology information (servers..) and versions of the Objects. All Modules (designer, operator, topology & security) have access to master repository.
b) Work Repository– Work related objects (project objects) are stored in Work Repository like Models, Projects and run-time information. There could be multiple work repository per installation and all linked to single master repository. Work Repository is accessed by Designer/Operator Module and run time agent.
2. Graphical Modules –
a) Designer (designer.sh|bat)– All project development takes place in this module and this is the place where database and application metadata are imported and defined.
b) Operator (operator.sh|bat) – usually to monitor production ODI instance and shows execution logs, rows processed and execution statistics
c) Topology Manager (topology.sh|bat)– To register servers, schema and agents in master repository.
d) Security Manager (security.sh|bat) – To manage user profiles and their access privileges.
3. Runtime Component / Scheduler Agent – scheduler agent coordinates execution of scenarios. Scheduler Agent retrieves code from execution repository and then requests database server, scripting engine or operating system server to execute that code.
4. Metadata Navigator (MN)– is Web (JSP/Servlet) application (available as oracledimn.war) that enables access to repository through Web Interface (Web Browser). MetaData Navigator (MN) requires Application Server and you deploy MN application oracledimn.war on pre-installed application server (Tom Cat, OAS, WebLogic). This is optional component.
ODI Server Installation
1. Download ODI 10.1.3.4 software from here
2. Unzip software
3.Start Installation using $unizp_location/ setup/ <your_os>/ Disk1/ install/ runInstaller or
$unzip_location/ setup/ <your_os>/ setup.sh for Unix or setup.exe for windows
4. Select a product to install, options are
a) Oracle Data Integrator, Oracle Data Profiling, Oracle Data Quality
b) Oracle Data Integrator
c) Oracle Data Profiling
d) Oracle Data Quality for Oracle Data Integrator
5. Select Installation Type , options are (depending on above selection)
a) Complete – covers client and server components for ODI Suite
b) Client – User Interfaces for ODI suite
c) Server – run time agent for ODI, Metabase and Servers for Data Profiling and Data Quality
6. Specify Oracle Home – location to install ODI software binaries (code set)
7. Provide repository & Schedule Port and UserName password to administer Repository – This step is applicable only for option b), c) or d) from 4) Select a product to install
8. Run root.sh from root account (on Unix environment)
ODI Metadata Navigator Installation
Metadata Navigator (MN) is Web (JSP/Servlet) application (available as oracledimn.war) that enables access to repository through Web Interface (Web Browser). MetaData Navigator (MN) requires Application Server and you deploy MN application oracledimn.war on pre-installed application server (Tom Cat, OAS, WebLogic).
1. Install Application Server – Tomcat, OAS, WebLogic, IBM Websphere ….
2. Deploy oracledimn.war($SOFTWARE/ setup/ Manual/ oracledimn.war) to application server
3. Install JDBC Driver
4. Configure Metadata Navigator Connection to connect to your ODI repository (snps_login_work.xml)
What next after installation ?
1.Create mater and work repository using $ORACLE_HOME/oracledi/bin/repcreate.sh
and then access them using Topology Manager or Designer using $ORACLE_HOME/oracledi/bin/ topology.sh & designer.sh resp.
How to create Master & Work Repository coming soon !!
Oracle ACE, Author, Speaker and Founder of K21 Technologies & K21 Academy : Oracle Gold Partner specialising in Design, Implement, and Trainings.