This discussion is archived
2 Replies Latest reply: Nov 22, 2012 12:51 PM by user452108 RSS

export/import project with child components

user452108 Newbie
Currently Being Moderated
We are on ODI 10.1.3.5. We exported new project with child components from DEV instance and wanted to import the exported XML file into TEST instance using Synonym INSERT mode. We have some interfaces whose names are identical in other old project in both DEV and TEST instances. If we import the new project XML file into the TEST instance with Synonym INSERT, will it cause an issue ? What is the best approach to deal with export/import between different instances when some of the object names are identical between the projects? I would appreciate if someone respond with suggestions.

Thanks in advance
VK
  • 1. Re: export/import project with child components
    SH Guru
    Currently Being Moderated
    It doesn't really matter that the names are the same. Each object in ODI is assigned a unique object ID and that is what is used when an import is performed to determine what action is taken in the target repsitory. As long as that ID doesn't match an ID that already exists in your target repository then you will be ok if using Synonym Insert, although I'd suggest using Synonym Insert/Update. Part of the object ID is based on the ID of the repository the object was exported from originally, therefore as long as you have unique repsitory IDs across your environments (basic good practice) then you shouldn't hit any significant issues.
  • 2. Re: export/import project with child components
    user452108 Newbie
    Currently Being Moderated
    Thanks a lot for quick response.
    Thanks again

Legend

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