一、ODI 的基本配置.........................................................................................................................2
(1)加载数据库用户 SDBU 和 TDBU...................................................................................2
(2)创建主资料库用户:.......................................................................................................2
(3)通过开始菜单 Master Repository Creation 启动。........................................................2
(4)通过开始菜单 Topology Manager 启动..........................................................................3
(5)创建 Work Repository......................................................................................................5
二、全量抽取.....................................................................................................................................7
(1)创建数据服务器和物理架构...........................................................................................7
(2)创建逻辑架构.................................................................................................................13
(3)创建代理.........................................................................................................................15
三、进入 ODI 的设计模块 Designer...............................................................................................17
(1)配置并登录 Designer.....................................................................................................17
(2)创建 oracle 模型.............................................................................................................19
(3)创建项目.........................................................................................................................25
(4)查看会话.........................................................................................................................32