We want to fetch the colulmn Ananlysis, Primary &Foreign Key Analysis, cross domain ananlysis and DQ Quality rules Profiler results from export it to a data mart for further analysis and reporting. We see that for every column / table/business rule that is configured in IA and internal ID is created for each of them and their resultsets are stored in the name of the ID. We are unable to find the mapping table between table/Column/business rule and their IDs.
1. What is the name of the table that maps the tables/columns/business Rules with internal Id created by IA? or
2. If there is any other way we can fetch / export the Profiler result sets from it’s repository?
We are investigating but if you can share any information that can give us a lead it will be very helpful.
This topic has been locked.
2 replies Latest Post - 2012-09-17T11:18:27Z by RobertDickson
Pinned topic Iformation Analyser - Report Extraction from IA Repository
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-09-17T11:18:27Z at 2012-09-17T11:18:27Z by RobertDickson
RobertDickson 0600009JMM43 PostsACCEPTED ANSWER
Re: Iformation Analyser - Report Extraction from IA Repository2012-09-17T11:17:49Z in response to RoshanMedatwalHi,
Information Analyzer comes with a fairly robust command line/HTTP API to extract information in csv or XML format. Take a look at the Information Center (http://publib.boulder.ibm.com/infocenter/iisinfsv/v8r7/index.jsp for 8.7, or http://publib.boulder.ibm.com/infocenter/iisinfsv/v8r5/index.jsp for 8.6) and search for IAADMIN. Note that there are additional options available at version 8.7.