IN THIS CHAPTER
• Adding the Visio Graphics Service
• Configuring Visio Graphics Service Global Settings
• Visio Graphics Service Trusted Data Providers
• Visio Process Repository Site Template
Visio Graphics Service is a new feature in SharePoint Server 2010 Enterprise Edition. It allows publishing of data-driven web drawings from Microsoft Visio 2010 Professional or Premium. It enables users to view web drawings in the browser without installing Visio on their local machines. Users can connect their diagrams to one or more data sources, including Microsoft Excel, SQL Server, and SharePoint Foundation Services lists. The Visio Graphics Service enables users to create visually compelling, interactive dashboards by combining Visio diagrams, real-time data, and different applications in SharePoint Server 2010. Users can also schedule a job to refresh the linked data at specific time intervals.
By default, Visio Graphics Service is included when a web application is created. However, if the application is set up via a custom selection of services and Visio Graphics Service is not included in the initial creation, follow these steps in SharePoint 2010 Central Administration to add the service using Farm Configuration Wizard:
It is not required to use the Farm Configuration Wizard only to add Visio Graphics Service to your SharePoint farm but it surely makes your job easy. You can add the Visio Graphics Service using a manual approach also. You can also use the Windows PowerShell command prompt to create Visio Graphics Service application. Detailed steps for adding Visio Graphics Service to your site are shared by Microsoft Technet website at http://technet.microsoft.com/en-us/library/ee524059.aspx.
Visio Graphics Service has some global configuration settings that optimize performance, caching, and security. You can configure these settings from the SharePoint 2010 Central Administration page as follows:
Figure 11.2. Visio Graphics Service settings.
• Maximum Web Drawing Size: You can change the maximum size of a web drawing that Visio Graphics Service will render using this global setting. By default, the maximum web drawing size is 5MB.
• Minimum Cache Age: Caching enables multiple users to view the same diagram without forcing the server to render it every time. If a diagram changes, it is automatically removed from the cache. The default minimum cache age is 5 minutes. Value ranges from 0 to 34560 minutes.
• Maximum Cache Age: Defines the maximum storage time for frequently accessed items. The default maximum cache age is 60 minutes. I/O and CPU load decreases for larger Cache Age value but it increases memory usage on the server.
• Maximum Recalc Duration: Defines the maximum time Visio Graphics Service data refresh operation takes before it times out. By default, it takes 60 seconds before it times out.
• External Data: Defines the unattended service account used by Visio Graphics Service to connect to external data sources such as SQL.
If you are not sure which application ID to use for the unattended service account, leave the application ID value blank for now. Chapter 13, “Visio Graphics Service Security,” shares more details about the unattended service account. Review Chapter 13 first before configuring the External Data global setting.
One can also use Windows PowerShell command prompt to add Visio Graphics Service application to their SharePoint farm. Steps shared below provide you more details on how to use Windows PowerShell command prompt.
Before moving forward with Windows PowerShell command prompt, verify that your user id is the member of SharePoint_Shell_Access role. To learn more about PowerShell, go to http://technet.microsoft.com/en-us/library/ee662539.aspx.
Set-SPVisioPerformance -MaxDiagramCacheAge <Minutes> -MaxDiagramSize <SizeMB>-MaxRecalcDuration<Seconds>-MinDiagramCacheAge<Minutes>-VisioServiceApplication<VisioServiceApp>
Set-SPVisioExternalData -VisioServiceApplication <VisioServiceApp> -UnattendedServiceAccountApplicationID <ApplicationID>
Visio Graphics Service maintains a list of trusted data providers. If a user publishes a web drawing that is connected to a data source that is not trusted, Visio Graphics Service does not attempt to connect to it.
By default, data providers shared in Table 11.1 are trusted by Visio Graphics Service application. You can easily add or remove a provider from the SharePoint 2010 Central Administration page as by using following steps:
Table 11.1. Trusted Data Providers
Most of the time, you do not need to make any changes with default data providers. You will be using the add/edit/remove feature mainly when you use custom data providers for your web drawings. Review Chapter 12, “Visio Graphics Service Development,” to learn more about custom data providers.
You can also add, edit or delete trusted data providers using Windows PowerShell command prompt. Detailed steps are shared at following technet URL, http://technet.microsoft.com/en-us/library/ee524056.aspx.
Visio Process Repository is a new SharePoint site template that contains a library for documentation and process diagrams. The Process Diagrams document library comes prepopulated with several templates that can be used to create new process diagrams. Because the Visio Process Repository is built on top of SharePoint 2010, users can also take advantage of other SharePoint features. For instance, you can configure workflows, set up automatic email notifications on document change, and view the revision history for a given document.
It is not necessary to use the Visio Process Repository site template to store your Visio web drawings. Published Visio drawings (.vdw files) can be stored in any SharePoint document library to be opened in a browser.
In just a few clicks, a SharePoint administrator can create a Visio Process Repository. Visio Process Repository can be added to your existing Business Intelligence Center site as follows:
Visio Graphics Service is a new feature in SharePoint 2010 Enterprise. It allows the sharing with others of data-driven Visio diagrams online in a browser. The Visio Process Repository site template comes out of the box in SharePoint 2010 and lets users effectively manage their Visio process diagrams.
This chapter walked through the process of configuring Visio Graphics Service for your existing Business Intelligence Center site and brought you to the point where you can start developing and publishing Visio diagrams. Review Chapter 12 to learn how to develop and publish data-driven Visio diagrams.
The following are best practices from this chapter:
• Before setting up the unattended service account, ensure that you have set up the Secure Store Service within SharePoint. Review Chapter 13 to learn more about unattended service account and Secure Store Service setup.
• By default, the maximum web drawing size is 5MB. You can increase or decrease the size based on your organization’s storage policies. A larger size limit defined under Maximum Diagram Size global settings may slowdown system performance if the server is under heavy load, whereas a smaller value may prevent large drawings to display.
• Minimum and maximum cache age settings should be tuned based on how frequently data is refreshing and how often users are accessing web drawings.