Performance optimization for extraction, transformation, loading and reporting of data

Enterprise Resource Planning has become the cornerstone for making data acquisition and related operations more efficient. Recent advances in hardware and software technologies have enabled us to think about performance optimization. Ninety percent of ERP projects spend more than their allocated budgets and have exceeded the time schedule for implementation. There are many factors that can be attributed to the low success rate of implementation but one main factor is the performance of the ERP package itself. In this paper, we have described the Business Intelligence tool and database which is related to Systems, Applications and Products. It is popularly known as SAP. Based on this, a new, mulch-dimensional performance metric is proposed for extracting, transforming, loading and reporting the data.