Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

i have 2 database tables:

  1. Components (this has fields id, name and componentType)
  2. Dependencies (this has fields id, componentId, dependencyComponentId)

A component type can be a client, server or database

I would like to generate a visio diagram that shows the dependency tree between this data and show appropriate images for components (client image, server image, etc)

Is this possible. I read all of the link shapes to records but:

  1. This doesn't seem to support multiple tables.
  2. I want to autogenerate the whole visio diagram (instead of linking shapes after the fact)
share|improve this question
    
Shouldn't this be on StackOverflow? –  TheLQ Jul 18 '10 at 19:41
    
@TheLQ Not a programming question. –  Kara Marfia Mar 4 '11 at 1:22

1 Answer 1

up vote 2 down vote accepted

It’s relatively simple to generate network diagrams in Visio. First create the detailed network diagram with Visio network shapes and then import the external data about equipment in your drawing by following these steps:

  1. On the Data menu, click Link Data to Shapes.
  2. On the first page of the Data Selector Wizard, choose which of the following types of data sources you want to use: • Microsoft Excel Workbook • Microsoft Access database • Microsoft Windows SharePoint Services List • Microsoft SQL Server database • Other OLEDB or ODBC Data Source • Previously created connection
  3. Complete the remainder of the wizard. Note: If you choose an option other than an Excel workbook, Access database, or SharePoint list on the first page of the wizard, you may be temporarily diverted to the Data Connection Wizard in the course of completing the Data Selector Wizard.
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.