ODI安裝手冊-Windows

1、ODI 安裝1 前提條件ODI 客戶端圖形化軟件、ODI Metadata NavigatorODI Agent 的安裝文件是一個 的安裝文件是另一個 安裝 ODI 客戶端圖形化軟件需要 JVM1.4.2 或以上版本以及 JDK1.4.2 或以上版本支持 安裝 ODI Agent 需要 JVM1.3.1 或以上版本以及 JDK1.4 或以上版本支持。安裝 ODI Metadata Navigator 需要兼容 JSP 1.2 和 Servlet2.3 的 Web Server,例如 Tomcat;需要 JDK1.4 或以上版本安裝JDK1.5安裝Tomcat5.5ODI客戶端圖形化軟件和 OD

2、I Agent 安裝步驟4.1安裝運行 set up. exe 或者 sh ./set up.bin£ Oracle Dala IntegratorIntroductionORACLe*InstalAnywtiere by MacrovisionCancelHelpPreviousNextO Introduction9 Choose Install Set Choose Install Folder Choose Shortcut Folder Configuration3 Pre-Installation Summary 債 Installing 3 Install Complet

3、eInstalAnywtiere by MacrovisionCancelHelpP revlous£ Oracle Dala IntegratorInstallAnywberewill guide youthrcughthe installation ofOracle Data Integrator,It is strongly recommende d that ycu quit al I programs befo re continuing with this installation.Click the 'Next" button to proceed t

4、o the next screen. Ifyou wantto Change something on a previous screen, clickthe Previous"button.You may cancel this installation at any time by clicking the Cance r button.ORACLe（2）Introduction0 Choose Install Set Choose Install Folder Choose Shortcut Folder Configuration3 Pre-Installation Summ

5、ary 債 Installing 3 Install CompleteEvaluationInstall Oracle Data Integrator evaluation environment.Devel op ineiitInstall Oraole Data Integrator development environment. Recommended lor most uxis.RuntimeInstall Oriole Data Integrator Runtime component. Recommended for server Installations only.Choos

6、e Install SetFullInstill all Oriolt OaU InUgrator compornnts. Recommended for adminirtrators.幻 Oracle Dala IntegratorORACLe*Choose Install Folder® Introduction0 Choose Install Set Choose Install Folder Choose Shortcut Folder Configuration3 Pre-Installation Summary 債 Installing 3 Install Complet

