oracle odi 11g 官方教程

《oracle odi 11g 官方教程》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、ODI11g:CreatingandConnectingtoODIMasterandWorkRepositories创建并连接ODI主资料库和工作资料库Note: Instructionsandanytextthatyouneedtomodifyareenclosedin <>.PurposeThistutorialwalksyouthroughthestepsthatareneededtocreateandconnecttotheODIMasterRepositoryandtheODIWorkReposi

2、tory.TimetoCompleteApproximately20minutesOverviewThefirststepstosettingup OracleDataIntegrator aretocreatethe Masterrepository,connecttotheMasterrepository,createthe Workrepository,andthenconnecttotheWorkrepository.ThisOBEprovidesastep-by-stepwalkthroughof

3、theprocessofcreatingandconnectingtotheODIMasterRepositoryandtheODIWorkRepository.Note: Thestepstocreateandconnecttothemasterandworkrepositoriesarealsooutlinedinthe ODI11gInstallationGuide.ScenarioLindaworksasadatabaseadministratorforGlobalEnterprise.InGlob

4、alEnterprise,Lindaisresponsibleforperformingdatabasemanagementandintegrationtasksonthevariousresourceswithintheorganization.Inparticular,Lindaisresponsiblefordataloading,transformation,andvalidation.Tobeginworkingonherprojects(suchasexportingarelationaltab

5、letoaflatfile),sheneedstocreatethenewMasterrepositoryandWorkrepository.琳达在一个全球性的公司担任数据库管理的工作，在这家公司里琳达负责数据库的管理以及整个来自各个分公司的不同数据的整合，特别是数据的加载、转换和验证。要开始她的工作，她需要创建新的主资料库和工作资料库。SoftwareandHardwareRequirementsThefollowingisalistofsoftwarerequirements:·Thesystemsho

6、uldincludethefollowinginstalledproducts:oOracleDatabase11goOracleDataIntegrator11gR1Ifnotdonebefore,starttheservicesandcomponentsforOracleDatabase11gPrerequisitesBeforeyoustartthetasks,makesurethatyoursystemenvironmentmeetsthefollowingrequirements:1.Havein

7、stalledOracleDatabase11g.Ifnotdonebefore,starttheservicesandcomponentsforOracleDatabase11g2.HaveinstalledOracleDataIntegrator11gR1CreatingandConnectingtoODIMasterRepository 创建一个到ODI主资料库的连接1.StarttheSQLDeveloperbyselectingStart>Programs>Oracle-OraDb11g_home

8、1>ApplicationDevelopment>SQLDeveloper.WhenSQLDeveloperstarted,closetheLoggingPage–Logtab. 打开SQLDeveloper2.InSQLDeveloper,createanewconnection. 在SQLDeveloper中创建新的连接 3.Namethisnewconnection: Administrator.Enter