---
title: "Importing data from OpsMgr Data Warehouse"
description: "PowerPivot for Excel allows you to import, filter, sort and build relationships between data from different data sources."
canonical: "https://helpcenter.veeam.com/docs/mp/resource_kit/importing_data_from_opsmgr_dw.html"
breadcrumb: "Veeam MP Resource Kit Guide > Visualizing Veeam MP Data Using Microsoft PowerPivot > Importing data from OpsMgr Data Warehouse"
dateModified: "2026-09-17"
---

# Importing data from OpsMgr Data Warehouse

PowerPivot for Excel allows you to import, filter, sort and build relationships between data from different data sources. Particularly, you can create a PowerPivot connection to the OpsMgr Data Warehouse and extract Veeam objects for performance data analysis and reporting purposes:

::: note

The procedure below applies to Microsoft Excel 2013. Similar actions can be performed in Microsoft Excel 2010.

:::

1. Make sure that all [hardware and software prerequisites](http://technet.microsoft.com/en-us/library/gg413462(v=sql.105).aspx) are met for the computer used to create PowerPivot workbooks.
2. Launch Microsoft Excel, open the **PowerPivot** tab and click **Manage**.
3. In the **PowerPivot for Excel** window, switch to the **Home** tab and click **From Database** > **From SQL Server** to open the **Table Import Wizard**.
4. At the **Connect to a Microsoft SQL Server Database** step, select the server which hosts OpsMgr Data Warehouse from the **Server name** drop-down list, specify credentials used to connect to the server and choose a database to collect data from.

   [![Connect to a Microsoft SQL Server Database](images/table_import_wizard.png "Connect to a Microsoft SQL Server Database")](images/table_import_wizard.png){.toggle scale=70}

5. At the **Connect to a Microsoft SQL Server Database** step, select the **Write a query that will specify the data to import** check box.
6. At the **Specify a SQL Query** step, type the name of the PowerPivot table in the **Friendly Query Name** field. Then type a SQL query in the **SQL Statement** field.

   Some examples of SQL statements are described in section [Veeam VMware PowerPivot Example](modify_sample_statements.md).

7. Click **Finish** to save the query.
8. Once you have created all the queries you need, establish relationships between the tables:

   1. In the **PowerPivot for Excel** window, switch to the **Home** tab and click **Diagram View**.
   2. Right-click the necessary column header and click **Create Relationship**.
   3. In the **Create Relationship** window, select the table and the row in this table with which you want to create a relationship.

   [![Create a relationship](images/create_relationship.png "Create a relationship")](images/create_relationship.png){.toggle scale=70}

   Alternatively, drag and drop the necessary columns to the tables you want to create relationships with.

   [![Create a relationship manually](images/create_relationship_manually.png "Create a relationship manually")](images/create_relationship_manually.png){.toggle scale=60}

## Related Topics

[Usage Example](usage_example.md)