Currently we are manually running the data rules & exporting the results in spreadsheets.
How can we automate this process .
Automating IA Data rules run & exporting the results
-
- Participant
- Posts: 527
- Joined: Thu Apr 19, 2007 1:25 am
- Location: Melbourne
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
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: