Veeam Home | Support | Downloads
Veeam Management Pack 8.0 for System Center Resource Kit Guide

Veeam Management Pack Help Center  > Veeam MP Resource Kit Guide >  Visualizing Veeam MP Data Using Microsoft PowerPivot > Veeam VMware PowerPivot Example > Step 1. Connect to the Ops Mgr Data Warehouse

Step 1. Connect to the Ops Mgr Data Warehouse

Previous page Next page Print this Topic

Table of contents

Before you start working with spreadsheets in the Veeam VMware PowerPivot Example workbook, connect to your Ops Mgr 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

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

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

Test the connection

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

Retrieve data

6.Close the PowerPivot For Excel window.

Table of contents