Reverse Engineering ERD from Database for Documentation

Contributor

Hi there,

we'd like to generate ERD (Entity Relationship Diagrams) by reverse engineering information from Exasols system tables. Does anybody know a tool which provides this functionality? I checked Visual Paradigm https://www.visual-paradigm.com/ but it does not support connections to Exasol DB. 

Are there any alternatives?

I'm grateful for any hint ๐Ÿ™‚

Best regards,

Jan

1 ACCEPTED SOLUTION

Xpert

Hi Jan,

now this is where it getยดs interesting ๐Ÿ™‚ - you might want to look at EXA_DBA_DEPENDENCIES_RECURSIVE , it should give you the referenced objects and you could visualize from there ?

Cheers
Malte

View solution in original post

11 REPLIES 11

Xpert

and whenever someone mentions DBVis I like to check up on DBeaver ( am I right, @Charlie  ? ).

mwellbro_0-1593171712591.png


The TCPH-DDL I found was not quite complete, so the ER isnยดt either - plus the FKยดs did not get linked automatically....I wonder if thatยดs just me or there is actually something missing here ?

Xpert

The issue with non existing foreign keys is fixed in version 7.1.2 which will be released on 6th of Juli.

I had long going plans for something I know from Toad 

https://github.com/dbeaver/dbeaver/issues/1076

Perhaps I find the time to implement this in the near future.

Regarding the initial question of this thread I would take a look at https://dbschema.com/

Xpert

I think this is related to the issue https://github.com/dbeaver/dbeaver/issues/8457

I'm currently busy optimizing meta data query performance so I was unable to fix this.

 

Community Manager
Community Manager

DBeaver also seems to work well ๐Ÿ™‚ 

 

Annotation 2020-06-26 135447.png

 

Sports Enthusiast. Database Guy. Member of Team Exasol.
Having trouble? Just let me know!

Please Give Kudos if you find this post useful and also mark this as Accepted Solution if this is the required solution

Community Manager
Community Manager

Actually, DBVisualizer can do this. Within the Database Objects, you can open the schema you are using, and then click on "Tables" and choose References (Schema Browser -> click the drop down for your schema, click on Tables (or right click and choose open in new tab), then choose references). This might also only be available with the licensed version of DbVisualizer. I can also save it as an EMF file. Here's a screenshot of the TPCH Dataset from the Public Demo:

Annotation 2020-06-26 125134.png

Might be something for you to try out using a free trial of DBVis if you don't already use the paid version. Hope it helps!

Sports Enthusiast. Database Guy. Member of Team Exasol.
Having trouble? Just let me know!

Please Give Kudos if you find this post useful and also mark this as Accepted Solution if this is the required solution

Contributor

Hi Nico,

thanks for pointing me to DBVisualizer. Actually my initial question is somewhat ill-specified since I'm interested in visualizations of the dependencies of views (ideally down to the lowest level of dependent tables/views). Hence, the term ERD is misleading here.

With DBVis the tab "Dependencies" shows the dependent tables/views, but only in a tabular format and only the first level dependencies.  In case the view itself depends on a view, I'd like to visually present/document this dependency as well.

Best regards,

Jan    

Community Manager
Community Manager

Hi Jan,
would you be willing to share your best practice doing this in an article on the community?
Best regards
exa-Chris

Connecting Customers, Partners, Prospects and Exasolians is my passion. Apart from that I cycle, listen to music, and try to understand what all those technical discussions really mean...

Xpert

Hi Jan,

now this is where it getยดs interesting ๐Ÿ™‚ - you might want to look at EXA_DBA_DEPENDENCIES_RECURSIVE , it should give you the referenced objects and you could visualize from there ?

Cheers
Malte

View solution in original post

Contributor

Hi Malte,

nice ๐Ÿ™‚ I think doing the viz by myself based on that table should do it for now.

Thanks,

Jan

Team Exasol
Team Exasol

@janh   I will ask the DBVisualizer guys if there is an easy way to maybe visualize the Dependencies in that tap in a recursive way.  Looks like a very useful feature.

Xpert

Hi Jan,

Iยดm not aware of any tools that work "out-of-the-box" in this context, Iยดve had reasonable success in using MicroStrategy with a network-visualization but thatยดs probably a bit to specific to count as advise...
I think thereยดs ERWIN which probably costs a bit of licence....you could try oracle data modeler... ๐Ÿ˜‰

Cheers
Malte