Skip to content

connect-to-an-mds-repository-mds-add-in-for-excel.md

Latest commit

 

History

History
56 lines (37 loc) · 2.56 KB

connect-to-an-mds-repository-mds-add-in-for-excel.md

File metadata and controls

56 lines (37 loc) · 2.56 KB
title Connect to an MDS Repository
description In the Master Data Services Add-in for Excel, you must connect to a Master Data Services repository before you can load or publish data.
author meetdeepak
ms.author dkhare
ms.reviewer mikeray
ms.date 03/05/2026
ms.service sql
ms.subservice master-data-services
ms.topic how-to
ms.custom
microsoft-excel-add-in
build-2025

Connect to an MDS Repository (MDS Add-in for Excel)

[!INCLUDE SQL Server Windows Only - ASDBMI]

[!INCLUDE support-notice]

In the [!INCLUDEssMDSshort] [!INCLUDEssMDSXLS], you must connect to an MDS repository before you can load or publish data.

Prerequisites

To perform this procedure:

  • You must have permission to access the Explorer functional area.

To connect to an MDS repository

  1. In the MDS [!INCLUDEssMDSXLS], on the Master Data tab, in the Connect and Load group, click the arrow under the Connect button and click Manage Connections.

  2. On the Manage Connections dialog box, in the New connection section, click Create a new connection.

  3. Click New.

  4. On the Add New Connection dialog box, in the Description field, type a description for your connection. This connection will be displayed when you click the arrow under the Connect button on the toolbar.

  5. In the MDS server address box, type the URL of the [!INCLUDEssMDSmdm] web application, for example https://contoso/mds.

    [!NOTE]
    Ensure that you use the computer name; do not use "localhost".

  6. Click OK. The name is displayed in the Existing Connections section.

  7. Optionally, click Test to test the connection. A confirmation or error dialog is displayed. Click OK to close it.

  8. Click Connect. The Master Data Services pane is displayed.

Next Steps

See Also

Connections (MDS Add-in for Excel)