This is one question almost every one who have worked on version 10 have an answer until they try doing it and come to know its not working.
Migrating ODI from version 10 to 11 is not as simple as zipping the repositories using 'Export' command and importing it in a newer repository, Even exporting individual objects in XML format is not going to work.
Basically you need to modify the tables in the underlying schema of Master and Work repository so that they are version 11 'compliant' and how do you do that ??
ua.bat or upgrade assistant will help you in doing this. To know how it works, odiexperts have put it nicely
Here is the link
http://odiexperts.com/11g-oracle-data-integrator-upgrading-from-10g-part-411g/
And you will find ua.bat file here
C:\oracle\product\11.1.1\Oracle_ODI_1\bin (ODI_HOME/bin)
One point to note here is that the agents that were created in version 10 might not work right after you upgrade the repositories and import them, there are some things that you will need to do differently.
Check the other posts related to ODI agent to find what can be done.
I would say that this post is rather obsolete considering nobody uses ODI 10 now, For those who start with version 11g might want to ignore this topic.
Best of luck
Migrating ODI from version 10 to 11 is not as simple as zipping the repositories using 'Export' command and importing it in a newer repository, Even exporting individual objects in XML format is not going to work.
Basically you need to modify the tables in the underlying schema of Master and Work repository so that they are version 11 'compliant' and how do you do that ??
ua.bat or upgrade assistant will help you in doing this. To know how it works, odiexperts have put it nicely
Here is the link
http://odiexperts.com/11g-oracle-data-integrator-upgrading-from-10g-part-411g/
And you will find ua.bat file here
C:\oracle\product\11.1.1\Oracle_ODI_1\bin (ODI_HOME/bin)
One point to note here is that the agents that were created in version 10 might not work right after you upgrade the repositories and import them, there are some things that you will need to do differently.
Check the other posts related to ODI agent to find what can be done.
I would say that this post is rather obsolete considering nobody uses ODI 10 now, For those who start with version 11g might want to ignore this topic.
Best of luck
No comments:
Post a Comment