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 bit

Oracle GoldenGate 11.2.1.0.1 for Linux 64bit and Oracle 11g

OGG source directory: /home/oracle/ogg_src

OGG staging directory: /home/oracle/ogg

Source table: cust_dw_dev.src_city

Staging table: gg_demo_stage.city

ODI 11g installed on Windows 7 64bit – IP:192.168.1.154, master and work repository have been created.

数据库环境配置

For demonstration purposes, source, staging, target tables are in the same database.

Source Schema and Table

Login192.168.1.109 as oracle/oracle

sqlplus “/as sysdba”

create user cust_dw_dev identified by a123456;

grant dba to cust_dw_dev;

create user odi_tmp identified by a123456;

grant dba to odi_tmp;

con