Pinned topic Iformation Analyser - Report Extraction from IA Repository
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.
RobertDickson 0600009JMM60 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.
LiborS 270007CFVK1 PostACCEPTED ANSWER
Re: Iformation Analyser - Report Extraction from IA Repository2014-06-19T14:54:13Z in response to RoshanMedatwal
we have started using Information Analyzer and we try to test the data by using some simple data rules. However, when we display the results, we only see the columns that have been tested while we need to see the whole record line (all the columns). I have attached the screenshot.
smithha 110000PAKN162 PostsACCEPTED ANSWER
Re: Iformation Analyser - Report Extraction from IA Repository2014-06-20T13:51:47Z in response to LiborS
When creating your data rule, you can add any number of additional columns available from your data source to the Output Columns definition. I've attached a screenshot for reference. You select the Output Columns definition, then select the Data Sources tab in the palette on the right (depending on screen size you may need to expand the section or use the < and > buttons to scroll through the sections. All columns from the data source should be available to select and add to the output definition.
See this topic in the documentation: Setting Output Content for a Data Rule