先上架構圖：

先決條件

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 64 bit 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

Login 192.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;

connect cust_dw_dev@orcl;

執行Oracle官網上下載的ODI demo.zip包含的建表語句建立src_city表

Staging and Target Schema and Table

Connect “/as sysdba”;

create user gg_demo_staging identified by a123456;

grant dba to gg_demo_staging;

create user gg_demo_target identified by gg_demo_target;

grant dba to gg_demo_target;

connect gg_demo_staging/a123456@orcl;

create table gg_demo_staging.CITY (

   CITY_ID              NUMERIC(10) not null,

   CITY                 VARCHAR(50),

   REGION_ID            NUMERIC(10),

   POPULATION           NUMERIC(10),

   constraint PK_SRC_CITY primary key (CITY_ID)

);

Connect gg_demo_target/a123456@orcl;

create table gg_demo_target.CITY (

   CITY_ID              NUMERIC(10) not null,

   CITY                 VARCHAR(50),

   REGION_ID            NUMERIC(10),

   POPULATION           NUMERIC(10),

   constraint PK_SRC_CITY primary key (CITY_ID)

);

ODI配置

Physical Architecture

  Start ODI Studio from Windows 7
  Connect to master and work repository.

Source

  Topology tab ? Physical Architecture ? Oracle, right click and select New Data Server
  Enter GG_SOURCE for Name
  On JDBC tab, Enter:
  oracle.jdbc.OracleDriver for JDBC Driver
  jdbc:oracle:thin:@192.168.1.109:1521:orcl for JDBC Url
  Click save and Test Connection.
  Right GG_SOURCE and select New Physical Schema
  Enter:
  cust_dw_dev for Schema (Schema)
  odi_tmp for Schema (Work Schema)
  Click save and close.

Staging and Target

  Follow the previous steps to create staging Data Server and Physical Schemas. Here, use gg_demo_staging as physical schema, gg_demo_target for target.

Logical Architecture

Source

  Topology tab ? Logical Architecture ? Oracle, right click and select New Logical Schema.
  Enter GG_SOURCE for Name
  Select GG_ONE for Physical Schema for Global Context.

Staging and Target

  Follow the same steps to create staging and target Logical Schema. Use appropriate names for staging and target.

Model

  Click Designer tab ? Models ? New Model. Enter “GG_SOURCE”, ”GG_STAGING”,”GG_TARGET” for source, staging and target schema, select “Oracle” for Technology, select Logical Schema respectively for source, staging and target.
  Right click each newly-created models and select Reverse Engineer, tables created from Database Step should show up in the list.
  Right click CITY table from GG_STAGING, Changed Data Capture ? Add to CDC, click Yes on the pop-up box.

CDC Configuration

Go to Designer --&gt Projects --&gt Knowledge Modules, right click and select Import Knowledge Modules, from the pop-up window, select JKM Oracle to Oracle Consistent (OGG), and click OK.

Double click “GG_STAGING” model, select Journalizing, and select Consistent Set for Journalizing Mode, JKM Oracle to Oracle Consistent(OGG). for Knowledge Module.

Enter the configuration as follows and save.

To view data in the target schema, Models --&gt GG_TARGET --&gt CITY, right click and select View Data.

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/638844/viewspace-1062175/，如需轉載，請註明出處，否則將追究法律責任。