Any way to export rules to Excel?

This forum contains ProfileStage posts and now focuses at newer versions Infosphere Information Analyzer.

Moderators: chulett, rschirm

Post Reply
truenorth
Participant
Posts: 139
Joined: Mon Jan 18, 2010 4:59 pm
Location: San Antonio

Any way to export rules to Excel?

Post by truenorth »

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 Ramirez
Sr Consultant, Data Quality
San Antonio TX
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

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
truenorth
Participant
Posts: 139
Joined: Mon Jan 18, 2010 4:59 pm
Location: San Antonio

Post by truenorth »

Much appreciated! We will try to pull as much info as IGC can provide.
Todd Ramirez
Sr Consultant, Data Quality
San Antonio TX
UCDI
Premium Member
Premium Member
Posts: 383
Joined: Mon Mar 21, 2016 2:00 pm

Post by UCDI »

you can also export from fast-track to excel.
truenorth
Participant
Posts: 139
Joined: Mon Jan 18, 2010 4:59 pm
Location: San Antonio

Post by truenorth »

I have not used FastTrack before. What is it called now in v11.5?
Todd Ramirez
Sr Consultant, Data Quality
San Antonio TX
boxtoby
Premium Member
Premium Member
Posts: 138
Joined: Mon Mar 13, 2006 5:11 pm
Location: UK

Post by boxtoby »

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/knowledgece ... mands.html

Hope that helps,
Bob.
Bob Oxtoby
UCDI
Premium Member
Premium Member
Posts: 383
Joined: Mon Mar 21, 2016 2:00 pm

Post by UCDI »

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.
truenorth
Participant
Posts: 139
Joined: Mon Jan 18, 2010 4:59 pm
Location: San Antonio

Post by truenorth »

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 Ramirez
Sr Consultant, Data Quality
San Antonio TX
Post Reply