Servers

    Microsoft® SQL Server® 2012 Master Data Services Add-in For Microsoft® Excel®

    Select Language:
    The Master Data Services Add-in for Excel gives multiple users the ability to update master data in a familiar tool without compromising the data’s integrity in Master Data Services.
    • Note:There are multiple files available for this download.Once you click on the "Download" button, you will be prompted to select the files you need.
      Version:

      11.0.2100.60

      File Name:

      ENU\x86\MasterDataServicesExcelAddin.msi

      ENU\x64\MasterDataServicesExcelAddin.msi

      Date Published:

      3/6/2012

      File Size:

      2.4 MB

      2.5 MB


        The Master Data Services Add-in for Excel gives multiple users the ability to update master data in a familiar tool without compromising the data’s integrity in MDS. From within the Add-in, users can publish data to the MDS database with the click of a button. Administrators can use the Add-in to create new model objects and load data without ever launching any administrative tools, helping to speed deployment. With the Master Data Services Add-in for Excel, all master data remains centrally managed in MDS, while the ability to read or update the data is distributed to those who need it.

        The Master Data Services (MDS) Add-in for Microsoft Excel is a data management tool that delivers a multitude of master data management capabilities with ease and efficiency. Manage MDS data within an interface you already know and love – Microsoft® Excel. Leverage existing Excel functionality to share your managed lists with others, knowing these lists can be secured and monitored with all of the features provided by Master Data Services.

        The Master Data Services Add-in for Excel gives multiple users the ability to update master data in a familiar tool while maintaining the data’s integrity in MDS. From within the Add-in, users can publish data to the MDS database with the click of a button. Administrators can use the Add-in to create new model objects and load data without ever launching any administrative tools, helping to speed deployment. With the Master Data Services Add-in for Excel, all master data remains centrally managed in MDS, while the ability to read or update the data is distributed to those who need it.

        • Quickly and easily load new managed data sets into the Master Data Services database.
        • Administrators, easily create new entities to store sets of managed data.
        • Make bulk data changes to pre-existing models.
        • Correct all issues discovered through the validation process and seamlessly publish updates to the MDS server.
        • Add and update columns in your entities with a few clicks, creating constrained columns on the fly.
        • Send defined queries to other users through Outlook Email for a rich collaboration experience leveraging Master Data Services Security
        • Determine data matches with the new Data Quality Services for SQL Server 2012

    • Supported Operating System

      Windows 7, Windows Server 2008 R2, Windows Server 2008 Service Pack 2, Windows Vista Service Pack 2


      • Important: If you install the 32-bit version of Excel, you must use the 32-bit version of the MDS Add-in. If you install the 64-bit version of Excel, you must use the 64-bit version of the Add-in.

        1. Double-click the .msi file to start the Setup wizard.
        2. Click Next
        3. Accept the license agreement, and then click Next.
        4. Enter your name, and then click Next.
        5. Click Install.
        6. Click Finish.

        After successful completion, open Excel and a new Master Data tab is displayed on the ribbon.

        For instructions on using the Add-in
    • Additional Information

    Popular downloads

      • 01

        Microsoft® SQL Server® 2012 Express

        Microsoft® SQL Server® 2012 Express is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight Web Sites and desktop applications.

      • 03

        Microsoft® SQL Server® 2008 Management Studio Express

        Microsoft SQL Server 2008 Management Studio Express is a free, integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server, as well as combining a broad group of graphical tools and rich script editors that provide access to SQL Server to developers and administrators of all skill levels.

      • 04

        Microsoft® SQL Server® 2014 Express

        Microsoft SQL Server 2014 Express is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight Web Sites and desktop applications.

      • 05

        Microsoft Power Query for Excel

        Microsoft Power Query for Excel is an Excel add-in that enhances the self-service Business Intelligence experience in Excel by simplifying data discovery, access and collaboration.

    Loading your results, please wait...

    Free PC updates

    • Security patches
    • Software updates
    • Service packs
    • Hardware drivers

    Microsoft suggests

    Download a free trial of Windows Server 2012 R2.
    Windows Server 2012 R2 free trial
    Experience the new and enhanced capabilities.
    Free trial