Entity Relationship Diagram Tool

Author: cdouglass@siriussoftware.com.au (Colin)

Hello Everyone, Uniface many years ago had a tool that would draw a diagram of a model including all the relationships etc. That module had some problems and was withdrawn. Is there anything I can use now to do the same thing? If not in Uniface is there some 3rd party software that can read a Uniface model and do the same thing? I am currently using Uniface 9.7 Thanks, Col Douglass

12 Comments

  1. Hi Colin I found graphviz (https://www.graphviz.org/) You just have to create a textfile with all relations (form UCRELSH) and graphviz will "paint" the diagram. Here are some example what's possible by graphwiz: https://www.graphviz.org/gallery/ I you have time and muse, one can enrich the graphic by various attribute found in UCRELSH,UCKEY,UCTABLE,UCGROUP,UCFIELD,... BTW: Read out UXCROSS and you have a call-graph of your components. But this could very, very large and unreadable :-) Ingo


    Author: istiller (i2stiller@gmx.de)
  2. Hi Col, the "Define Application Model Properties" form has a button "Diagrams..." HIH from Frankfurt/Germany, Uli


    Author: ulrich-merkel (ulrichmerkel@web.de)
  3. Hi At OpenUnifaceCommunity I shared an Uniface's plugin to extract entity relationships in DOT language (from graphviz, more info in link shared by Ingo). The plugin's name is Uniface DOT language interface and ask you the entity name and the number of "jumps" to get a picture of what is around. In this example, was selected entity WPVUSU with 2 jumps. diagram Shows inter-model relationships as a dashed line. Also, it is able to extract a complete data model. For the same price ;-) you can do something similar with components. It uses a graphviz's javascript to paint the diagram in a form or you can export it as a file.   I guess you need to sign up at OpenUniface gitlab's site. Feel free to use it.   Regards   Luis Vila


    Author: luis.vila (luis.vila@uniface.es)
  4. I have just signed up and I can't see it anywhere, clicking the link gives me a 404 error.  Regards,  Iain


    Author: Iain Sharp (i.sharp@pcisystems.co.uk)
  5. Thank you for saying it. It is at Add-ons section. I am contacting with administrator to solve the problem.   Regards Luis Vila


    Author: luis.vila (luis.vila@uniface.es)
  6. ulrich-merkel said Hi Col, the "Define Application Model Properties" form has a button "Diagrams..." HIH from Frankfurt/Germany, Uli  

    Thanks Uli, I've probably seen that button every working day for years and it never registered with me.   Col Douglass


    Author: Colin (cdouglass@siriussoftware.com.au)
  7. Hi Col, I re-learned the diagrams attending the "Uniface First Class Training – Essentials & Client/Server" recently. Pretty good to get back "the complete picture" of U97 after 25 years with uniface as a tool.


    Author: ulrich-merkel (ulrichmerkel@web.de)
  8. luis.vila said At OpenUnifaceCommunity I shared an Uniface's plugin to extract entity relationships in DOT language (from graphviz, more info in link shared by Ingo). It uses a graphviz's javascript to paint the diagram in a form or you can export it as a file. Luis Vila  

    Great job, Luis And if one wants to include the diagrams into a documentation: With the windows package of graphviz downloaded so we have dot.exe and its dlls, the exported .GV file can be converted to graphic files like bmp, gif, svg, png or even pdf. Looking into the powerful grammar of DOT, there are a lot of nice options from extending the information by adding some interactive tooltips to the diagram. Uli


    Author: ulrich-merkel (ulrichmerkel@web.de)
  9. Thanks Uli  DOT is wonderful. At the very beginning I had a daily process that built component diagrams using SQL scripts just to see how my projects were growing. After this, it is evolving as a tool to understand customers' systems I have to [understand and] repair. My wish is to get a configurable data model diagram like this: And to implement a more sophisticated and useful component diagram like this one:   The project is at OpenUnifaceCommunity to be possible anyone could participate.   Regards


    Author: luis.vila (luis.vila@uniface.es)
  10. Hi Luis, in the last years I created a couple of Codegenerators based on Xtext/Xtend. One option is split your current module to support 2 steps: At first, we generate a "raw data" version of the DSL file (which is not DOT langauge) from your repository (as you do already).

    entity EntA entity EntB relationship EntA -> EntB

    Then one can use the Eclipse based editor for a controled annotation of the raw data (like a "reddish" display).

    entity EntA reddish entity EntB relationship EntA -> EntB

    Saving the DSL file will result in the generation of the .GV file where EntA will be in red. Generating the raw data will help you a lot as all you have to do is adding the annotation and it is only highlevel info provided. If you are interested in a cooperation, send me a mail, Uli


    Author: ulrich-merkel (ulrichmerkel@web.de)
  11. It just crossed my desc, maybe it can advance supporting graphics like Sequence Diagram, Flowcharts, Class diagrams or GANTT, the mermaid looks promising at: https://github.com/knsv/mermaid as it's are based on a pretty simple specification text


    Author: ulrich-merkel (ulrichmerkel@web.de)
  12. I've been using the tool when it was available. It was very useful. After its gone i started using Creately as an alternative 


    Author: shalin (shalin@cinergix.com)