PC 222 IOZ AG What Design Visio Shapes

PC 222

© IOZ AG

What Design? Visio Shapes Data Graphics Custom Shapes Images Clipart CAD SVG … What Data? Share. Point Excel SQL …

Icon Sets Text Callouts Data Bars Color By Value

Hyperlink to detail pages Aggregate using Property Formulas Combine Data Graphic Items Link records to multiple shapes

Excel Services 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…

• Share. Point 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 Share. Point Workflow Timer Job Web Service Power. Shell 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 Addon. Data. Handler • Returns a. NET Data. Set object to Visio Services • Client Code • Create and maintain the record set • Set the Connection. String so Visio Services knows to call your data provider • Example: Visio add-in for System Center 2012 Operations Manager

• Project Server / Project Online provides project data from Odata based web services. • Data connect Visio diagrams to the pivot tables in Power. Pivot • Incorporate Power. View 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 • Power. Shell • Solution code

• SAP • Dynamics • Web Services • XML, JSON • BCS • Power. Shell • 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/dn 448488

My. PC fill out evaluations & win prizes! Fill out session evaluations by logging into My. PC on your laptop or mobile device. Evaluation prizes daily! Claim your prize at the Registration Desk on Level 1. www. msprojectconference. com After the event, over 100 hours of resources; including all of the PPT decks and session videos will be available.