This post is a quick and simple introduction to configuring Oracle Data Integrator. I am only covering the configuration part because, in this instance, I did not have to install ODI separately. If you have installed Oracle Hyperion EPM 11.2.0, ODI will be installed automatically as part of the FDMEE component. Installation of EPM 11.2.0 on Windows was covered in my earlier blog post here.
Assuming you have the ODI studio installed, the following steps will help you setting up the necessary repositories, Logins and start using ODI. The very first step is to run the repository creation utility, just like in earlier versions of ODI. RCU can be found at the following location.
Find the rcu.bat file and run it as administrator.
If you do not already have a prefix, you can chose Dev or Prod or any appropriate “prefix” based on the environment you are building. I am configuring ODI on a server that already has EPM suite installed and configured on it, so I am re-using the prefix Dev to setup ODI.
Enter a password that conforms to the password standards. Mind you the password here is for the relational store being created on your database for ODI. The supervisor password and other parameters come in the next step. See below.
Except for the Supervisor password and and work repository password, you can chose to use the defaults for most of these settings. Once you enter these details, make sure you either note them down somewhere or remember them, as we need these details to login to ODI. Click next to proceed to the next steps.
ODI Credentials Setup
Before logging into ODI, we need to setup the credentials screen, using the details from the RCU steps. To start this process, fire up the ODI studio from the windows menu.
You will see the following screen the very first time you fire up the ODI studio. Click on “Connect to repository” on the left hand panel, and it will bring up the login screen. This is where we enter the credentials for ODI to store. Click on the green + icon, to enter the credentials.
Note in the screen above, the user name “SUPERVISOR” is actually case sensitive. Its an interesting quirk in ODI that hasn’t changed with time.
The URL for database is a bit tricky and different for each database technology (Oracle, SQL server etc.) Select the right driver from drop-down and then click on the search icon on the right hand side.
After selecting the URL template for the kind of database you are using, fill in the details like server address and service name etc.
If all the details are correct, you should be able to click on the search button for work repository, and should see the “workrep” option available for selection. Select it and click on OK.
At this point, you should click on “Test” to make sure everything is setup properly.
After the test is successful, click on OK to save these settings. It will bring up the next screen where you are presented with a choice to use secure eWallet to encrypt the details above. I strongly recommend using it to keep your details secure.
As always, provide a strong password and remember that this password is critical to login to ODI from the next time.
Great, once we have completed all the steps above, ODI is ready for us to use. Fire up the ODI studio console, and click on the “Connect to repository” icon. This time around, you will see the secure wallet dialog box, prompting you to enter the wallet password. Do the honors to get to the next step.
You can see in this step that the login dialog has the user name and password pre-filled, and all you have to do is to click OK.
And there you go, the beautiful ODI 12C console is open for business. Play around the menus etc. to get a feel for the new version.
Rajesh Valluri is the author of this post. Hope you find it helpful. Please feel free to reach out to him with your feedback or any questions you might have. He can be reached through his LinkedIn Profile.