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

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
    74 Posts

    Re: Iformation Analyser - Report Extraction from IA Repository

    ‏2012-09-17T11:17:49Z  
    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
    74 Posts

    Re: Iformation Analyser - Report Extraction from IA Repository

    ‏2012-09-17T11:18:27Z  
    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
    Oops... I said 8.6, and meant 8.5. There is no 8.6 :)
  • LiborS
    LiborS
    1 Post

    Re: Iformation Analyser - Report Extraction from IA Repository

    ‏2014-06-19T14:54:13Z  

    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

    Re: Iformation Analyser - Report Extraction from IA Repository

    ‏2014-06-20T13:51:47Z  
    • LiborS
    • ‏2014-06-19T14:54:13Z

    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

    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