Eric M Russell - Tuesday, January 17, 2017 7:59 AM

zouhair.ouichdani - Tuesday, January 17, 2017 7:33 AM

Hi guys,

I am currently working on design phase of an integration of a new CRM system Data into the existing DWH solutions.
So far,there is a daily ETL extracting data from CRM Dynamics DB (based on SQL server 2008) into Datawrehouse.All reports are based on the existing DWH.
Now,i have requirements to integrate another CRM system (based on oracle) into the existing DWH solution (SQL server 2008).
Does it make sense to integrate the data coming from different system knowing that business process for this both CRM is different?
OR do I need to build another DWH for the new CRM system?

Thank you in advace for your support.

The whole point of a data warehouse is to conform data from multiple source systems. Stop what you're doing, and don't do anything else until you read at least the first two chapters of this book by Ralph Kimball. There is also a chapter specifically on modeling an example CRM warehouse.

The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling
https://www.amazon.com/Data-Warehouse-Toolkit-Definitive-Dimensional/dp/1118530802