Poputlate diagram with elements from SQL

[skiwi]

Is it possible to populate a diagram using a SQL query to acquire the elements

[Eve]

It is for a Kanban diagram. Which is just a diagram showing the elements in columns.

[Geert Bellekens]

Pretty easy to do with a script, but you can also do it manually.
Use the SQL query in a search, and then drag the elements from the search results to the diagram.

Geert

[skiwi]

Thankyou both.


I need to add to my requirements, I simply want the diagram, when opened, to run the SQL script to populate the diagram.

[Paolo F Cantoni]

Thankyou both.


I need to add to my requirements, I simply want the diagram, when opened, to run the SQL script to populate the diagram.

We run our auto-populate scripts (MS Access macros) outside EA via our Helper process.  In our case, the population doesn't need to be live so we can schedule the updates externally.

Paolo

[Geert Bellekens]

I once did something similar with an ea-matic script. See https://bellekens.com/2015/01/30/self-maintaining-diagrams-in-enterprise-architect-with-ea-matic/

Geert