2 Replies Latest reply: Nov 22, 2012 2:51 PM by user452108 RSS

    export/import project with child components

    user452108
      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
          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
            Thanks a lot for quick response.
            Thanks again