Building the Data Warehouse

Скачать в pdf «Building the Data Warehouse»


ERP

free from any constraints that might be placed on it. Another is that the data warehouse database designer is free to design the data warehouse environment however he or she sees fit.

Building the Data Warehouse Inside the ERP Environment


The data warehouse can be built inside the confines of the ERP environment from ERP sources, as shown in Figure 11.3. Such a proposition might be SAP’s BW or PeopleSoft’s EPM. In this case, the ERP vendor provides the application and the data warehouse as well.


There are some distinct advantages to this approach. The primary advantage is that the ERP vendor provides the infrastructure. This saves the designer an enormous amount of work, and it saves the developer from having to deal with complexities of design and development. In short, the inclusion of the data warehouse with ERP applications greatly simplifies the life of the data warehouse designer. In addition, the long-term issue of maintenance is alleviated.

Feeding the Data Warehouse
Through ERP and Non-ERP Systems_


The inclusion of the data warehouse with the ERP applications is a popular choice because the customer has a solution. But there are other alternatives.


Figure 11.4 shows that a data warehouse is built outside the ERP environment and that non-ERP applications contribute data to the data warehouse.


Figure 11.4 is a very common scenario because of the issue of integrating non-ERP data with ERP data. Most organizations do not have a completely ERP environment. There are almost always non-ERP applications; where this occurs the two types of data must be integrated.

Скачать в pdf «Building the Data Warehouse»