IA reporting with SQL

pk7 · Post by **pk7** » Wed Jan 18, 2012 12:21 pm

Can anyone suggest a SQL statement to select the Information Analyzer Frequency Distribution values for a column using only the Project name, Table name and Column name WITHOUT having to use the cryptic names like "08-3a0e-4ee8841ae0ba1a450b_FD"? We are wanting to report FD values for columns using SQL rather than using the built-in IA reports. The end report would list Project, Table, Column, Frequency Values per Column.

ray.wurlod · Post by **ray.wurlod** » Wed Jan 18, 2012 2:40 pm

I doubt it.

These "cryptic names" are generated (guaranteed unique) keys to other tables in the metadata repository database.

qt_ky · Post by **qt_ky** » Sat Jan 21, 2012 10:44 pm

This is not SQL, but the IA User's Guide has a chapter about the HTTP API that may be worth a try...

Retrieve the frequency distribution of a column by using the HTTP API. Example:

Code: Select all

GET http://myserver:9080/InformationAnalyzer/columnAnalysis/frequencyDistribution
?projectName=project1&columnName=SOURCE1.SCHEMA1.TABLE1.COL1

ray.wurlod · Post by **ray.wurlod** » Sun Jan 22, 2012 12:15 pm

I really should learn the http api. I faced four questions about it in the certification exam.

qt_ky · Post by **qt_ky** » Sun Jan 22, 2012 9:57 pm

That exam asked me all kinds of questions about features I've never used before!

stuartjvnorton · Post by **stuartjvnorton** » Mon Jan 23, 2012 7:16 am

Hopefully they upgrade it soon to make it a little more relevant to the product.
Idiot me read the 8.1 doco and the 10 or 11 AuditStage questions I got were nearly my undoing...

ray.wurlod · Post by **ray.wurlod** » Mon Jan 23, 2012 3:00 pm

They did. The 8.5 exam was available at IOD2011, which is where I did it. No AuditStage questions, though there were some about Data Rules.