March 2, 2012 at 12:26 am
Hi,
How do we synchronize a transactional database with mdm database? For example, I have a table called "Customer" in my sales database. I have a MDM entity called "Customer". Then, when I add/edit a customer in MDM, it should be updated in my sales database. In the same way, when I add/edit customer in sales database, it should reflect in MDM. Is there any utility for this or we have to write custom application?
Regards,
Hareesh
March 2, 2012 at 2:59 am
Lots of options here but it depends on your business logic so you've got ask a few questions.
How likely is it that both records will be updated at the same time?
Is it better that you create a view in the transactional db to look at the customer table?
Which is the primary data if it goes out of sync? ( i can guess since it begins with Master)
How live does the syncronised data have to be?
You options as I see it are:
-Have just one table and a view to it from the transactional db
-Triggers on each table with logic to maintain data consistancy
-Add the trigger logic into the customer insert/update stored procedures to maintain both databases
-Peer to peer or merge replication between databases
-A custom SSIS package to syncronise the data
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply