What is the integration of the data warehouse?

There is an aspect of integration of data warehouse associated with all business intelligence projects. The data warehouse is a separate system that stores electronic data. Specially designed software is used to access data only for analysis and reporting purposes. There is no mechanism for creating, editing or removing data in the warehouse. Instead, the only options are to write questions, create new messages and look for trends.

There are two options to integrate the data warehouse: full and data only. Full integration is a system design model where the data warehouse is built into the primary transaction system. This integration model is commonly found in the latest versions of most corporate resources planning systems (ERP). The hardware and infrastructure needed to support this type of system is considerable and commonly found in large organizations with specialized employees.

In the full integration model, the data warehouse approaches the data stored in the transactial database. This oneP architecture reduces storage capacity requirements because the warehouse tools have access to the original data source directly. However, there are other risks with this type of architecture. There is no opportunity to normalize data for reporting purposes and create increased data entry restrictions.

In the data warehouse integration model only for data data, a special data extraction tool is used to identify the required information, normalization and storage data in the data warehouse. It is important to understand that this type of data must be stored in another database, which requires purchase of additional storage capacity. The data warehouse can then be integrated into other tools and applications. It is becoming increasingly popular to use the data warehouse for the Internet tool for messages and metrics.

The skills necessary to achieve either the change of data warehouse integration include advanced data control, information system skills and programming. Is nEzive deep understanding and background in systems that will be integrated into the data warehouse, as well as a major understanding of data management techniques. Most people working in this area have advanced titles in information technology, mathematics or statistics. In addition to formal education, experience in the development of tools for business news and implementation of this type of technology is a basic requirement.

The advantages of integrating data warehouse include extended reporting capabilities, the ability to review data in a new way, and a new overview of transaction data. This information can be used to influence decision -making, define new business strategies and create new priorities for organization. It is important to realize that employees must be trained in this technology in order to realize any of these BLE advantages.