Chris Webb is at the SQL Pass and blogging live from John McAllister’s session on Master Data Services at the PASS Summit, and here are some notes…
- The first public beta is due next week
- MDS is will be packaged with 2008 R2 (rather than Sharepoint), be on the DVD but not part of the main install
- Will have an API – everything you can do in the UI, you can do in the API
- Although it’s part of SQL Server it will still rely on Sharepoint for workflow; the main, web-based UI is not Sharepoint-based though
- Has simple business rule validation capabilities, eg make sure that the list price of a product is greater than its cost
- Includes basic documentation features
- Also has auditing features – you can see every transaction ever made in the system, reverse changes made and so on
- Models are containers for different types of data (products, customers); every model can have a version, and versions can be locked, open for editing etc; models can also be secured
- Also has basic notification features, so users/groups can get emails when something changes
- No direct SSAS integration at the moment, but they hope to have some in the future
Great stuff ! Essentially the SSAS integration 🙂 great stuff ! Thx Chris for sharing!