This discussion is archived
3 Replies Latest reply: Feb 19, 2013 11:19 AM by 980427 RSS

Still have to change Context for EACH ODI Object

980427 Newbie
Currently Being Moderated
Correct me if I'm wrong - Even though ODI touts the ability to have one set of code for various physical environments, it doesn't make moving from say DEV to TEST any much easier.

What I mean to say is, even if I create 'InterfaceA' under the Logical Schema 'Phase1' and my Context is 'DEV' pointing to the Physical Schema for 'Development Data Server'; when I want to chance the Context to say 'TEST', I have to go into 'InterfaceA' and make that change to Context 'TEST'.

Now, I have to do this for 'InterfaceA' through 'InterfaceXY' and so on for each Package, Scenario, Procedure and so on.

Point being, there's not centralized mechanism to change all the Contexts for all the objects - therefore this functionality is nothing great.

Might as well copy all the objects to a New Repository and change the Contexts there. Have a Master Rep for each DEV, TEST and PROD.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points