Page 1 of 1
Automating IA Data rules run & exporting the results
Posted: Thu Mar 06, 2014 4:52 pm
by Oritech
Currently we are manually running the data rules & exporting the results in spreadsheets.
How can we automate this process .
Posted: Thu Mar 06, 2014 6:08 pm
by stuartjvnorton
1. Build a list of the rules you want to run.
2. Put it in an XML file that adheres to iaapi.xsd
3. iaadmin -runTasks , with the XML file you just created
4. Wait a while. It's asynchronous, so the return from the previous iaadmin call just means the request to run the rules was submitted successfully.
5. iaadmin -getExecutionHistory, with the list of rules you ran
6. parse output XML for rule execution status and pass/fail numbers and percentages. Note, this only shows rules that have completed execution (successfully or otherwise), in spite of what the doco alludes to.
7. For individual exception records, get them from the Data Quality Console, or call iaadmin -getOutputTable with the name of the rule
Posted: Thu Mar 06, 2014 7:52 pm
by ray.wurlod
Add Stuart's response to your Favorites.