Materialised Query – Consolidating Data over Remote Connections

How to consolidate data over Remote Connections to regional offices over the internet.  In the example data from SAP Business One is read from a UK and Australia Office and stored in a Materialised Query data base held in a US head Office.  Once the data is consolidated at the US Office reports can be produced over the snapshots off the data pulled from the regional Offices.  Windows Schedule can then be used to schedule the download of data everyday