SQL Server Master Data Services news

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!