Run Column Analysis from the api

This forum contains ProfileStage posts and now focuses at newer versions Infosphere Information Analyzer.

Moderators: chulett, rschirm

Post Reply
boxtoby
Premium Member
Premium Member
Posts: 138
Joined: Mon Mar 13, 2006 5:11 pm
Location: UK

Run Column Analysis from the api

Post by boxtoby »

Hello,

I am wondering if anyone has successfully used the IA API to run column analysis?

I have used it successfully to run DQ rules and extract the results, but I am struggling to use it for running column analysis.

Here is the xml structure the api uses and the part I am not sure of is the "Column name" attribute.

How is structured in terms of schema.table.column?

<RunColumnAnalysis
analyzeColumnProperties="true"
captureFDResultsType="CAPTURE_N"
minCaptureSize="2500
maxFDCaptureSize="5000"
analyzeDataClasses="false">

<Column name="BANK.BANK1.*.*"/>
<Column name="BANK.BANK2.TABLE1.*"/>


<SampleOptions type="every_nth" size="1000" nthValue="10"/>
<Schedule startDate="2010-02-09T18:56:31+01:00"
runUntil="2010-02-15T10:00:00+01:00" nbOfInstances="10">
<ScheduleRepeat second="0" minute="0" hour="12"
dayOfMonth="*" month="*" dayOfWeek="?" year="*"/>
</Schedule>
</RunColumnAnalysis>

Many thanks

Bob.
Bob Oxtoby
rjdickson
Participant
Posts: 378
Joined: Mon Jun 16, 2003 5:28 am
Location: Chicago, USA
Contact:

Post by rjdickson »

Hi Bob,

It's database.schema.table.col, with anything able to be *

"BANK.BANK2.TABLE1.*"
means
BANK database
BANK2 schema
TABLE1 table
all columns

Here is a simple one I used:

<?xml version="1.0" encoding="UTF-8"?>
<iaapi:Project xmlns:iaapi="http://www.ibm.com/investigate/api/iaapi" name="Optim PFK">
<Tasks>
<RunColumnAnalysis>
<Column name="BANK1.PRD.CUSTOMERS.*"/>
</RunColumnAnalysis>
</Tasks>
</iaapi:Project>

Reference: http://www-01.ibm.com/support/knowledge ... rt_ca.html
Regards,
Robert
boxtoby
Premium Member
Premium Member
Posts: 138
Joined: Mon Mar 13, 2006 5:11 pm
Location: UK

Post by boxtoby »

Hi Robert,

Perfect!

Many thanks.

Bob.
Bob Oxtoby
Post Reply