How to read data from IADB

eimhelper01 · Post by **eimhelper01** » Thu Apr 12, 2012 11:27 pm

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.

ray.wurlod · Post by **ray.wurlod** » Fri Apr 13, 2012 2:51 pm

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.

eostic · Post by **eostic** » Sun Apr 15, 2012 6:18 am

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

ray.wurlod · Post by **ray.wurlod** » Sun Apr 15, 2012 12:53 pm

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

stuartjvnorton · Post by **stuartjvnorton** » Thu Apr 19, 2012 6:29 am

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.

xicheng_my_love · Post by **xicheng_my_love** » Fri May 18, 2012 1:45 am

Which schema or use is the profile data in?

stuartjvnorton · Post by **stuartjvnorton** » Fri May 18, 2012 9:08 am

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