DataTREK Home   |   Contact Us   |   Log On  
Cloud Based Data Automation, Scrubbing, and Reconciliation

Cloud Based Data Automation, Scrubbing, and Reconciliation

Join our Weekly Webinar!  
View our Application Demo / QA Webinar delivered each week by one of our engineers! Our Webinars are scheduled for 2 PM CDT every Thursday afternoon. There is no cost to attend nor will there be any high pressure sales tactics. This is simply a quick and easy way to understand the benefits and advantages of using DataTREK. Questions and interruptions desired!

If you would like a personalized Webinar, please email Charles Gabriel at or call at 469-429-1290 x232.

DataRECONCILER is for anyone who works with spreadsheets or other data and frequently needs to compare two data sets or lists and find differences between them. DataRECONCILER will perform the comparison faster and more accurately than you could do on your own, especially with larger data sets.

The tool does not require the data to be in any specialized form or template. Simply upload any type of data in a row and column listing format; such as Microsoft Excel™ file format or a CSV (comma separated value) file format to the online DataRECONCILER engine to do the comparisons.


DataPULLER is a tool for scheduling automated data retrieval from websites and FTP servers. This tool can be configured to retrieve data files on any type of schedule such as daily, weekly, monthly, and more. DataPULLER is a highly customizable system that can be configured to pull all available files or even specific files from the server.

Once DataPULLER gets your data, it can be configured to feed this data directly into DataSCRUBBER, DataRECONCILER, or it can even be used in a custom reporting package. In addition to frequent reports, the system can notify you when data is not available or when there may be some problem with the data. This can be extremely useful in situations that require closely monitoring the data.


DataFORMATTER is an ideal means for configuring data to be easily read by man or machine. DataFormatter can merge, modify, and reformat data from multiple files allowing the user to save these tasks as a reproducible job.

When used in conjunction with DataPULLER, DataFORMATTER gives you complete control of when and how to view your data.


DataSCRUBBER is a fully customizable rules based data validation and consolidation engine. This tool can collapse, clean, and sort your data based on rules that you define. It is great for flagging and / or removing data entry errors. In addition, this tool is completely transparent. It will list out and label every record removed in an easy to understand audit trail. DataSCRUBBER allows you to save your rules to re-run future files. There is no need to setup the rules each time you need them. Simply set them up once and they will be there for your next data update!

DataSCRUBBER should be the first tool in an Auditor's toolbox!

If you have questions, would like a free site demo, quote, or need a customized solution, please contact Charles Gabriel at:

469-429-1290 x232
Additional product information is available on the DataTREK product page on EMA Softech's website .
©2016 EMA Softech.