Integrating product data to enterprise data warehouse

Abstract

Manufacturing industries are gradually moving towards digitalization. This is the demand of the current market. End-user’s buying behavior is strongly influenced by digital services offered along with nearly any product. These digital services are mostly driven by data. Data that is gathered during different phase of manufacturing process, sales, customer engagement etc. Data becomes a fuel in not only end-products but even internal business process optimization. Companies have been collecting and nurturing data from software platforms that support these business processes. A common challenge faced by companies is that data from these business processes are stored in different applications and their data is decentralized. Therefore, teams are working in silos. Data warehousing provides a solution to this challenge. It integrates data from different software applications used across organizations and maintains a central repository of data. Thus, allowing business users to derive meaningful insights from data combined from different applications. This thesis focuses on one of many business processes, product data management. It tries to study different approaches to integrate product data to enterprise data warehouse. After studying the approaches, it also discusses initial implementation of the selected solution.