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.
Run Column Analysis from the api
Run Column Analysis from the api
Bob Oxtoby
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
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
Robert