IA reporting with SQL
IA reporting with SQL
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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:
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
Choose a job you love, and you will never have to work a day in your life. - Confucius
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 527
- Joined: Thu Apr 19, 2007 1:25 am
- Location: Melbourne
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: