Tuesday, July 29, 2014

ODI 11g Step by Step Installation
This post explains installation steps of Oracle Data Integrator (ODI) 11g. Download the ODI software from the oracle software: ODI Download Oracle Page

Prior to the installation of ODI, It is necessary to Install Java JDK1.6 or above.

Unzip the downloaded software and double click one setup.exe. In Universal Installer screen, It may prompted for Java location to continue the installation. So copy Java path and right click on this window bar -> mark ->paste to paste the path
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhh5vOev3-H9rtebRSmFF-4mBwnLbUC5VRaF3S4tDp3dlgU2hyuWJ_K0G9QKKOo2q86I_s1ojWsyqACCPfvbl_ZsvBXKiZuGGr_uDa1RQ9KAP35BxC9EmQd6jzV4BScvgjvK0tUxQt7bwI/s1600/odi1.png
Step1:
Just click 'Next' with the below step
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiPgnaB8IoP6fCZG8gZzJBAIeOzmUGjGJXdFrjiqpMf9FnLNOu-EBvAuicooSNrb1qfqzHjZvUpGZRqOguIFMT2Tl6MWVziVWEO1_PMK9EF1l8MmsR9-PSINLTVL8QCjoY4A5hWQKMkvoM/s1600/odi2.jpg
Step2:
If you have valid oracle support id then select second option with this step and enter the details so that the latest updates would be updated automatically. otherwise select 'Skip Software Updates' and click 'Next'
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjhWyP5XA02kGD0Sqcd5IWKPA32gHDmk1MWqy8dtvJ79U1XEt6bWEy0oBZnfNtpFIypFLZGv4KR5WIHisy_9YxBMlAYG0JBU8RV7Mvo_mSs9xLfeBYGWkIs6Ff8JoKWDTQdhIIzcPzn2ss/s1600/odi3.jpg
Step3:
If you are installed 'OBIEE 11g' in the machine then select all the components with this step so one of step you will be prompted to select middleware home. but here I have just installing ODI without Middleware path
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgyi9QfdEMwcgIRxx9_PmvXt1dD6ir0Vodey4iqXoX7aXhAC4empFpeh0Iln_aHMaQtl4bGsakiEI_ppmnhGI2UCWzt3YdK6xfNOIiHoZoyODWjf1NNPXtwA6-fpzDRZalYF2QPg1vO4Q8/s1600/odi4.jpg
Step4:
Once the prerequisites passed with this step click 'Next'
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjb17-DcSDJyqs3ysCXkv4IxwkAQaBA-EURdl-QBleox1QTMw4koyaeG8zvsiGLjDMf0jMIlVrc-fAT8ctlTrw5b_M-dqdXpG05Aoq3Wtu1q1phTwsOPxIrEA6C2upHgWGycMjg4GYdnqA/s1600/odi5.jpg
Step5:
In this step, we could see the default path where ODI will be installed. If we want to change, we could do where we could install ODI
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgkhDEE7Lf3MllIT0hFANuBwxwz2Y7reuHJCy1TC9xOVKFjo1KUwnG3mxd7e13GXbphZ1_K9k0-zhW-iP5dO_NHAVnn3wSCjlWseR3mTL61cao15FBLHX1E68FDi740birJ1qqSWZMsNz4/s1600/odi6.jpg
Step6:
We have already created Repository using OBIEE 11g RCU. so select 'Skip Repository Configuration' and then click 'Next'
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXO9QInZlOOzKrzQvROIWSK-RDa0UbsltoPP1-4oxTyR7Aa4m8W79JaJZJcbbyVyIG9LGXN4CYpwdEd63EJRIFnsGiVpSxgOn6V_hV-q-ZlvfQDvaExdyAZpKT7mvUyBh-Mtv3FQJRPj4/s1600/odi7.jpg
Step7:
In this step select database type, connection string, db user name and password and then click 'Next'
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQbH52nPbS5f-CVcmSzXo5qk9ZaDUhx40sAc3av6HxxAFbiWgCqLL5vywvVhCB74tKLHNXVI550MyN7MHQmm_P2ttGfW0M3-qLMoXq9mEt2U5qLuQctbx93FmUF-rUE1l8t6EkbGrKav8/s1600/odi8.jpg
Step8:
In this step enter SUPERVISOR passoword 'Admin123' and then click 'Next'
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh55iD2PG9BTrWDMb_6OdCCr-ppoteniAgUdoltIOERxoZ3JePgx_jpu9MfY_bCvjX_BX5GG6qa8dylcg67hq7aaLcJMHEz3VSszrBK9DSZ9Dk1qVeLRjEprc_gGZDoisQN_KPnNEXrB8U/s1600/odi9.jpg
Step9:
In this step, work repository which we have created using RCU would be selected. If not select in this step and click 'Next'
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhmuOPCk7s1lxV2D_15c9iDz9i1OAnuvcaw0oxpkTuVidu31qHtCKRp_jiRHWNvM_pZfCjIUcgckMoWTSPeuax6gK9LTNYoPiXN54LQtj_lr2gS5U6Xfr4bzq6Ltzj72iEMexamrk8Rd2o/s1600/odi10.jpg
Step10:
Give the Agent Name that you want to create with this installation and then click 'Next'
Agent Name: ODIAgent
Agent Port: 20910
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjb7sYGo7TQ51vwUMtmTFawwBe0qe7YA5-G1CxbPtPoCsOf7RB0LZkQIZa6unytBuZvaq6_HEwCfGICNx-FNI_3w6pf8JPZu8wgSFfGZJk_ejPrExlA1HOxvlSf9csfapnqe_tPbM4Bo-Y/s1600/odi11.jpg
Step11:
In this step uncheck receiving my oracle support and click 'Next'
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgCvxR5mFXSJO5TtDbp8xL-odh4JLdvwG5hiAh-0qIkxLqX0iuZxjnIjlsOdrC04yS-iCvMd-Jx3N6MKQMTHzDiTkWzjYWVgv8HbFr_EaJ6U-jCTbIBG30ZDxUgSdCZbOFZ0w2aM7rAYuw/s1600/odi12.jpg
Just click 'Yes' with this popup window
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgTAR7raq3TCb-T20StAlUZ390uV08EjxFTDyyY1-yTMm0vfC791h5e6e7y6MrmDQYY839cxujwudUlcuDW7d7ZhVb04fSrhjGvXFQvBpq9DVpunWl81InEbOIhawV2jiTZiMLUurLT3gs/s1600/odi13.jpg
Step12:
This step save ODI path details if you want or just click Install
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiPC3k0vI-RwsKdL7X1OTRMv7gcbeMnfR57gtCQEG7Fzjf-zP55K8oKu0DtiU-6uJzNHPsjVT6pmZOj9hr7_pR9-VzzFxYsijbVsds_D8vHNJsI6Q0BH10lWoW8lDgnqzT2_R_2RqTO1ns/s1600/odi14.jpg
Installation Progress
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh_drtPp5Ws1Tss1eJpULa8oQiEOknEgMt6YRJ99F__tKr3xw76gpbY1RVdck23U52bEG9c29U4ek7of4f57FfuNTfeMeuAzP4XKZ0SIiEi2buW2l4rOs_6cy6pLCL7Lnb6EH6iXqQxb4U/s1600/odi15.jpg
After configuration progess reached 100% click 'Next'
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiCIg4Pjcz9vy46fmKCvLyUmHxRGFpEoR3aXG6PWNKw-zAJPB15Y_gDwkjmuRF2OZOPZ5AvZQZZGCw56HjcUM-vlTbr_kIJdhZAi4v1iqzta4PDFER-hP_SjISYAE_3WEI0g8-yOPu99DI/s1600/odi16.jpg
Just click 'Finish' the complete ODI Installation
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjf2Nh-62m_g2a73j9vX7VHKsJLxM-5UbeGF0tna69CpbMHVMVqD9ZYnM2-ve0O4wuzTkIg1IfmwwGtKWLDxewmyENqr_i891QJBzsvJerPV0Kc3UN4DjR8cVV9uuaLCI3umgEr_MZfQY4/s1600/odi17.jpg
Now go to All Programs -> Oracle -> Oracle Data Integrator -> ODI Studio and click 'Connect Respository' and enter details like below screen
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhYxM4T2AKGb2WUYl2732aE0cbL8WsPDCXahQXksiEU-oZl2318tBC0fU5djdAIEW62GaEV_Leu9lW0oizM_V1Uiio_xKVeMVyZ6yz5UijBFBdwhS0LObMIz1VBaJ-1Qw3NZ4wFlrViSAc/s1600/odi20.jpg
We have connected with ODI Repository in ODI Studio
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj3b52A2dGDPnFjhoanYIzOUdWQFeX5Cu8NlIbfPcNTc5pjLfoxupIBRsSwDfa6KvjGzwOOxMTBwvhKhCaAjoSx2DhDrPdVwoE8gCHd8dotV12YAo2AZDYFujDZ-kfCXskvKrSoJMolMYg/s1600/odi21.jpg


No comments:

Post a Comment