
Anonymous
Not applicable
2014-02-02
12:04 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Generate ERD diagram
Is it possible to generate an ERD diagram of my data model using Talend. Would save me from having to manually draw one out.
Thanks.
Thanks.
384 Views
4 Replies

Anonymous
Not applicable
2014-02-02
05:46 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Currently there is no way. I have searched for a solution and did not found anything but nevertheless it is possible to do that. You could parse the item files of your job, they contains everything whats needed.
At the moment I "paint" it also for my self, also because of the necessary tidy up of the picture.
I have made my documentation with the yEd editor. This is a graphml editor and therefore very capable to documenting sources and targets of a job and the job chain it self.
http://www.yworks.com/en/products_yed_about.html
For a database ERD diagram you could try the Oracle SQLDeveloper. This program is free and works also for other databases and can create ERD diagrams (also from an existing database)
At the moment I "paint" it also for my self, also because of the necessary tidy up of the picture.
I have made my documentation with the yEd editor. This is a graphml editor and therefore very capable to documenting sources and targets of a job and the job chain it self.
http://www.yworks.com/en/products_yed_about.html
For a database ERD diagram you could try the Oracle SQLDeveloper. This program is free and works also for other databases and can create ERD diagrams (also from an existing database)
384 Views

Anonymous
Not applicable
2014-02-02
08:09 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Jlolling, thanks for the reply.
I'll look into that piece of software, usually I would use MySQL workbench to generate an ERD but the database backend of MDM is slightly different to the data model (due to foreign key entity1_x_entity2 tables). It's not a huge deal I can make them myself.
I'll look into that piece of software, usually I would use MySQL workbench to generate an ERD but the database backend of MDM is slightly different to the data model (due to foreign key entity1_x_entity2 tables). It's not a huge deal I can make them myself.
384 Views

Anonymous
Not applicable
2014-02-03
05:28 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Agreed that the current tree-view representation is, to say the least, far from optimal. A UML-like graphical E/R diagram is on the roadmap (usual disclaimer applies).
384 Views

Anonymous
Not applicable
2018-07-05
12:39 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Is there an ERD feature now in Talend Open Studio for MDM?
Thanks
384 Views
