Data in ERP Packages:- A remarkable feature or an ERP package is that it supports practically every phase of the day-to-day business aim enterprise from inventory control to customer billing, from human resources to production management, from product costing to budgetary control. Because of this feature, ERP packages are huge and complex. The ERP applications collect and integrate lots of -corporate data. As these are proprietary applications, the huge volumes of data ale stored in proprietary formats available for access only through programs written in proprietary languages. Usually, thousands of relational database tables are needed to support all the various functions.
Integrating ERP and Data Warehouse:- In the early 1990s, when ERP was introduced, this grand solution promised to bring about the integrated corporate data repositories companies were looking for. Because all data was cleansed, transformed, and integrated III (me place, the appealing vision was that decision making and action taking could take place limn one integrated environment. Soon companies implementing ERP realized that the thousands of relational database tables designed and normalized for running the business operations. Were not at all suitable for providing strategic information. Moreover, ERP data repositories lacked data from external sources and from other operational systems in the company. If your company has ERP or is planning to get into ERP, you need to consider the integration of ERP with data warehousing.
Integrating ERP and Data Warehouse:- In the early 1990s, when ERP was introduced, this grand solution promised to bring about the integrated corporate data repositories companies were looking for. Because all data was cleansed, transformed, and integrated III (me place, the appealing vision was that decision making and action taking could take place limn one integrated environment. Soon companies implementing ERP realized that the thousands of relational database tables designed and normalized for running the business operations. Were not at all suitable for providing strategic information. Moreover, ERP data repositories lacked data from external sources and from other operational systems in the company. If your company has ERP or is planning to get into ERP, you need to consider the integration of ERP with data warehousing.
Integration Options:- Corporations integrate ERP and the data warehouse initiatives usually adopt one of three options shown in Figure 3-7. ERP' vendors have begun to complement their packages with data warehousing solutions. Companies adopting Option I implement the data warehousing solution of the ERP vendor with the currently available functionality and await the enhancements. The downside to this approach is that you may be waiting forever the enhancements. In Option 2, companies’ implement customized data warehouses and use third-party tools to extinct data from the ERP data sets. Retrieving and loading data from the proprietary ERP data-sets is not easy. Option 3 is a hybrid approach that combines the functionality provided by the vender's data warehouse with additional functionalities from third-party loots.
You need to examine these dace approaches carefully and pick the one most suitable kir your corporation.
No comments:
Post a Comment