SmartUpdate is the simpelest tool for building a reporting data warehouse. It does not use advanced analitics or cubes. It simply gathers your data from various sources and puts them together in one database for reporting.
Smart Update can compare the contents of a source table with that of a target table and update the differences. All changes are logged in an audit table so you will have a historical overview.
With SmartUpdate you can easily gather data from various sources and databases into one target database and connect the data together. This way you can create reports over your data , with a minimal load on your systems and applications.