Development of the Integration Methodology for ERP Systems and Data Warehouse in a Oil Company

Modern business requires an operational analysis of the company's performance indicators. New company performance indicators are often used to support decision-making by the company's management. An oil company has a data warehouse that is used for data processing and analysis, and its architecture has to be changed. The master's thesis developed a method for integrating data storage and ERP systems of an oil company, which includes two integration scenarios depending on the availability of an analytical module. The tasks to be solved during the development of the data warehouse architecture are * Creating a unified system for processing and storage necessary for corporate governance of the company * Avoid duplication or multiple loading of data previously uploaded to the data warehouse * Providing the ability to analyze data at a more detailed level, for flexible analysis of the resulting aggregated information * Improve processes and reduce labor costs when preparing data, reduce labor costs for manual data entry The developed method was tested in an oil company. Two scenarios of the methodology were used, depending on the availability of the Analytics module in the source ERP system. The method can be used at other oil and gas companies, and possibly at other companies that use SAP BW systems. This work contains 4 tables, 25 figures, the volume of work is 73 pages. Keywords SAP BI, ERP, LSA, reporting, integration, data warehouse, SAP, multidimensional data model, data showcase, OLAP, OLTP, infocube.