Transcript © IOZ AG What Design? Visio Shapes Data Graphics Custom Shapes Images Clipart CAD SVG … What Data? SharePoint Excel SQL … Icon Sets Text Callouts Data Bars Color By Value.

© IOZ AG
What Design?
Visio Shapes
Data Graphics
Custom Shapes
Images
Clipart
CAD
SVG
…
What Data?
SharePoint
Excel
SQL
…
Icon Sets
Text Callouts
Data Bars
Color By Value
L
XL
NEED TO
RESTOCK
S
Production
90 Day Avg (hrs): 21.2
Exceptions: 2
Actual
Actual(hrs):
(hrs):23.7
10
Target (hrs): 22
1.
Current Stock
29
2.
XL
RUNNING
LOW
3.
S
L
Combine Data Graphic Items
Use Formulas to calculate properties
Link a record to multiple shapes
Hyperlink to detail pages
Excel
Services
External Lists (BCS)
SQL Azure
SP Lists
+
Custom
OLEDB
ODBC
.NET
BCS
• Refreshed using current user credentials
• User needs access to the diagram and
workbook locations
• Must reside in a document library
• No network shares
• VSDX and XLSX on the same farm
• XLSX format, no old XLS formats
• Link and Refresh from
• Sheets / Tables
• Named Ranges / Custom Range
• Refreshed using OLEDB driver
• Provider=Microsoft.ACE.OLEDB.12…
• SharePoint Lists are an easy yet
powerful data source
• Same farm as the Visio diagram
• User needs read access to the list
• Get your data in a list and VGS can
refresh from it
•
•
•
•
•
•
Manual Edit
SharePoint Workflow
Timer Job
Web Service
PowerShell Script
Applications or Services
• BCS allows you to configure external
content types for connecting to
•
•
•
•
•
External SQL DBs
SQL On Premises
SQL Azure
WCF Services
Custom .NET providers
• External Lists are fully supported in
Visio 2013
• BCS add-in for 2010
• Support for SQL Server 7.0 –> 2012
• + SQL Azure
• No Analysis Services or Reporting
Services
• at least not directly
• Tables & Views
• provided via Visio Data Linking dialog
• Can we refresh from Stored Procedures?
• Yes!
• Not available in the Visio client UI for the
SQL data source option
• Configure BCS to execute the stored
procedure – connect Visio via External List
• Server Code
• .NET assembly deployed to the GAC and
registered as a Trusted Data Provider for the
Visio Services service application
• Implements AddonDataHandler
• Returns a .NET DataSet object to Visio
Services
• Client Code
• Create and maintain the record set
• Set the ConnectionString so Visio Services
knows to call your data provider
• Example: Visio add-in for System Center
2012 Operations Manager
• PowerView is not a data source but a
visualization tool for PowerPivot
• Data connect Visio diagrams to the
pivot tables in PowerPivot
• Incorporate PowerView in a Mashup
with Visio Services connected to the
same data source
• System Center contains a wealth of
information
• Visio add-in for System Center 2012
Operations Manager
• BCS
• PowerShell
• Solution code
• SAP
• Dynamics
• Web Services
• XML, JSON
• BCS
• PowerShell
• Solution code
http://visio.microsoft.com
http://blogs.office.com/b/visio/
http://blogs.msdn.com/b/chhopkin/
http://msdn.microsoft.com/en-US/office/dn448488
http://channel9.msdn.com/Events/TechEd
www.microsoft.com/learning
http://microsoft.com/technet
http://microsoft.com/msdn