JAIL-it

Validate your data

You can use JAIL-it to check your data for technical, relational and business rules integrity.

JAIL-it provides a simple and straightforward means of identifying problems before the data gets into your data warehouse. Use the rule-builder to establish your validation criteria and have Data Academy automatically hold the bad data back when your data loader runs.

Once failures are identified, the individual data rows are held in the data jail where you can fix them ready to re-import. Additionally, you can build auto-correct rules to ensure that the same problem doesn’t recur the next time the loader is run.