{"id":4283,"date":"2011-08-24T10:14:00","date_gmt":"2011-08-24T17:14:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2011\/08\/24\/master-data-services-whats-new-in-sql-server-code-name-denali-ctp3\/"},"modified":"2024-01-22T22:49:59","modified_gmt":"2024-01-23T06:49:59","slug":"master-data-services-whats-new-in-sql-server-code-name-denali-ctp3","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/24\/master-data-services-whats-new-in-sql-server-code-name-denali-ctp3\/","title":{"rendered":"Master Data Services \u2013 What\u2019s New In SQL Server Code Name \u201cDenali\u201d CTP3"},"content":{"rendered":"


\nMaster Data Services has made great strides to further remove the barriers to implementing MDM technology and processes into all size of businesses.\u00a0 New features such as the MDS Add-in for Excel and a re-architected process for loading data should make MDS functionality accessible to the entire enterprise, allowing users to leverage transaction management, collaboration, and security with all of the dimensions and lists currently managed on personal servers. Information workers can all work with the same set of data that\u2019s centrally stored and secured.<\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/b><\/div>\n
Master Data Services (MDS) Add-in for Microsoft Excel<\/span><\/span><\/b><\/div>\n
\u00a0<\/span><\/span><\/b><\/div>\n
The Master Data Services Add-in gives multiple users the ability to update master data in a familiar tool without compromising the data\u2019s integrity in MDS. 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.<\/span><\/span><\/div>\n
\u00a0<\/span><\/span><\/b><\/div>\n
If you\u2019re 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.<\/span><\/span><\/div>\n

\nWith 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.<\/span><\/span><\/div>\n
\u00a0<\/span><\/span><\/div>\n
New Silverlight Explorer UI<\/span><\/span><\/b><\/div>\n
\u00a0<\/span><\/span><\/b><\/div>\n
In an effort to streamline the web data editing experience, we have moved to a simple UI design built on Silverlight.\u00a0 The new Silverlight UI provides performance and reliability that users require to manage master data and hierarchies.<\/span><\/span><\/div>\n

\nWhile 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.<\/span><\/span><\/div>\n
\u00a0<\/span><\/span><\/div>\n
Entity-Based Staging<\/span><\/span><\/b><\/div>\n
\u00a0<\/span><\/span><\/b><\/div>\n
Master Data Services has completely re-architected the staging process in Denali CTP3 to provide users with a more intuitive, securable solution.\u00a0 A new schema (stg) has been created to hold staging tables that map directly with the each MDS entity.\u00a0 These tables integrate well with SSIS, requiring no additional pivot of the data to load into MDS.<\/span><\/span><\/div>\n

\nNew capabilities include:<\/span><\/span><\/div>\n

\u00b7<\/span><\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span>Batch tags<\/span><\/span><\/span><\/p>\n

\u00b7<\/span><\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span>Purge capabilities<\/span><\/span><\/span><\/p>\n

\u00b7<\/span><\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span>Advanced capability to remove assigned domain-based attributes<\/span><\/span><\/span><\/p>\n

\u00b7<\/span><\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><\/span>Significantly increased performance<\/span><\/span><\/span><\/p>\n

\u00a0<\/span><\/span><\/p>\n


\nFor more information on MDS Denali CTP3:<\/span><\/span><\/div>\n
http:\/\/social.technet.microsoft.com\/wiki\/contents\/articles\/3714.aspx<\/span><\/span><\/span><\/a><\/div>\n

\n<\/span><\/span>The MDS Excel Add-In can be found here (only compatible with \u2018Denali\u2019 MDS edition):<\/span><\/span><\/div>\n
http:\/\/www.microsoft.com\/download\/en\/details.aspx?displaylang=en&id=26725<\/span><\/span><\/span><\/a><\/div>\n
\u00a0<\/span><\/span><\/div>\n
For more information about MDS role in EIM:<\/span><\/span><\/div>\n
http:\/\/www.microsoft.com\/sqlserver\/en\/us\/future-editions\/business-intelligence\/denali-enterprise-information-management.aspx<\/span><\/span><\/span><\/a>\u00a0<\/span><\/span><\/span><\/p>\n

<\/span><\/span><\/div>\n

<\/div>\n
\n
\n
<\/div>\n<\/div>\n<\/div>\n
<\/div>\n
<\/p>\n

Tyler Graham<\/span><\/span><\/span><\/div>\n

Senior Program Manager<\/span><\/span><\/span><\/div>\n
Master Data Services Team<\/span><\/span><\/span><\/div>\n","protected":false},"excerpt":{"rendered":"

Master Data Services has made great strides to further remove the barriers to implementing MDM technology and processes into all size of businesses.<\/p>\n","protected":false},"author":1457,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[],"content-type":[2448],"topic":[],"coauthors":[2487],"class_list":["post-4283","post","type-post","status-publish","format-standard","hentry","content-type-updates","review-flag-1593580427-503","review-flag-1593580414-58","review-flag-integ-1593580287-179","review-flag-lever-1593580264-545","review-flag-new-1593580247-437"],"yoast_head":"\nMaster Data Services \u2013 What\u2019s New In SQL Server Code Name \u201cDenali\u201d CTP3 - Microsoft SQL Server Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/24\/master-data-services-whats-new-in-sql-server-code-name-denali-ctp3\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Master Data Services \u2013 What\u2019s New In SQL Server Code Name \u201cDenali\u201d CTP3 - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"Master Data Services has made great strides to further remove the barriers to implementing MDM technology and processes into all size of businesses.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/24\/master-data-services-whats-new-in-sql-server-code-name-denali-ctp3\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2011-08-24T17:14:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:49:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png\" \/>\n\t<meta property=\"og:image:width\" content=\"512\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"SQL Server Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"SQL Server Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/24\/master-data-services-whats-new-in-sql-server-code-name-denali-ctp3\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/24\/master-data-services-whats-new-in-sql-server-code-name-denali-ctp3\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"Master Data Services \u2013 What\u2019s New In SQL Server Code Name \u201cDenali\u201d CTP3\",\"datePublished\":\"2011-08-24T17:14:00+00:00\",\"dateModified\":\"2024-01-23T06:49:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/24\/master-data-services-whats-new-in-sql-server-code-name-denali-ctp3\/\"},\"wordCount\":505,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/24\/master-data-services-whats-new-in-sql-server-code-name-denali-ctp3\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/24\/master-data-services-whats-new-in-sql-server-code-name-denali-ctp3\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/24\/master-data-services-whats-new-in-sql-server-code-name-denali-ctp3\/\",\"name\":\"Master Data Services \u2013 What\u2019s New In SQL Server Code Name \u201cDenali\u201d CTP3 - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"datePublished\":\"2011-08-24T17:14:00+00:00\",\"dateModified\":\"2024-01-23T06:49:59+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/24\/master-data-services-whats-new-in-sql-server-code-name-denali-ctp3\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/24\/master-data-services-whats-new-in-sql-server-code-name-denali-ctp3\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/24\/master-data-services-whats-new-in-sql-server-code-name-denali-ctp3\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Master Data Services \u2013 What\u2019s New In SQL Server Code Name \u201cDenali\u201d CTP3\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/sqlserver\",\"https:\/\/x.com\/SQLServer\",\"https:\/\/www.youtube.com\/user\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Master Data Services \u2013 What\u2019s New In SQL Server Code Name \u201cDenali\u201d CTP3 - Microsoft SQL Server Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/24\/master-data-services-whats-new-in-sql-server-code-name-denali-ctp3\/","og_locale":"en_US","og_type":"article","og_title":"Master Data Services \u2013 What\u2019s New In SQL Server Code Name \u201cDenali\u201d CTP3 - Microsoft SQL Server Blog","og_description":"Master Data Services has made great strides to further remove the barriers to implementing MDM technology and processes into all size of businesses.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/24\/master-data-services-whats-new-in-sql-server-code-name-denali-ctp3\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2011-08-24T17:14:00+00:00","article_modified_time":"2024-01-23T06:49:59+00:00","og_image":[{"width":512,"height":512,"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png","type":"image\/png"}],"author":"SQL Server Team","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"SQL Server Team","Est. reading time":"2 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/24\/master-data-services-whats-new-in-sql-server-code-name-denali-ctp3\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/24\/master-data-services-whats-new-in-sql-server-code-name-denali-ctp3\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"Master Data Services \u2013 What\u2019s New In SQL Server Code Name \u201cDenali\u201d CTP3","datePublished":"2011-08-24T17:14:00+00:00","dateModified":"2024-01-23T06:49:59+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/24\/master-data-services-whats-new-in-sql-server-code-name-denali-ctp3\/"},"wordCount":505,"commentCount":1,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/24\/master-data-services-whats-new-in-sql-server-code-name-denali-ctp3\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/24\/master-data-services-whats-new-in-sql-server-code-name-denali-ctp3\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/24\/master-data-services-whats-new-in-sql-server-code-name-denali-ctp3\/","name":"Master Data Services \u2013 What\u2019s New In SQL Server Code Name \u201cDenali\u201d CTP3 - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"datePublished":"2011-08-24T17:14:00+00:00","dateModified":"2024-01-23T06:49:59+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/24\/master-data-services-whats-new-in-sql-server-code-name-denali-ctp3\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/24\/master-data-services-whats-new-in-sql-server-code-name-denali-ctp3\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/08\/24\/master-data-services-whats-new-in-sql-server-code-name-denali-ctp3\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"Master Data Services \u2013 What\u2019s New In SQL Server Code Name \u201cDenali\u201d CTP3"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/4283","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/1457"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=4283"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/4283\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=4283"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=4283"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=4283"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=4283"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=4283"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=4283"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}