DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
skathaitrooney
Participant



Joined: 06 Jan 2015
Posts: 96

Points: 877

Post Posted: Tue Jul 03, 2018 3:55 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi Gurus, i am seeking a suggestion on IGC (11.5.0.2) on moving glossary assets from one IGC instance to another

Scenario:
We have terms assigned to technical assets

Environment1:
Term1 --> HOST1>DB1>SCHEMA1>TABLE1

If we want to export this term from Environment1 and import it into Environment2 and also edit just the hostname of the asset (change Host1 to Host2)

Can i just edit the exported XML (replace the old host with the new one) and import it into the new environment
Term1 --> HOST2>DB1>SCHEMA1>TABLE1

The new host HOST2 exists in the target environment

I know we can change asset details using mapping file with XMI's, but my question is can i do this sort of stuff by editing the exported XML file itself
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54259
Location: Sydney, Australia
Points: 294280

Post Posted: Wed Jul 04, 2018 11:29 pm Reply with quote    Back to top    

I'm not sure if that will work unless the other host is already defined on the other server. Try it and let us know. It won't cause any problems if the import fails (assuming you don't use the -allo ...

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne
Rate this response:  
Not yet rated
skathaitrooney
Participant



Joined: 06 Jan 2015
Posts: 96

Points: 877

Post Posted: Fri Jul 13, 2018 2:22 am Reply with quote    Back to top    

Thanks Ray for your response.

Unfortunately i couldnt do it, or not allowed to do it.

I wanted to know how other people do it ? Do they use XMI's ?
Rate this response:  
Not yet rated
eostic

Premium Poster



Group memberships:
Premium Members

Joined: 17 Oct 2005
Posts: 3773

Points: 30298

Post Posted: Fri Jul 13, 2018 3:32 am Reply with quote    Back to top    

This will work perfectly fine, assuming that "that" named asset exists on the other instance of Information Server (with the desired hostname). The assigned asset section of a normal xml export is f ...

_________________
Ernie Ostic

blogit!
Open IGC is Here!
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours