MDS can be a key player in self-service scenarios, since it can provide a managed way to create and maintain parameter tables, mappings, hierarchies for separate data mart dimensions in a self-service way for even business users. In SQL16 it will get a refresh, and maybe the integration story in this case could be advanced, since "subscription viws" should be created for each entity, which we want to use in PowerQuery, and it should be refreshed every time the schema of a table changes.
3 Comments
- I am sure you do know, that you are able to consume usual interface of MDS i.e. the subscribtion tables/views found in MDS database on the SQL Server.
- Master data management is crucial to provide a more tailored analytics service to power users and azure needs it ! Would be a big plus for Microsoft data & analytics ecosystem.
- Status added:Needs Votes
