SQL Server 2012 MDM pushing Data

• brad.mason5

  Hall of Fame

  Points: 3299

  More actions

  March 28, 2012 at 7:04 pm

  #255697

  Hello SQL Server Central members,

  I have recently been tasked with prototyping MDM for SQL Server 2012. I have pulled in some data from our source system and have created the subscription views.

  My question is what is the best way to push out the data to the source systems.

  Using SSIS and some type of output mapping lookup table?

  Example would be email address. We have email address stored in a couple DBMS (sql server and mysql) and I originally though MDM would do the work of pusing out the data however from my research it looks like this is tasked outside of the MDM product.

  Any one have experience in implementing MDM push to other sources?

  I did read the MDM 2008 R2 book and this gave an example of Biz Talk, however right now we are looking for other solutions.

  Thanks,

  Brad

• Orlando Colamatteo

  SSC Guru

  Points: 182279

  More actions

  June 7, 2012 at 4:37 pm

  #1498450

  How is prototyping progressing?

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato