Oracle Data Integrator和GoldenGate集成
先上架构图:先决条件1. Oracle database 11g已安装,2. Oracle GoldenGate 11g for Linux已安装3. Oracle Data Integrator已安装在windows上环境介绍Oracle Linux 64 bit 6.4 (IP: 192.168.1.109),hosts both database and GoldenGate.Oracle Database: 11.2.0.3 64 bitOracle GoldenGate ...
Many things of ODI
Log levels:1. Displays the start and end of each session2. Displays level 1 and the start and end of each step3. Displays level 2 and each task executed4. Displays the SQL queries executed, as well as level 45. A complete trace, often requested during a support call
ODI tutorials
File to Oracle databasehttp://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/odi/odi_11g/odi_project_flatfile-to-table/odi_project_flatfile-to-table.htmFile to Filehttp://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/odi/odi_11g/odi_project_ff-to-ff/odi_project_flatfile-to-flatfi...
Solving ODI "Initializing Search Engine" issue
When you open a window, let's say work repository editing, a small window pops up, and stuck at "Initializing Search Engine", it goes on and one. You cannot wait any longer, you have to kill ODI with windows process manager. Remedy: Open ODI studio, View --> "Find ODI Object". And try to op...
Installing Oracle Data Integrator 11.1.1.7 in Oracle Linux 6 u3(64bit)
This blog covers installing ODI 11.1.1.7 as well as Weblogic 10.3.6.Prerequisite:1. Oracle database 11gR2 installed.2. sysdba privilege of Oracle database 11gR2.3. Check OD...