Merck is a global science and technology company focused on Healthcare, Life Science and Performance Materials.
The Marketing area generates and maintains, in an ERP system, information related to the distribution of the products sold by the company. However, for decision making, such information is required to be processed by a Business Intelligence (BI) system provided by a third party.
The problem is that, due to corporate security policies, there cannot be a direct interface between both systems. Therefore, our work consisted of taking the information extracted from SAP, through several spreadsheets, creating mechanisms to validate and process the information, and, finally, through a "job" executed in SQL Server, leave the information ready to be consumed by the BI system.
The problem is that, due to corporate security policies, there cannot be a direct interface between both systems. Therefore, our work consisted of taking the information extracted from SAP, through several spreadsheets, creating mechanisms to validate and process the information, and, finally, through a “job” executed in SQL Server, leave the information ready to be consumed by the BI system.
