We talk to construction IT managers every day about construction data warehouses and business intelligence. Many people think that building a data warehouse means that you have to transform data and transfer or push it from several databases into one data warehouse. In the last few years data warehouse technology has evolved so you can leave data in it’s native location and include it in reports across systems. You can even combine traditional data warehouses where you move or synchronize data with data from other systems to create a broader data warehouse.
For example our clients that use Sage Timberline Office deploy our anterraDataCenter™ product to synchronize data from Pervasive databases (one per data folder) into a single Microsoft SQL database. This effectively gives them a Sage Timberline SQL database. This SQL database then becomes PART of another data warehouse when we write reports for our construction BI software that spans other systems like a CRM to get sales information to prepare work backlog forecasts.
Using common data elements across databases eliminates the need to push data into a central store. Another example would be the use of an employee number that is the same in an accounting payroll system and an HR system. Using Microsoft reporting technology we can include information from both systems on one line of a report using the common element of employee ID.
Call us if you would like help in reporting across multiple databases – it might not be as complex as you think.