Archive for December, 2013

ODI 11G Repository Book

Posted in ODI, ODI Architecture with tags , , , on December 18, 2013 by radk00

Hi all!

I bet that all of you already got into a situation where you need to retrieve information about your developed objects in ODI, for example: how many interfaces does project X have? What are the model folders that have models shared between projects? What were the objects that were changed during this week and who changed them last? And so on. This information is easily retrieved if you know how ODI metadata is structured in its Work and Master repositories.

Luckily for us, Sonra have published a book on the ODI repository. It is free, but in order to get it, you need to comment about it. I already took a look at the models of some subject areas here so I already know that the book will contain great and useful information about the repositories.

As soon as I receive my copy, I’ll write a brief review about it, but I’m pretty sure that it will be a must to have for those that like to adventure themselves through the ODI repositories tables.

See you soon!

Edited on 12/19/2013

I got my copy of the book yesterday and I was right: it is a must to have! Great work from Sonra! The book contains models of several subject areas, very useful queries for daily/clean up tasks like: Unused Physical schemas, unused logical schemas, actual mapping of an interface, option values selected for KMs for all interfaces and a lot more! Another great thing are the ODI pictures with the correspondent repository table that contains that information. For example, when you open a Data Server tab, what is the repository table that has that information that you seeing (SNP_CONNECT in this case). It’s not 100% complete, as I missed some tables from Security module and Load Plans, but it covers 95% of your every day work! If you did not get it yet, go and get it ASAP! Thanks again Sonra!