Installing SCOM 2012 Visio Dashboards in SharePoint 2013

In a previous post I showed how to install the SCOM 2012 Visio Dashboards on SharePoint 2010.

To install the Visio Dashboards on SharePoint 2013 it’s a little more tricky.

Part 1 – Installing SharePoint 2013 Integration Components

First I install the Operations Manager 2012 R2 console on my SharePoint Server

Next I verify that the SharePoint 2013 Enterprise with Visio Services are enabled.

On my SharePoint server I go to the SharePoint Central Administration Page.

I click Configuration Wizards

I click Launch Farm Configuration Wizard

I scroll down and verify that the Visio Graphics Service is Enabled.

It appears to be already enabled so I click Cancel.

I verify that Microsoft .NET Framework 3.5 Features are enabled.

Ok now I am ready.

First I need to install the Visio Services Data Provider.

I log on to my SharePoint server as the Farm Administrator so I have all the permissions I need.

Now I copy the Server folder over to my SharePoint 2013 server in the C:\temp\ directory from the Extensions I downloaded earlier.

Then I run setup.exe.  Click Next, Next, Close.

On my SharePoint server, I open the SharePoint 2013 Management Shell as an Administrator

In the Command shell I change directories to

C:\Program Files\Visio Services Data Provider for System Center 2012 – Operations Manager

Now I type in

.\InstallOpsMgrDataModule.ps1

I get an error because I am running SharePoint 2013.  I don’t worry about it as I will fix it later.

I run

get-spsolution

I see that it says that opsmgrdatamodule.wsp is Deployed so I am good.

I also see that another one listed called microsoft.enterprisemanagem…  This is from when I installed the SCOM Dashboard Integration
https://www.scom2k7.com/how-to-view-scom-2012-dashboards-in-sharepoint-2010/  and is not required to make the Visio integration work.

I go back to the SharePoint Central Administration Console and Click Manage service applications

I Click New, Visio Graphics Service.

I type in Visio Graphics.

Then I select Create a new application pool and type in VisioGraphicsAppPool and click OK

Note: It may take a little while to complete

Now I Select the Visio Graphics I just created.

I Select Trusted Data Providers

Click Add a new Trusted Data Provider

For Trusted Provider ID I type in:

Microsoft.Office.Visio.Server.OperationsManagerModule.OperationsManagerDataModule, Microsoft.Office.Visio.Server.OperationsManager, Version=1.0.0.1122, Culture=neutral, PublicKeyToken=31bf3856ad364e35

For Trusted Data Provider I Type in: 6

For Trusted Data Provider Description I Type in: SCOM 2012 R2

I Click OK

Back on the SharePoint Central Administration Console and I Click Manage Services on server

I click Start the Visio Graphics Service

Part 2 – Configuring SharePoint 2010 Integration Components

I open the SharePoint Central Administration Console.  I click Configure service accounts from the Security Section

From the dropdown I pick Service Application Pool – SharePoint Web Services System

I need to grant the SCOM2K12\max (or whatever your account listed here is) access to read SCOM.  I open the SCOM 2012 console double click on the Operations Manager Read-Only Operators and add my SharePoint service account to the Operations Manager Read-Only Operations user role.

Part 3 – Adding your Visio Dashboard to SharePoint 2013

I get my SCOM Dashboard Visio document from my previous post.  https://www.scom2k7.com/creating-scom-2012-dashboards-using-visio-2010-or-visio-2013/

I open up the diagram document in Visio 2013

I click Configure to make sure my connection is correct.

I click File, Save As a Visio 2010 Web Drawing

Note: You might get a warning about some Compatibility issue.  Just click Continue.

I now go to my SharePoint page and click Shared Documents and upload the Visio file.

Now I select the document just uploaded

I click on my Visio Document and it comes up in a web console.

I click Allow Refresh

Part 4 – Configuring SharePoint 2013 to show your Visio Dashboard as a web part.

From my site I Add a page

Then I add a Web Part.  Under Business Data I select Visio Web Access

Then I select Click here to open the tool pane

I select the Document from my shared Documents where I stored it earlier.

Then I set the Automatic Refresh interval to 10 and uncheck Show Open in Visio

Then I Click Apply then OK

Now I check out my finished product.