Installing ODI 11g Step by step part 2

In this post we basically create the ODI repository which will be stored on a relational database schema that was created by the RCU, you could create the data base schemas manually but after 11 G version you can do either way, this step is part of the ODI installation .

  • To start, go to Start menu and start “ODI Studio”:

  • On the top left corner,  you can either click “file” and go “new” or go “new” straight just below “file”:
  • In the below screen you have two options, first one you can create a “Master repository” from scratch and the second one you can “import” an existing repository, since we are first creating the environment and we have already created the repository by running the RCU we just need to connect to the master repository by choosing the option “connect to repository”:
  • You will need to pass several information to connect to the Master repository :
  • –  Login name: DEV repository(Generic name)-  User: SUPERVISOR-  Password: SUNOPSIS ( the password “sunopsis”, used to be a mandatory value in the  old days of ODI  10G version, it was the default password but after 11g version you can assign whatever password you like when running the RCU)-Database connection where the Master repository is stored:  DEV_ODI_REPO

    Password: sys

    • Driver list: Oracle Jdbc driver
    • Driver Name: jdbc.OracleDriver
    • URL: jdbc:oracle:thin:@localhost:1521:orcl
  • Click “ Test ” :
  • Check “Work Repository” and point to the “Work Repo” , select it and click “Ok”:
  • “Test” and click “Ok”
  • The first option is basically if you want to encrypt the password, otherwise choose the second option and click “Ok”:
  • Click “Ok” and you can login in the repository where you can develop several kinds of data integration, you will see the main ODI modules: “Designer”,”Operator”,”Security” and”Topology”,
  • I just wanted to point out that you could also manually create the work repositories and database schemas (old way of doing it):
  • The below screenshot is to show that you can go to “ Topology ” right click“Repositories ” and create a “new work repository” but remember we have already created the repository by running the “RCU”, so far you could start your data integration/ELT development but one last common step is to create an ODI agent so that you can schedule the loads . If you haven’t created the agent during the initial installation, you will need to install it by running the same exec file that we used to install ODI studio.

That is it for now guys , in the link below you can navigate to the next post which is the the agent installation, really important step when setting up the environment https://dwgrain.com/2016/10/30/how-to-install-and-configure-odi-standalone-agent-11g/

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s