7、eInstalAnywtiere by MacrovisionCancelHelp幻 Oracle Dala IntegratorORACLe* Introduction(2> Choose Install Set0 Choose Install Folder0 Choose Shortcut Folder Configuration3 Pre-Installation Summary Installing 3 Install CompleteWhere would you like to install?ID toracle roductoractedi|Restore Default

8、 FolderChoosePreviousNextChoose Shortcut FolderWhere would you like to create pro duct icons?In a new Program Group:I CractediIn an existing Program Group: |o acic CalenderIn the Start MenuOn the DesktopIn the Quick Launch BarChoose.other:Doni create icons廠 Create Icons for AH UsersInstalAnywtiere b

9、y MacrovisionCancelHelpPreviousNext幻 Oracle Dala IntegratorInstalAnywtiere by MacrovisionCancelHelpPreviousInstall IORACLe*® Introduction(2> Choose Install Set® Choose Install Folder0 Choose Shortcut Folder Configuration3 Pre-Installation Summary 債 Installing 3 Install CompletePlease Ch

10、oose a JDK 1.5 for Use by the Installed ApplicationC ly a Java W specifically for this appbcaoonI I 11Illi ppFF "PPP I I trr pjji iipi I ppJ J p JC:Program FiesUavakl .5.0_04reM:in«»va.exeSearch For OthersChoose Another.,InstalAnywtiere by MacrovisionCancelHelpPreviousNextV Oracle Dal

11、a IntegratorORACLe*Pre-Installation SummaryIntroductionPlease Review the Following Before Continuing:Choose Install SetChoose Install FolderChoose Shortcut FolderProduct Name:Oracle Data IntegratorChoose Java Virtual MachineInstall Folder; Pre-Installation Summary Installing.3 Install CompleteD:orac

12、leproductoraclediSlwrtcut FolderC:Docutments and Settings3cdi開始菜單催序 OraclediInstall SetFullProduct Components:I 靈 OTaclc JaPa InteyatoLORACLS*Installing., enrInstalling Oracle Data IntegratorIntraductionChoose Install SetChoose Irstall FolderChoose Shortcut Folder Configuration Pre-Installation Summ

13、aiy installing. Install Completernstal AmfWilie ；e by 用1 刊:visionCancelI 電 OTacl亡 JaPa Inteb狂配*ORACUe*Install CompleteIntroductionChoose IrMall SetCongratulations! Oracle Data Integrator has been successfljlly installed to;Choose Irslall FolderChoose Shortcut Folder(2： Configuration Pre*(nstanation

14、Summary 2' Installirg,. Install CompleteD:oracleprocluchoraclediDFriLLnirinriW tn ni lit thn irir-t-nllnrfnatalfArwtie re by MFCfcwigionCancelHemPreviousL Done5 JDBC/JMS 驅(qū)動安裝步驟對于安裝了 ODI客戶端圖形化軟件或者ODI Age nt的機器來講，添加任何JDBC/JMS驅(qū)動,將驅(qū)動包（.zip或者.jar）拷貝到ODI安裝路徑drivers下對于安裝了 ODI Metadata Navigator的機器，將驅(qū)動包

15、（.zip或者.jar）拷貝到 ODI Metadata Navigator 安裝路徑 WEB-INFlib 下6 ODI 客戶端圖形化軟件和 ODI Agent 配置步驟6.1 資料庫存儲空間建議為資料庫設(shè)立單獨存儲空間6.2 創(chuàng)建資料庫用戶創(chuàng)建兩個用戶：主資料庫用戶和工作資料庫用戶在 Oracle 數(shù)據(jù)庫上創(chuàng)建的語句如下：create user snpm住資料用戶）identified by oracle（主資料用戶口令） grant connect,resource to snpmcreate user snpw（工作資料用戶）identified by oracle（工作資料用戶口令）

16、 grant connect,resource to snpw6.3 創(chuàng)建主資料庫Oracle Data Integrator > Repository Management >Master Repository Creation 然后填入相應(yīng)信息：Driver ： oracle.jdbc.driver.OracleDriver URL ： jdbc:oracle:thin:localhost:1521:orcl USER ：上一步創(chuàng)建的主資料庫用戶 Password ：上一步創(chuàng)建的主資料庫用戶口令 Technology ：資料庫所在的數(shù)據(jù)庫類型 Language ：主資料庫使用的

17、語言 點擊“ OK ”創(chuàng)建主資料庫URL冃戶壟主存甘庠創(chuàng)建肓導oracle jdhJC .driver .OradeDriverptjc: racle:thin:lcicslho2t: 1521 ：c*clpnpm:制迄富犠！:f*ll irc UH Ml IIKJJIII Um IIIF fID萇再矣國1Hypersonic SQL 啟麗 DBi/400IBM DB2 UDBInformixMicroeorft SOL ServerPostgreSQLSybase AS Ariywiere硬定 取消等待主資料庫的創(chuàng)建，直至創(chuàng)建成功:Dracl e Data luteex-at or 蓿息存熠

18、庫劇世咸總）.屋oSf退出Orecle Data Irtegretor向特?禹乏習f嶇清 I-Ml HMI Blim I I6.4連接主資料庫Oracle Data In tegrator > Topo logy Man ager創(chuàng)建新的主資料庫連接：必盍全存a庫連接I2dOracleDl Local Rep ositorypUPEMSOR填入相應(yīng)信息Login Name : oracle_master_repUser： SUPERVISOR （必須是此用戶名） P assword: SUN OP SIS （必須是此口令） 主資料庫連接信息：USER :上一步創(chuàng)建的主資料庫用戶Passw

19、ord :上一步創(chuàng)建的主資料庫用戶口令Driver : oracle.jdbc.driver.OracleDriverURL : jdbc:oracle:thin:localhost:1521:orcl存苗庫連搖p Oracle Integrator 建整|oracle m9stefjep熠戶（supervisor瞬定I專消r數(shù)嵋降崖桂i存曜庫聞戶|sripmOrftcift JDBC ）nvet*L丿®pf aclejctisc .drivet .OracI eDrheturi1 dbc: Of acle.lh in: 1 ocalha st 1521.orcl£安全存t

20、t庠連接ovacle_mssier_rep用戶UPEftVlSCiR嚴取淚6.5創(chuàng)建工作資料庫Topo logy -> Repo sitories -> Work repo sitoriesT# Q Ka *|.i : EMJ 二:Bi*eLP旳* + 廠彳同.：! If*口5r-Att+fl»1二卻wLdJ哥冃IbupfwmrI嚴回£6i&QS I IWOI# 回>errFWBOH新建工作資料庫:迦世AIMT!川啣川T" Hf3 HA *呂Q J逑 &於無 1 fittta * K*|Erj|wtrowriPV.Sfli 111

21、I.填寫下述工作資料庫連接信息:Name :工作資料庫連接名稱Tech no logy :資料庫所在數(shù)據(jù)庫類型Instance/dblink(Data Server): Oracle DB Service NameUser : 4.2步驟中創(chuàng)建的工作資料庫用戶Password : 4.2步驟中創(chuàng)建的工作資料庫用戶口令Tab JDBC -> JDBC DriverTab JDBC -> URL JDBC點擊“ OK ”數(shù)帰質(zhì)務(wù)券：靳aig稱 pfocieZwcirkr(|>範18pfci戶npwjndi連樓ftS嶄大小 咸品確定 | H M j赴世i;池毎尿務(wù)曙靳®定

22、j<FDB6馬岸丫股限可忡怖字rec呃埶槨序pracle .jcfcc .driver .OracleDnverJDBC URLdbc: oracle :thri：（®loc：alhcsL 1521 :orcl確罡 取猜應(yīng)開 帛肘i融點擊“ 0K ”以后，出現(xiàn)工作資料庫定義框：ID :注意不同的工作資料庫的ID不能重復Type :選擇下拉菜單中的一項Name :工作資料庫名稱Password :進入此工作資料庫的口令，可以不設(shè)置|-口| 刈ID葵聖H（幵歩|ORKFiEP1確定取猜應(yīng)用而“0K ”以后等待工作資料庫的創(chuàng)建6.6連接工作資料庫Oracle Data In tegr

23、ator > Desig ner 新建工作資料庫連接：# Sunopsis LoginLogin NatreUserGetting Started - ETL ProjectNew1OKCanteJjHe怕Getting Started ” E7L FTojectPassword填入連接信息Login Name :自定義的工作資料庫連接名稱User： SUPERVISORP assword： SUN OP SIS （如果在 Topo logy中修改了口令，需要填入修改后的口令） 填入主資料庫信息User： 4.2步驟中創(chuàng)建的主資料庫用戶Password： 4.2步驟中創(chuàng)建的主資料庫用戶D

24、river:URL :填入工作資料庫信息Work Repository Name :工作資料庫名稱工作存績庫連毎Oracle Integrartor 建機aSl 啻 |oracliSRe_¥vark_rep1 (supervisor F繪工士吊戶既碼塑就（段J?列我pnpmfOracle JDBC driver1>1praclejdfcc-driver .Ora cl eDriver |dbc：orade.thin:localhost1521; Orelt隍薦曜陳存魄庫當稱|WORKREP1(-BilikiiA幫助QOrftcle »a.ta Inteator S錄o

25、rscie_work_repisUPERVISOfi取消"0K ”后，進入Designer模塊7 ODI Scheduler Age nt7.1 改變 odiparams.bat文件文件在ODI安裝路徑oracledibin下 將文件中的下屬部分加上 REM rem set SNP_SECU_DRIVER=org.hsqldb.jdbcDriverrem set SNP_SECU_URL=jdbc:hsqldb:hsql:/localhostrem set SNP_SECU_USER=sarem set SNP_SECU_ENCODED_PASS=rem set SNP_SECU_W

26、ORK_REP=WORKREPrem set SNP_USER=SUPERVISORrem set SNP_ENCODED_PASS=LELKIELGLJMDLKMGHEHJDBGBGFDGGH 復制并改為如下：set SNP_SECU_DRIVER=oracle.jdbc.driver.OracleDriver（ 資 料庫 所使用 數(shù)據(jù)庫 的 JDBC Driver ， Topology-> 存儲庫 ->Master Repository 定義框 ->連接對話框中 JDBC Driver）set SNP_SECU_URL=jdbc:oracle:thin:localhost:1521:orcl （資料庫