Data is loaded from multiple database sources into the Data Warehouse Server
The original database source is not changed
The Data Warehouse Server merges the data into an indexed file to achieve maximum speed for extremely fast queries, searches and reports
All queries run on the Data Warehouse server and the integrated database
Data from remote locations is being pulled out of remote system via Transfer PC without changing original source - each update is differential, can handle deletions, restore broken connections and much more
The transfer PC compacts and sends the data to the Data Warehouse Server
The Data Warehouse Server imports this data via high-speed import into its database
The data is integrated into a central database for better database management
Users can query, mine and search this database for information
Data Transfer
High speed data transfer guarantees up-to-date information
Scheduled transfers ensure to not interfere with other systems (backup, other data exports)
Even remote data will be transferred with high speed (5 million records in 20 minutes over connection with 512 KBit/s)
