Microsoft Office Tutorials and References
In Depth Information
Figure 2-72. Workflow status after items are added
In some instances, the requirement might not be as simple as just connecting to an Excel file or SharePoint list or
even using a SQL Server database. A more interesting scenario would be consuming data from a web service or from
a different data source that Visio Services doesn’t support natively. In such cases, you would have to write a custom
data provider.
Creating Your Own Custom Data Providers
The Visio Services API provides features to build custom data modules or custom data providers. Using the API,
you can create custom data sources and refresh the data on the Visio diagrams that are deployed to a SharePoint site.
Let’s take a look now at how to support non-natively supported data sources by designing a custom data provider.
prOBLeM CaSe
Display the status of the test environment servers whether they are online or offline. Note that current status
information is in a sQL server database and can be retrieved using Windows Communication Foundation (WCF)
services. You will need to get the data and connect to the shapes.
Solution
the major components in this scenario are sQL server, WCF service, Visio, and security:
We’ll begin with a sQL server database and then write a WCF service to retrieve data from
the database table.
We’ll write a custom data provider and configure its settings in the Central administration site
of the sharepoint environment.
We’ll write a VBa script to create the data source and connect the data source to the shapes
in the Visio diagram.
We’ll deploy the .vdw file to a sharepoint environment and view the output.
 
Search JabSto ::




Custom Search