Oracle ODI 11g 官方教程汇编.docxVIP

PAGE PAGE 2 ODI11g: Creating and Connecting to ODI Master and Work Repositories 创建并连接ODI主资料库和工作资料库 Note:?Instructions and any text that you need to modify are enclosed in?. Purpose This tutorial walks you through the steps that are needed to create and connect to the ODI Master Repository and the ODI Work Repository. Time to Complete Approximately 20 minutes Overview The first steps to setting up?Oracle Data Integrator?are to create the?Master repository, connect to the Master repository, create the?Work repository, and then connect to the Work repository. This OBE provides a step-by-step walkthrough of the process of creating and connecting to the ODI Master Repository and the ODI Work Repository. Note:?The steps to create and connect to the master and work repositories are also outlined in the? ODI 11g Installation Guide. Scenario Linda works as a database administrator for Global Enterprise. In Global Enterprise, Linda is responsible for performing database management and integration tasks on the various resources within the organization. In particular, Linda is responsible for data loading, transformation, and validation. To begin working on her projects (such as exporting a relational table to a flat file), she needs to create the new Master repository and Work repository. 琳达在一个全球性的公司担任数据库管理的工作，在这家公司里琳达负责数据库的管理以及整个来自各个分公司的不同数据的整合，特别是数据的加载、转换和验证。要开始她的工作，她需要创建新的主资料库和工作资料库。 Software and Hardware Requirements The following is a list of software requirements: The system should include the following installed products: Oracle Database 11g Oracle Data Integrator 11gR1 If not done before, start the services and components for Oracle Database 11g Prerequisites Before you start the tasks, make sure that your system environment meets the following requirements: 1. Have installed Oracle Database 11g. If not done before, start the services and components for Oracle Database 11g 2. Have installed Oracle Data Integrator 11gR1 Creating and Connecting to ODI Master Reposi