Example of Change Tracking in Master Data Services

Category: sql server masterdata


winstonSmith on Fri, 23 Jan 2015 14:39:37

Ive read through, and performed the steps in this article by microsoft on change Tracking in MDS using business rules.
MDS Change Tracking

The problem is that its not really tracking anything. The most i can do here is place a value in a column when some value in that row has changed. Its super limited and adds very little value:

-I cant make this value a date,
-I cant create a new row and set a field in the original row to "expired".

Basically I cant see how the product can do anything that one would actually need change tracking for.

Ive searched but found no demos on how this is actually used.

Is there a demo out there, perhaps by microsoft that shows the extent to which Change Tracking in MDS can be used ?


davidbaxterbrowne on Fri, 23 Jan 2015 15:27:51

The feature allows you to run a business rule whenever a change is made to a tracked entity member attribute.  Business rules are the main extensibility mechanism in MDS, and can do way more than just setting a member attribute.  For instance you can send email, kick of a workflow or run custom code through the misleadingly-named "External Workflow" functionality.

If you just need to enable downstream systems to extract master data that has changed recently, then you can simply filter using the LastChgDateTime column in the subscription views.


winstonSmith on Tue, 27 Jan 2015 09:31:12

Thanks David, thats the clrification i needed. Unfortunately it is much more limited than i expected. I expected too much and thats where i went wrong!