---
title: "Step 1. Connect to the OpsMgr Data Warehouse"
description: "Before you start working with spreadsheets in the Veeam VMware PowerPivot Example workbook, connect to your OpsMgr DW to retrieve data from it: Launch Microsoft Excel, open the PowerPivot tab and click Manage."
canonical: "https://helpcenter.veeam.com/docs/mp/resource_kit/connect_to_opsmgr_dw.html"
breadcrumb: "Veeam MP Resource Kit Guide > Visualizing Veeam MP Data Using Microsoft PowerPivot > Veeam VMware PowerPivot Example > Step 1. Connect to the OpsMgr Data Warehouse"
dateModified: "2026-09-10"
---

# Step 1. Connect to the OpsMgr Data Warehouse

Before you start working with spreadsheets in the Veeam VMware PowerPivot Example workbook, connect to your OpsMgr DW to retrieve data from it:

1. Launch Microsoft Excel, open the **PowerPivot** tab and click **Manage**.
2. In the **PowerPivot For Excel** window, switch to the **Home** tab and click **Existing Connections**. 
3. In the **Existing Connections** window, select the *SCOM_DW* data source and click **Edit**.

   [![Choose a data source](images/existing_connections.png "Choose a data source")](images/existing_connections.png){.toggle scale=70}

4. In the **Edit Connection** window, expand the **Server name** drop-down list and choose your server which hosts Data Warehouse.

   [![Choose a DW server](images/edit_connection.png "Choose a DW server")](images/edit_connection.png){.toggle scale=70}

   Click **Test Connection**, wait for the connection to be tested, click **OK** and then click **Save**.

   [![Test the connection](images/test_connection.png "Test the connection")](images/test_connection.png){.toggle scale=70}

5. On the **Home** tab, click **Refresh** > **Refresh All**, wait for the new data to be retrieved and click **Close**.

   [![Retrieve data](images/data_refresh.png "Retrieve data")](images/data_refresh.png){.toggle scale=75}

6. Close the **PowerPivot For Excel** window.