• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

bVisual

  • Home
  • Services
    • How Visio smartness can help your business
    • Visio visual in Power BI
    • Visio Consulting Services
    • Visio Bureau Services
    • Visio Training and Support Services
  • Products
    • Visio Shape Report Converter
    • SS Plus
    • LayerManager
    • visViewer
    • Metro Icons
    • Rules Tools for Visio
    • The Visio 2010 Sessions App
    • Multi-Language Text for Visio
    • Document Imager for Visio
    • multiSelect for Visio
    • pdSelect for Visio
  • Case Studies
    • Case studies overview
    • Using Visio in Education for GIS
    • Visualizing Construction Project Schedules
    • Visio Online Business Process Mapping
    • Nexans Visio Template
    • CNEE Projects, WorldCom
    • Chase Manhattan Bank
  • News
    • Recent news
    • News archive
  • Resources
    • Articles➡
      • ShapeSheet Functions A-Z
      • Comparing Visio for the Web and Desktop
      • Customising Visio Shapes for the Web App
      • Key differences between the Visio desktop and web apps
      • Using the Visio Data Visualizer in Excel
      • Using Visio in Teams
      • Creating Visio Tabs and Apps for Teams with SharePoint Framework (SPFx)
      • Designing Power Automate Flows with Microsoft Visio
      • Innovative uses of Visio Lists
    • Webcasts ➡
      • Visio in Organizations
      • My session and other Visio sessions at MSIgnite 2019
      • Power up your Visio diagrams
      • Vision up your Visio diagrams
      • The Visio 2010 MVP Sessions
    • Visio Web Learning Resources
    • Books➡
      • Visualize Complex Processes with Microsoft Visio
      • Mastering Data Visualization with Microsoft Visio
      • Microsoft Visio Business Process Diagramming and Validation
      • Visualizing Information with Microsoft Visio
  • Blog
    • Browse blog articles
    • Visio Power BI articles
    • Visio for Web articles
    • A history of messaging and encryption
  • About us
    • About bVisual
    • Testimonials
    • Bio of David Parker
    • Contact Us
    • Website Privacy Policy
    • Website terms and conditions
    • Ariba Network
You are here: Home / Azure / Linking SQL database on Azure to Visio via SharePoint Online

Published on September 26, 2014 by David Parker

Linking SQL database on Azure to Visio via SharePoint Online

My last post was entitled Linking SQL database on Azure to Visio (see http://blog.bvisual.net/2014/09/11/linking-sql-database-on-azure-to-visio/), but that was only half the solution I wanted to present because I was having issues with linking my SQL database on Azure to my SharePoint Online. So, I enlisted my friend and colleague, Nick Ajderian, who looked into it and wrote the following blog article : http://softwaremechanik.wordpress.com/2014/09/24/connecting-microsoft-azure-to-sharepoint/ . Well, I still failed, until I realised a subtle error that I was making …

In my previous article, I showed how to connect directly to the SQL database on Azure by using the Data Connection Wizard, where I entered the Server name with the “, 1433” suffix in order to address the port. Well, when I kept on entering the same server name in the SQL Server Connection dialog for the new connection in the Data Source Explorer for a External Content Type in SharePoint Designer, everything was looking fine because I could expand the connection to view the tables and create the operations. I could even create the External List okay, but I could not view any records in it, and kept getting a connection error. I was getting very frustrated until I dropped the “, 1433”, then everything worked!

Here is my Floors table from my SQL database on Azure in SharePoint Online:

SNAGHTML47319fc

So, now I can select this list, as a Microsoft SharePoint Foundation List, using Link Data to Shapes in Visio:

image

It appears with the “ (External)” ending in the Data Selector dialog:

image

So, now the SQL database table on Azure is available in Visio, through SharePoint Online:

image

This is good because I can now have refreshable Visio diagrams, linked to SQL database on Azure, displayed in SharePoint web pages!

Of course, I could have used SQL views, or SharePoint views, and I could even have linked SQL stored procedures as External Content Types.

All that is left is to build a proper solution … and to thank my friend Nick, aka Software Mechanik ( http://softwaremechanik.wordpress.com/ ), for his assistance.

Related

Filed Under: Azure, Visio 2013 Tagged With: SharePoint 2013, Visio Services

About David Parker

David Parker has 25 years' experience of providing data visualization solutions to companies around the globe. He is a Microsoft MVP and Visio expert.

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

  • LinkedIn
  • Twitter

Recent Posts

  • Fixing dimensions of 2D shapes
  • Merging Linked Data from Similar Tables
  • Smart Radio Buttons and Check Boxes in Visio
  • Using Button Face Ids in Visio
  • Grid Snapping Revisited

Categories

Tags

Accessibility Add-Ins Connectors Containers Data Export Data Graphics Data Import Data Visualizer Educational Excel GraphDatabase Hyperlinks Icon Sets JavaScript LayerManager Layers Legend Link Data to Shapes Lists MSIgnite MVP Office365 Org Chart PowerApps PowerBI PowerQuery Processes Setup and Deployment Shape Data Shape Design ShapeSheet ShapeSheet Functions SharePoint 2013 SQL Teams Validation VBA Video Visio Visio 2007 Visio for the Web Visio Online Visio Services Visio Viewer Webinar

Footer

bVisual Profile

The UK-based independent Visio consultancy with a worldwide reach. We have over 25 years experience of providing data visualization solutions to companies around the globe.

Learn more about bVisual

  • Amazon
  • E-mail
  • Facebook
  • LinkedIn
  • Twitter
  • YouTube

Search this website

Recent posts

  • Fixing dimensions of 2D shapes
  • Merging Linked Data from Similar Tables
  • Smart Radio Buttons and Check Boxes in Visio
  • Using Button Face Ids in Visio
  • Grid Snapping Revisited

Copyright © 2025 · Executive Pro on Genesis Framework · WordPress · Log in