Menu
Is this possible?
We have a Configuration Management Database that stores information such as our servers, what datacentre they're stored in, applications that reside on them, as well as interfaces that send data from one application to another.
We would like to use Visio to connect to our SQL 2005 database, and automatically generate a flow diagram that details these dependancies and relationships.
So again - is this possible? If so, does anyone know of some documentation that details how to do this?
425
On the Data tab, click Link Data to Shapes. Select the ODBC option and select ODBC DSN. Select the DSN for SQL Server, select the table you want to import, and finish the wizard.
If the Import to Visio box and the Excel program appear, click the sheet tab where your data is, and then drag to select your data. Make sure to include any headers above the columns. Then, in the Import to Visio box, click Import, and then click Done.
Is this what you are looking out for?
142
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
