DSXchange

I want to write a program to extract profile data from IADB, then generate my own report on top of it.

Anyone know the metadata of IADB ?

Just connect to IADB, heaps of strange table names.

The "strange" table names are results of profiling. That doesn't stop you from opening them. Or describing them. When you create reference tables from within IA, you get to choose the table names.

In 8.5 IA introduced a REST-like API. That's your best method to access results from IADB. I haven't used it much except to play with it initially, but I've talked to people who have done some very cool things with it.

Here's a primitive "template" example that one of my colleagues wrote..

http://myserver:9080/InformationAnalyze ... ABLE1.COL1

Ernie

It's worth reviewing the API because there are some questions about it in the certification exam for IA 8.5.

It's quite limited in what you can pull out of it though.

Much more useful would have been a call to automate the creation of a report. Then you could write your big data extract job without having to manually run all of the reports first.

Which schema or use is the profile data in?

The low-level results are in IADB, but everything else (including which field each table actually relates to) is in XMETA.