Visio Guy

Visio => General Visio => Topic started by: collierd on March 27, 2015, 08:16:54 AM

Title: Reverse Engineer from Excel
Post by: collierd on March 27, 2015, 08:16:54 AM
Hello

Does anybody know how reverse engineering works within Visio 2007
I'm trying to reverse engineer a number of tables

Currently, I can only create entities with a name plus some columns

How do I auto-create joins?

Thanks
Title: Re: Reverse Engineer from Excel
Post by: Surrogate on March 27, 2015, 08:41:58 AM
if you need works with tables in visio try use VisioTablesAddin (https://github.com/Shishok/VisioTablesAddin) by Shisok (https://github.com/Shishok)

Sorry, i don't know what mean Reverse Engineer
Title: Re: Reverse Engineer from Excel
Post by: Nikolay on March 27, 2015, 12:22:30 PM
Does anybody know how reverse engineering works within Visio 2007

Hmm.. This is pretty well documented by Microsoft in the manual.. what do you mean?
https://support.office.com/en-za/article/Reverse-engineer-an-existing-database-into-a-database-model-fb034862-acfc-45bc-88b2-f33d1e1f8614#

There are numerous Videos also:
https://www.youtube.com/results?search_query=visio+reverse+engineer

Quote
I'm trying to reverse engineer a number of tables
Currently, I can only create entities with a name plus some columns
How do I auto-create joins?

It sounds like you are having some issue with reverse engineer? (i.e. it does not work as it should?) or?
In this case, we may need a bit more information.. Like, what type of the database are you reverse-engineering? MS SQL? Oracle? Something else?
And the relations (PKs/FKs) are not imported by the wizard? or?

Common pain point (https://connect.microsoft.com/SQLServer/feedback/details/365757/sql-server-2008-driver-for-visio-2007) is an issue when trying to reverse engineer SQL SERVER 2008 (or above) database with Visio 2007 (just shooting in the dark of course..)
The solution to this issue: do not select "Microsoft SQL Server" as provider when doing reverse-engineer, but select "ODBC Generic Driver" or "Generic OLEDB Provider" instead.
Title: Re: Reverse Engineer from Excel
Post by: Nikolay on March 27, 2015, 12:30:17 PM
Ups. Sorry. Did not read properly the CAPTION of the topic. Silly me.

EXCEL! You are reverse-engineering EXCEL! :)

But are there even relations in Excel?! Like primary keys or foreign keys?
Normally these joins are supposed to be those (PKs/FKs). But does Excel really have something like this..?
I.e. what kind of "table relationships" you are going to display using these joins/arrows, if it's about Excel? Table relationships simply do exist in Excel, do they..?