Introducing Master Data Services (MDS) Add-in for Excel in SQL Server Codenamed 'Denali' CTP3

Master Data Services (MDS) Add-in for Microsoft Excel gives multiple users the ability to update master data in a familiar tool without compromising the data's integrity in MDS. With the Master Data Services Add-in, all master data remains centrally managed in MDS, while the ability to read or update the data is distributed to those […]

Master Data Services (MDS) Add-in for Microsoft Excel gives multiple users the ability to update master data in a familiar tool without compromising the data's integrity in MDS. With the Master Data Services Add-in, all master data remains centrally managed in MDS, while the ability to read or update the data is distributed to those who need it.

SQL Server Team explians that "Information workers who use Excel every day can continue working with their data and sharing it with others, helping to keep the data valid and relevant over its lifecycle. From within the Add-in, users can publish data to the MDS database with the click of a button. The time needed to learn how to use the Add-in should be minimal and business users should find it easy to use."

"If you're a data steward or a power user, you can use the Add-in to create new model objects and load data without ever launching any administrative tools, helping to speed deployment. You can configure data types for columns of data and constrain lists of data to help maintain data quality," stated SQL Server Team.

The SQL Server Team said that in an effort to streamline the web data editing experience, "we have moved to a simple UI design built on Silverlight." The new Silverlight UI provides performance and reliability that users require to manage master data and hierarchies.

While the Add-in for Excel can be used to make bulk changes to data, the web UI is where hierarchies are managed and where data stewards configure the structure that holds the data.

The team said that MDS has completely re-architected the staging process in Denali CTP3 to provide users with a more intuitive, securable solution. A new schema (stg) has been created to hold staging tables that map directly with the each MDS entity. These tables integrate well with SSIS, requiring no additional pivot of the data to load into MDS.

According to SQL team the new capabilities include:

  • Batch tags
  • Purge capabilities
  • Advanced capability to remove assigned domain-based attributes
  • Significantly increased performance

Master Data Services - What's New in SQL Server Code Name "Denali" CTP3:

You can download MDS Excel Add-In here.