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



Joined: 18 Jan 2010
Posts: 118
Location: Chicago
Points: 786

Post Posted: Wed Jan 10, 2018 9:42 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Is there any way to export a data rule's properties - bindings, joins, output content, output table, etc. - for use outside IA, such as into Excel? And hopefully something that can do entire projects, i.e., multiple rules.

I don't know of any such feature within IA but outside of it, say in IGC?

_________________
Todd
Sr Consultant, Data Governance
Chicago
qt_ky



Group memberships:
Premium Members

Joined: 03 Aug 2011
Posts: 2789
Location: USA
Points: 21033

Post Posted: Thu Jan 11, 2018 7:46 am Reply with quote    Back to top    

You can export data rule properties from IGC into Excel. I've done that before just to get a document that lists all the data rule names. I'm not sure if all the other details are available from IGC or not. I know that the data rule definition / logic is visible from IGC.

_________________
Choose a job you love, and you will never have to work a day in your life. - Confucius
Rate this response:  
truenorth
Participant



Joined: 18 Jan 2010
Posts: 118
Location: Chicago
Points: 786

Post Posted: Thu Jan 11, 2018 10:19 am Reply with quote    Back to top    

Much appreciated! We will try to pull as much info as IGC can provide.

_________________
Todd
Sr Consultant, Data Governance
Chicago
Rate this response:  
Not yet rated
UCDI



Group memberships:
Premium Members

Joined: 21 Mar 2016
Posts: 331

Points: 3352

Post Posted: Fri Jan 12, 2018 10:01 am Reply with quote    Back to top    

you can also export from fast-track to excel.
Rate this response:  
Not yet rated
truenorth
Participant



Joined: 18 Jan 2010
Posts: 118
Location: Chicago
Points: 786

Post Posted: Wed Jan 17, 2018 9:28 am Reply with quote    Back to top    

I have not used FastTrack before. What is it called now in v11.5?

_________________
Todd
Sr Consultant, Data Governance
Chicago
Rate this response:  
Not yet rated
boxtoby



Group memberships:
Premium Members

Joined: 13 Mar 2006
Posts: 132
Location: UK
Points: 1375

Post Posted: Thu Jan 18, 2018 7:50 am Reply with quote    Back to top    

You can use the api to extract almost anything from IA including the data rules and data rule definitions to xml and in some cases csv as well.

Here's the link:

https://www.ibm.com/support/knowledgecenter/en/SSZJPZ_11.3.0/com.ibm.swg.im.iis.ia.restapi.doc/topics/r_restapi_getlist_commands.html

Hope that helps,
Bob.

_________________
Bob Oxtoby
Rate this response:  
Not yet rated
UCDI



Group memberships:
Premium Members

Joined: 21 Mar 2016
Posts: 331

Points: 3352

Post Posted: Thu Jan 18, 2018 1:39 pm Reply with quote    Back to top    

its still fasttrack. But if your team isnt using it, it won't help, its a lot of work to maintain the mappings. We use it as storage for our source to target mappings and rules, but have had no luck with its job automation features etc. Its just a big excel sheet for us, really.
Rate this response:  
Not yet rated
truenorth
Participant



Joined: 18 Jan 2010
Posts: 118
Location: Chicago
Points: 786

Post Posted: Tue Jan 23, 2018 10:50 am Reply with quote    Back to top    

No, UCDI, we're not using FT. But thanks for the great info.

Thanks, Bob. IAAdmin looks promising; we'll certainly look into it.

_________________
Todd
Sr Consultant, Data Governance
Chicago
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