topic Re: Generate ERD diagram in Talend Data Catalog

Generate ERD diagram

Anonymous — Sun, 02 Feb 2014 17:04:08 GMT

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.

Re: Generate ERD diagram

Anonymous — Sun, 02 Feb 2014 22:46:49 GMT

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)

Re: Generate ERD diagram

Anonymous — Mon, 03 Feb 2014 01:09:33 GMT

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.

Re: Generate ERD diagram

Anonymous — Mon, 03 Feb 2014 10:28:04 GMT

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

Re: Generate ERD diagram

Anonymous — Thu, 05 Jul 2018 16:39:10 GMT

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

Thanks