When I was learning ODI, coming from Informatica and OWB background, it was a totally new tool with new concept. I was looking for some help online and came across some very helpful people and sites that helped me gain confidence quickly.

My goal with this article is to share some of that knowledge with you and also share the resources that may help you get a better understanding of Master and Work Repositories of Oracle Data Integrator (ODI). I am also going to share some helpful resources that will help you learn how to create fresh Master and Work Repositories.

What Is A Master Repository In ODI?

Usually there is one master repository and several work repositories (if needed) are attached to the master repository in a standard ODI installation.

Master repository stores the global information that will be shared by all work repositories. Things defined by topology manager and security navigator are usually stored in the Master repository.

Master Repository stores following type of information:

  1. Security Information: users, profiles, access privileges etc.
  2. Topology information that includes technologies, data servers, physical and logical schemas , contexts, agents and languages etc.
  3. ODI versions information of the objects.

What Is A Work Repository In ODI?

Work Repository in ODI environment is always attached to a Master Repository. Multiple Work repositories (such as Development, Test and Production repositories) can be attached to one Master ODI repository.

Work repository stores the information defined in Designer navigator that stores following type of information:

  1. Data Models, metadata, constraints, references, data lineage etc.
  2. Projects, interfaces (now called Mappings in 12c onwards), packages, procedures, folders, knowledge modules etc.
  3. Scenarios, scheduling information etc.

Work repository contents are managed using designer and operator tabs from the ODI Studio. This is where development work happens.

Reference Material On Master & Work Repositories:

If you wonder (like I did) how many Master and Work repositories should you have in a real life situation at your organization, here is a good reference article: http://www.ateam-oracle.com/how-many-odi-master-repositories-should-we-have/

Tutorials On Creating and Connecting to Master and Work Repositories

I am not going to reinvent the wheel . Instead, I am going to share with you the exact resources that helped me get through my initial phase of learning ODI 12c and also helped me learn how to create and work with Master and Work repositories.

While you can create Master and Work repositories manually by creating schemas and then manually adding repositories, I am not going to share that method in this article as you need to have some experience.

So, here you go:

Resource 1: Recorded Webcast By Oracle

Oracle has a 3 webcasts series on “Data Integrator 12c: Getting Started ” published at https://apexapps.oracle.com/pls/apex/f?p=44785:24:0::::P24_CONTENT_ID,P24_PREV_PAGE:7952,1

One of the webcasts that guides you through all the steps required to create fresh ODI 12c Master and Work repositories is here. This tutorial is very comprehensive and helps you in getting used to using the Repository Creation Utility (RCU) for this purpose which is a very easy way to get started quickly:

Resource 2: Oracle Documentation Step By Step

The documentation titled ” Oracle Data Integrator 12c – Creating and Connecting to ODI Master and Work Repositories” is a very comprehensive step by step guide for those who would rather read through text than watch a video. If you like reading and following steps you read, this resource is awesome.

Visit this URL and get started:
http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/odi/odi_12c/odi12c_mst_wrk_repos/index.html

Share Your Knowledge, Your Experience Now

Have you created ODI 12c repositories using RCU? Or, do you prefer creating manually without using a utility? Would you like to share some more resources on this topic? Let’s know what you think through your comments.