Topic
4 replies Latest Post - ‏2014-06-20T13:51:47Z by smithha
RoshanMedatwal
RoshanMedatwal
1 Post
ACCEPTED ANSWER

Pinned topic Iformation Analyser - Report Extraction from IA Repository

‏2012-09-17T11:13:17Z |
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.
Updated on 2012-09-17T11:18:27Z at 2012-09-17T11:18:27Z by RobertDickson
  • RobertDickson
    RobertDickson
    65 Posts
    ACCEPTED ANSWER

    Re: Iformation Analyser - Report Extraction from IA Repository

    ‏2012-09-17T11:17:49Z  in response to RoshanMedatwal
    Hi,

    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.

    Regards,
    Robert
    • RobertDickson
      RobertDickson
      65 Posts
      ACCEPTED ANSWER

      Re: Iformation Analyser - Report Extraction from IA Repository

      ‏2012-09-17T11:18:27Z  in response to RobertDickson
      Oops... I said 8.6, and meant 8.5. There is no 8.6 :)
  • LiborS
    LiborS
    1 Post
    ACCEPTED ANSWER

    Re: Iformation Analyser - Report Extraction from IA Repository

    ‏2014-06-19T14:54:13Z  in response to RoshanMedatwal

    Hello Everyone!

     

    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.

    Thanks

     

    Libor

    • smithha
      smithha
      162 Posts
      ACCEPTED ANSWER

      Re: Iformation Analyser - Report Extraction from IA Repository

      ‏2014-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

       

      Attachments