Refreshing diagrams from SQL Azure using SQL Authentication If you did not read Part 1 of this series, do so now as it will help ensure that you have Visio Services, Excel Services and Secure Store Service configured properly. There are a few scenarios that you can configure in order to publish Visio diagrams to…
Visio Services External Data Refresh Part 3
Refreshing diagrams from SQL Server using SQL Authentication If you did not read Part 1 of this series, do so now as it will help ensure that you have Visio Services, Excel Services and Secure Store Service configured properly. There are a few scenarios that you can configure in order to publish Visio diagrams to…
Mixing Office and Visio bits
I get asked this question quite often so I thought that I would post my view. There are various documents that discuss client requirements and version compatibility for various Office applications, including co-existence as referenced here… 1) System Requirements : http://technet.microsoft.com/en-us/library/ee624351.aspx#section15 2) Coexistence: http://support.microsoft.com/kb/2121447 There is a lot of information in both of these articles…
Visio Services External Data Refresh Part 2
Refreshing diagrams from SQL Server using Windows Authentication If you did not read Part 1 of this series, do so now as it will help ensure that you have Visio Services, Excel Services and Secure Store Service configured properly. There are a few scenarios that you can configure in order to publish Visio diagrams to…
Visio Services External Data Refresh Part 1
It is no secret that Visio allows you to connect the shapes in your diagrams to a variety of data source, most of which are also compatible with Visio Services once your diagram is hosted in a SharePoint 2010 document library. What seems to be a secret is how to configure Visio Services to refresh…
Enterprise deployment for Visio Templates using Content Types in SharePoint 2010
I recently finished an engagement with a customer who developed their own custom shapes and template to help enforce a corporate standard for all process diagrams authored by business owners within the organization. Once the template and stencils were finished, the focus shifted to maintenance and deployment. Visio is a client based application so most…
Data Linking to a Stored Procedure
Visio allows you to link to data from external data sources so that you can visualize the data on the shapes within your diagrams, and one of the external data sources that Visio supports out of the box is SQL Server. The Data Linking wizard in Visio 2010 Professional and Premium will allow you to…
Update – Extending Data Linking to External Lists in Visio 2010 and Visio Services
I found an issue ( problems connecting to External Lists on sub sites ) while testing my BDC Connector for Visio and have since released a new version of the add-in and the data module that resolves the issue. Please refer to the original article for the latest version of the download. http://blogs.msdn.com/b/chhopkin/archive/2011/01/24/extending-data-linking-to-external-lists-in-visio-2010-and-visio-services.aspx
Extending Data Linking to External Lists in Visio 2010 and Visio Services
When I speak to SharePoint developers about the dashboard and API capabilities of Visio Services the first question I get asked is, “Can I link shapes in Visio 2010 to an External List and have Visio Services refresh the data in the published diagrams from the External List?”. The short answer is no, Visio 2010…
Avoid Data Type changes during refresh from Excel Services
The Data Linking wizard in Visio 2010 Professional and Visio 2010 Premium allows you to link data directly to the shapes in your diagram from a number of different data sources. For a review and tutorial on this functionality take a look at this article: Import data from Excel, SQL Server, SharePoint sites, and other…