One Star

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.
3 REPLIES
Seventeen Stars

Re: Generate ERD diagram

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)
One Star

Re: Generate ERD diagram

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.
Employee

Re: Generate ERD diagram

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).