Skip to main content
Announcements
A fresh, new look for the Data Integration & Quality forums and navigation! Read more about what's changed.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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.
Labels (2)
4 Replies
Anonymous
Not applicable
Author

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)
Anonymous
Not applicable
Author

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.
Anonymous
Not applicable
Author

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).
Anonymous
Not applicable
Author

Is there an ERD feature now in Talend Open Studio for MDM?

Thanks