Advanced ETL Processor can be used to perform first two, It has 300+ validation/tranformation functions plus it works with 27 datasources. For the third one you can use QlikView.
Everyone who performs data transformation knows the importance of data quality and how much time is required to find what went wrong and correct the problem
In the latest version of Advanced ETL Processor we introduced new object called "Log"
The idea is very simple: to redirect log messages into different data flow so this data can used later for reporting.
Plus comparing to standard text log it provides much more information to the user.
It allows to answer the following questions:
What was wrong with the data?
Which actions were taken to correct the data?
Initial value of the field
Value after correction
And much more
We would like to thank Adrian Parker from Differentia Consulting Ltd for giving us usefull feedback
Advanced ETL Processor can now generate QVD files from the following data sources: Text, XML, Excel, Access, DBF, Foxpro, ODBC, OLE DB, MS Sql Server, Oracle, MySql, PostgreSQL, Firebird, Interbase, SQLite, POP3, RSS, Windows Event Log, Google Spreadsheets, SalesForce, BrightPearl and QlikView QVX files.
+ Support for BrightPearl was introduced
+ Support for IMAP4 was introduced
+ Support for Sales Force was introduced
+ Support for JDBC was introduced
+ Support for IP Sockets was introduced
+ Additional filters for file/zip and check file operations
+ Documentation update
- Various bug fixes
Great news Adavanced ETL processor supports now pooling data from Google speadsheets, next data source would be Sales Force, more products to follow. Our ETL software support now 20 different data sources. "The world will new run out of data or data sources and we will never run out of work"