how to create er diagram for hana tables?

[Former Member]

Hello experts,

What's the easiest way to create an ER(Entity Relationship) diagram for tables in HANA? Or alternatively find relations among HANA tables?

As I think this is a common request for every RDBMS like Oracle or MySql and it can be really helpful for data modeling or application development.

Thanks in advanced,

Marshall

[lbreddemann · Accepted solution]

You could use PowerDesigner for this kind of thing.

However, most SAP applications don't implement foreign key constraints so in terms of discovering relationships your chances may be slim, regardless of the tool used.

[Former Member · Accepted solution]

And even if you properly declare foreign keys in SAP HANA, PowerDesigner is not able to retreive them. From a SQL file, it is not good at that part of the reverse-engineering job either.