MDM & DQS for maanging customer master

Question

I am doing a project in MDM and DQS where we have to build dashboard of customer records which is being derived from different systems like ERP , sharepoint sites etc. however there is no link between the two system which is restricting us to build relationship.

 We refer to an customer in ERP as sb001 and in SharePoint sites storing customer contact details as  refid 4500 (integer) but both are the same entity. Problem is how can I refer data in both systems in the BI report where there is no link. Only link possible is customer name an company where DQS in some case doesn’t give high confidence.

---

Guneet Kalra

Answer 1

For your scenario, I think you need DQS to cleanse the data and then use the cleansed data to do BI report. For BI report quetions, you can get better answers in the Reporting Services forum here, http://social.msdn.microsoft.com/Forums/en-US/sqldenreportingservices/threads .