Overview

The Database Consolidator is used to take data from various sources and log that data to a relational database for reporting purposes.

When a transfer is initiated, the last transfer date is read from a table in the target database and data is requested from the source from that date until the current date. That data is then written to the target database and the last transfer date is updated to reflect the date of the most recent data.