Best tool to create an Entity Relationship Diagram of a collection of Cache

Question

Nigel Salm · Apr 28, 2017

I have an Ensemble Application with many classes and relationships between those classes.

I need a tool that can connect to Cache/Ensemble and create a visual ERD from the class definitions within a particular Cache Namespace

MS-Access is one option but it does not automatically create the relationship connectors between classes

Any suggestions

Nigel Salm

0 4,676

Discussion (7)3

Eduard Lebedyuk · Apr 28, 2017

Datagrip can do it:

Also UML Architect. And there's Caché Class Explorer. There's also a script for PowerDesigner if someone needs that.

1 0

Evgeny Shvarov · Apr 28, 2017

I think @Nikita.Savchenko can promote his Caché Class Explorer more ;)

0 0

John Murray · Apr 28, 2017

Umlanji facilitates UML class diagrams, which aren't the same thing as ERDs but still pretty useful.

0 0

Bhaskar Bandyop... · Apr 28, 2017

Common SQL tools like WinSQL can do that, since Cache is a supported database in WinSQL

0 0

Fred Gustafsson · May 3, 2017

How do you import the class definition in DataGrip? Can you use the regular class export from Studio?

0 0

Eduard Lebedyuk · May 5, 2017

No, just add your Cache server as DataSource. DataGrip uses jdbc. Here's sample connection screenshot.

0 0

Best tool to create an Entity Relationship Diagram of a collection of Cache/Ensemble Classes