Visualising and Generating SQL data with Microsoft Visio

  • Slides: 35
Download presentation
Visualising and Generating SQL data with Microsoft Visio 2013 David Parker Microsoft MVP (Visio)

Visualising and Generating SQL data with Microsoft Visio 2013 David Parker Microsoft MVP (Visio) davidp@bvisual. net @Visio. Rules

Thanks to our Main Sponsors:

Thanks to our Main Sponsors:

b. Visual profile b. Visual ltd Visio consultancy training proof of concepts Microsoft Partner

b. Visual profile b. Visual ltd Visio consultancy training proof of concepts Microsoft Partner 15 years David Parker 11 years MVP b. Visual ltd founded in 1998 by David Parker Visio consultant trainer author � UK based global reach

b. Visual typical client solutions Nexans Building Cabling Solutions National Physical Laboratory Rail Accident

b. Visual typical client solutions Nexans Building Cabling Solutions National Physical Laboratory Rail Accident Investigation Board Perenco Network Equipment Design National Planning Roadmaps Rail Accident Fault Analysis Trees Personnel Locations + Asset Tracking

b. Visual consultancy and training

b. Visual consultancy and training

Microsoft Visio 2013 editions Visio Standard 2013 Visio Professional 2013 Visio Pro for Office

Microsoft Visio 2013 editions Visio Standard 2013 Visio Professional 2013 Visio Pro for Office 365 Easily create versatile diagrams using a rich set of new and updated shapes and stencils. Work as a team to easily create and share professional diagrams that simplify complex information. Take advantage of all features in Visio Professional 2013 as an always-up-to-date subscription from Office 365.

Visio for everyone IT Management Organizational Management Facility Management Process Modeling Mind mapping Mockup

Visio for everyone IT Management Organizational Management Facility Management Process Modeling Mind mapping Mockup Software Development Layout Design Quality Management Work Flow Design Planning Dashboard

Key visualisation features Data Graphics Surface Shape Data values • Optionally from External Data

Key visualisation features Data Graphics Surface Shape Data values • Optionally from External Data via Link Icon Sets Text Callouts Refreshable shape geometry Data Bars • • Color By Value Icon Sets Text Callouts Data Bars Color by Value Shape Behavior All Visio shapes are evaluated for rendering Build shapes that respond to data changes • Drive geometry, formatting, text, etc via the Shape. Sheet

Supported refreshable data sources Share. Point 2013 On. Premises Supports Kerberos, SSS & Unattended

Supported refreshable data sources Share. Point 2013 On. Premises Supports Kerberos, SSS & Unattended Authentication Office 365 is a multi-tenant environment ODC Native External Lists support via BCS Native SQL Azure support BCS Native External Lists support via BCS – WCF, . NET, OData BCS

Linking Data to Shapes SQL

Linking Data to Shapes SQL

How text or graphics are updated by data Change Value in Data Source Refresh

How text or graphics are updated by data Change Value in Data Source Refresh Data. Recordset Linked Shape Data value updates Related cell value updates Displayed text or graphic updates

Shape Data types 0 - String 1 - Fixed list • Up to 32

Shape Data types 0 - String 1 - Fixed list • Up to 32 k characters • Users can select only one item from the list** 2 - Number • Number. Includes date, time, duration, and currency values as well as scalars, dimensions, and angles* 3 - Boolean • Displays FALSE and TRUE as items users can select from a drop-down list box 4 - Variable list 5 - Date time 6 - Duration 7 - Currency • Users can select a list item or enter a new item that is added to the current list** • Displays days, months, and years, or seconds, minutes, and hours, or a combined date and time value* • Displays elapsed time* • Uses the system's current Regional Settings* *Specify a format picture in the Format cell **Specify the list items in the Format cell

Displaying Data on Visio Shapes Link Data to Shapes Pivot Diagram Custom Code Shape

Displaying Data on Visio Shapes Link Data to Shapes Pivot Diagram Custom Code Shape Data Creates structure VBA Data Graphics Hidden Data. Recordsets Add-ins Refreshable Non-refreshable Add-ons

Structured Diagrams Connectivity Containment Order Associations Connected To Containers Lists Callouts Glued To Categories

Structured Diagrams Connectivity Containment Order Associations Connected To Containers Lists Callouts Glued To Categories Directional Zero to many

Importing Linked Data. Connection and Data. Recordsets • Visio 15. 0 Type Lib •

Importing Linked Data. Connection and Data. Recordsets • Visio 15. 0 Type Lib • Add, Add. From. Connection. File, Add. From. XML UI and code links to: • Microsoft Office Excel & Access • Share. Point Services Lists (including BCS lists) • SQL Server Tables and Views (including SQL Azure) • OLEDB & ODBC Can also create link in code to : • SQL Server stored procedures • XML files

Importing Linked Data Drop. Linked. U • Objects. To. Instance() • XYs() • Data.

