Reverse Engineer

Hi all - I'm trying to reverse engineer and come up with physical and logical entity. I don't have ERWIN. Can anyone suggest any other open source or free tool or trial that you have used recently? I've tableau however I've not explored it yet. Any suggestions / recommendations kindly let me know.

Glenn

DB2 LUW

Hi,

There is a 30 day trial of IBM Infosphere Data Architect available  https://www.ibm.com/developerworks/downloads/r/rda/

 

Best regards,

Jørn Thyssen

Works for IBM Denmark. Views are personal. 

Thank you. Already started downloading :)

 

 

Gopalan Venkatramani

DB2 LUW

IBM Data Studio has this capability and is free.

If you want advanced capabilities you can always buy InfoSphere Data
Architect later (and shell share it).

Phil

On 20 Apr 2017 19:17, "Gopalan Venkatramani" <[login to unmask email]> wrote:

> Hi all - I'm trying to reverse engineer and come up with physical and
> logical entity. I don't have ERWIN. Can anyone suggest any other open
> source or free tool or trial that you have used recently? I've tableau
> however I've not explored it yet. Any suggestions / recommendations kindly
> let me know.
>
> Glenn
>
> DB2 LUW
>
> -----End Original Message-----
>

Hi again,

Minor correction: I have just learned that the trial license is now 90 days (not 30 days).

I assume you download the trial license key along with the software itself.

Best regards,

Jørn Thyssen

Works for IBM Denmark. Views are personal. 

I have always used Visio. You can connect to a database and import your tables into the software.  As long as you have your PK and FK it will auto map all relationships between tables otherwise you can manual create the relationships.  Although Visio is not free, but I believe it comes with MS Office so if you have MS Office at work then you should be able to use it. 

Another option with a 14-day trial is DbSchema (http://www.dbschema.com/) which is easy to use and inexpensive.

While Data Studio does have some functionality here, I have not found it to be terribly user-friendly. (Which is Data Studio in a nutshell , I think).

Greg Palgrave - This a wonderful piece of information. Whatever I was trying to do in Data Studio architect for past 3 days is achieved in less than 30 minutes and its terribly user friendly too. I'm like WOW !!!!! 

Thank you so much for this details. 

One question is that have you ever felt that some was there in Erwin , Data architect which is not out there on this tool ? Any important features ? Because I'm going to propose this tool to my company to buy this tool.

 

Let me know. Thanks again. Seriously its a great piece of information :)

 

 Glenn

DB2 LUW

Glenn,

Unfortunately I cannot compare it to Erwin , Data architect etc. so I cannot advise any shortcomings.

It may well have limitations, but it did what i needed when I tried it.

 

Cheers

Greg

Thank you. Its working fine for us. Thanks for sharing this information. 

Glenn

DB2 LUW