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.
Yes, it definitely makes sense to integrate the data from both CRM systems into the same DWH, unless there's a very good reason to create a separate data mart. The key business decisions to be made here would be to decide the priority of the systems if there is common data. If you have customer information in both CRM systems for instance, what needs to happen if you have the same customer in both etc.