Importing Linked Data Drop. Linked. U • Objects. To. Instance() • XYs() • Data. Recordset. ID • Data. Row. IDs() • Apply. Data. Graphic. After. Link Drop. Many. Linked. U • Objects. To. Instance() • XYs() • Data. Recordset. ID • Data. Row. IDs() • Apply. Data. Graphic. After. Link. Shape. IDs() • Shape. IDs()

Refreshing Linked Data UI and code refreshing of Data. Recordset • • . Refresh.

Refreshing Linked Data UI and code refreshing of Data. Recordset • • . Refresh. Get. All. Refresh. Conflicts. Get. Matching. Rows. For. Refresh. Conflict. Remove. Refresh. Conflict XML files can only be refreshed in code • . Refresh. Using. XML • Automation requires assigned name and file

Pivot Diagram overlaid with …

Pivot Diagram overlaid with …

… Link Data to Shapes and Data Graphics Text Icon sets Color by Value

… Link Data to Shapes and Data Graphics Text Icon sets Color by Value Data bars

Run in Developer Mode § FILE  Options  Advanced  General  Run

Run in Developer Mode § FILE Options Advanced General Run in developer mode § Extra right mouse menu option § Extra ribbon group Developer mode SDK Extras

Add smartness with the Shape. Sheet

Add smartness with the Shape. Sheet

Common Shape Sections Shape Data Hyperlinks Userdefined Cells Can be autogenerated Zero to many

Common Shape Sections Shape Data Hyperlinks Userdefined Cells Can be autogenerated Zero to many Hidden data Right-mouse menu Some data types Can be autogenerated Cell value changed triggers Can change data values Data graphics Most url protocols Reserved row names Call formulas or code Actions

Visio Client Programming Stack Add-ons VBA Visio Drawing Control (Active. X) Shape. Sheet, Smart

Visio Client Programming Stack Add-ons VBA Visio Drawing Control (Active. X) Shape. Sheet, Smart Shapes Visio Engine Visio Viewer COM Add-in Full Visio Client App Data Diagramming ML VSTO Add-in Save As Web Visio Drawings Visio Object Model (COM) Extensibility Support Tools & Wizards Visio SDK Sample code . NET Primary Interoperability Assemblies (PIAs)

Writing Validation Rules Target Filter Test • Document, Page or Shape • Refine targets

Writing Validation Rules Target Filter Test • Document, Page or Shape • Refine targets by evaluating to True • Create issue by evaluating to False

Visio Services Architecture Visio Web Access Custom Data Providers Web Part Connections Visio JSOM

Visio Services Architecture Visio Web Access Custom Data Providers Web Part Connections Visio JSOM Mash-Up API Visio Proxy Visio Graphics Service External Data Sources SQL XLSX SP Lists Share. Point Content Database OLEDB/ODBC vsdx/vsdm/vdw

Data Linked Diagrams Example § § SQL Server Share. Point BCS Visio XML

Data Linked Diagrams Example § § SQL Server Share. Point BCS Visio XML

Visio, Share. Point and SQL Server

Visio, Share. Point and SQL Server

Schema Explorer from b. Visual Coming soon

Schema Explorer from b. Visual Coming soon

DEMO

DEMO

b. Visual Publications visiorules. com bit. ly/1 kv 3 nqo visiorules. com/2010 bit. ly/Vy

b. Visual Publications visiorules. com bit. ly/1 kv 3 nqo visiorules. com/2010 bit. ly/Vy 3 ITB visualizinginformation. c om bit. ly/1 g 8 ZDY 5 blog. bvisual. net bit. ly/VRMr. VS

b. Visual Visio Add-Ins, Apps and Shapes ee r F multi. Select ee r

b. Visual Visio Add-Ins, Apps and Shapes ee r F multi. Select ee r F pd. Select Multi-Language Text Document Imager Metro Icons vis. Viewer visit bvisual. net for all products ee r F Rules. Tools

b. Visual Windows + Windows Phone Apps The Visio 2010 MVP Sessions e. Xplore

b. Visual Windows + Windows Phone Apps The Visio 2010 MVP Sessions e. Xplore Visio review the templates, stencils, masters and add-ons Windows Store bit. ly/1 kv 3 nqo Windows Phone bit. ly/1 l. Den. Y 0 24 educational videos Windows Store bit. ly/1 n 0 NEPL Windows Phone bit. ly/1 q. Emjch

Microsoft Visio Resources Microsoft Visio Product Web Microsoft Visio Blog • bit. ly/1 STdjx.

Microsoft Visio Resources Microsoft Visio Product Web Microsoft Visio Blog • bit. ly/1 STdjx. G • bit. ly/1 Jm. Hb 0 R For Microsoft Visio Developers Search for Visio MVPs • bit. ly/1 GVDh. Mc • bit. ly/1 FSbnh. Y

Thanks to our Main Sponsors:

Thanks to our Main Sponsors:

Thank You!

Thank You!