Q2iJsh_Q4/TQdl2MNeHYI/AAAAAAAAGhg/Z4WueLLOifY/s1600/rcu10.JPG' alt='Repository Creation Utility Installation Steps For Obiee' title='Repository Creation Utility Installation Steps For Obiee' />ODI1. Installation from an OWB developers viewIve been using OWB to build data warehouses for BI reporting for more years than I care to remember and have never had the need to switch to ODI I believe the clue is in the name, you want to build a warehouse, use warehouse builder Now however Oracle have merged OWB and ODI into a single ETL product ODI1. OWB are in there such as the oh so important mapping screen but theyve been improved with some of the slicker features of ODI. Complete Technical Acronyms, Glossary Definitions for PC, SAN, NAS, QA, Testing, HDTV, Wireless, Linux, Embedded, Networks, Video, Digital, pharma, Unix, Video. Senturus comprehensive library of Cognos and Business Intelligence presentations and information. All of them are free and we add new resources regularly. J1tsYD_PQOc/T1axC8n3sTI/AAAAAAAABDI/Q__2Bej1epI/s640/8.jpg' alt='Repository Creation Utility Installation Steps For Obiee' title='Repository Creation Utility Installation Steps For Obiee' />But thats enough of the sales pitch, here is the first of what will be a number blogs on ODI1. OWB background so lets start by installing it later on Ill cover migrating OWB projects as well. I performed this install on a Linux x. Oracle 1. 1g database 1. Three files were needed from technet before I started. Weblogic Server                wls1. ODI 1. 2c                             ofmodigeneric1. Latest Java JDK                jdk 7u. ODI can be run stand alone or within a weblogic server, and as such does not come with weblogic built into the installer, so if you want to use weblogic you need to install that first or deploy it into an existing weblogic server, but Im not doing that hereIt also needs an up to date Java JDK my vm came with 1. So the first step was to install the later JDK. Google Earth Free Download 2016 Windows Xp. Overview. The whole installation is done in a number of steps Install the latest JDK as mentioned aboveInstall Weblogic Server. Install ODI 1. 2c. Create the ODI Repositories. Create weblogic domain. Running ODI Studio for the first time Configure the AgentLogin to enterprise manager. Create the StartStop scriptThe Agent being the process that executes the ETL the equivalent of the control centre service in OWB. Installing Weblogic Server. Kicking off the weblogic installer is just a case of running the downloaded jar file with the new JDK usrjavajdk. After its extracted its files, the installer will start up. Just click next.  Specify the location where you want to install ODI. Note for the remainder of this blog this location will be referred to as the ODIHOME. I just wanted a basic weblogic server installation, so I selected that. All the pre requisite checks passed okAs this isnt a production install, I skipped on the support emails. A quick check of the installation Id asked for and away we go. Wait for all of the tasks to completeOn the final screen you get the option to automatically launch the configuration wizard although weblogic has been installed, a domain hasnt been created yet. However you need to run the weblogic configuration a second time later on to deploy the ODI services, so you can and I did skip the configuration now and do it all in one step later on. Installing ODI 1. So now I can install ODI 1. ODI 1. 2. 1. 2. 0. I unzipped the downloaded ofmodigeneric1. Note I didnt have enough space in my tmp folder to unzip this, so I created a new tmp folder u. Djava. io. tmpdir, you probably wont need this, but I included it below as an example of how tousrjavajdk. Djava. io. tmpdiru. After extracting the files the installer startsClick next passed the first screen. The Oracle Home needs to be the same home as Weblogic above. I wanted to do an enterprise installation, so thats what I chose. Just a quick note hereif you want to do a stand alone installation the oracle home must NOT contain a weblogic install i. ODI installAll the pre requisite checks passed ok. Check the install summary and go for it. The installation ran through fine. Finally I got the completion screen. Creating the ODI Repositories. ODI requires two repositories a Master repository, containing global configuration details, such as security, and a Work repository, containing the actual ETL projects you build. The repositories are created with the Repository Creation Utility RCUIn a terminal window I changed directory to ODIHOMEoraclecommonbin, set the JAVAHOME and ran rcu cd u. MiddlewareOracleHomeoraclecommonbin. JAVAHOMEusrjavajdk. JAVAHOME. rcu. This opens the usual RCU installation Click pass the welcome screen. Select Create Repository and System Load and Product Load to do it all in one go. I entered the connection details for my local 1. I got this interesting messageODI 1. Oracle Database 1. I chose ignoreOtherwise all the pre requisite checks passed ok. I just selected Oracle Data Integrator, the other dependencies are auto selected. More pre requisite checks Used the same password for all schemassee the full list of schemas in the select components screen earlier. Some additional details are required for the ODI repositories Supervisor password SUPERVISOR is the admin user in ODIWork Repository Type I chose Development which allows execution as wellThe Work Repository Name. The Work Repository Password. I left the default table spaces selected. Let the RCU create the tablespaces. Finally click Create to build the repositories. All were created successfullyCreating the Weblogic domain. Now ODI is installed we can create the weblogic domain and deploy the ODI service at the same time. Once again from a terminal window change directory, this time to ODIHOMEoraclecommoncommonbin, set the java home and run config. MiddlewareOracleHomeoraclecommoncommonbin. JAVAHOMEusrjavajdk. JAVAHOME. config. The configuration wizard will then begin Choose Create a new Domain. The domain location defaulted to ODIHOMEuserprojectsdomainsbasedomain. Now I can include ODI in the domain configuration. I left Create Domain using Product Templates selected and then from the available templates added Oracle Enterprise Manager Plugin for ODI 1. Oracle Data Integrator Console 1. Oracle Data Integrator Agent 1. Other dependent templates were automatically selected. The Application location defaulted to  ODIHOMEuserprojectsapplicationsbasedomain. Next enter the administrator user id and password. Umm, I want to setup a Production environment, but I also want to use boot. I startstop the vm. Fortunately I know how to setup the boot. Ill show this later on. The JDK defaulted to the JAVAHOME set before running the wizard above. The wizard now needs to connect to the repository created with the RCU above specifically it needs to access the Service tables in the prefixSTB schema DEVSTB in this example. Enter the connection details and click the Get RCU Configuration button. If this is successful carry on. The JDBC component schema screen should already be populated this is what the Get RCU Configuration button did. Click the Test Selected Connections button just to make sure all details have loaded properly before continuing. Two keys are required for ODI. The SUPERVISOR credential already exists when you enter this screen, but needs the actual user name and password entered as created earlier when running the RCU. Note the user name must be entered upper case. The second key is for the ODI Domain within weblogic, and needs to be the weblogic administrator user id password as entered on page 4 of this wizard above. Click the Add button and on the new line that opens up enter odidomain as the key name, followed by the admin user name and password and finally choose oracle. The three options Administration Server, Node Manager and Managed Servers need to be selected these open up more screens below to complete the configuration. In here I left the server name and port as default, however the Listen Address MUST be changed to the IP address of the server DO NOT leave this as All Local AddressesI dont havewant any server groups, I this is left as unspecified. The default Per Domain is required i. Enter a user id and password for the node manager. In the following five screens I need to configure the ODI server, create a cluster albeit with just the one server, then create a machine and assign both the ODI server and weblogic Admin Server to it. To start with on this screen the ODIServer.