Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
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