Solved

Graphical Database Designer for the 400

Posted on 2004-04-27
7
207 Views
Last Modified: 2013-12-03
I need to look into some options for a graphical database designer for the 400.  Does anyone have any suggestions on some?
0
Comment
Question by:kdemaria
7 Comments
 
LVL 14

Expert Comment

by:daveslater
ID: 10929449
Hi
a lot of the case tools for the AS/400 have that type of function (ie synon, Lansa) I am not sure if they are sold as a separate.

Dave
0
 
LVL 1

Expert Comment

by:Helixir
ID: 10930908
What is a graphical database designer ?
0
 

Author Comment

by:kdemaria
ID: 10932321
It's a tool that allows you to design tables and their relationships visually.  The way it has been described to me is the look and feel is something like Visio, but it allows you to define tables and their relationships.
0
 
LVL 1

Expert Comment

by:Helixir
ID: 10932358
Oh ok !! I think Windev ( www.windev.com ) had a tool like this !!
You can desing your DB and create them on the 400.
0
 
LVL 18

Accepted Solution

by:
daveslash earned 50 total points
ID: 10960363
The industry leader (across almost all database platforms) is ERwin.  (I believe they call it Allfusion ERwin now.)  It's currently made by Computer Associates (since CA bought Platinum which bought Logic Works), and it's full of rich functionality to incorporate almost all aspects of your database schema. Since it works for multiple database platforms, it also makes it easier to convert a schema from one platform to another.

Back when I was a database administrator, I used it EVERY DAY for about five years.

Embarcadero also makes a very good product called DBArtisan.  I've tried it out (and it looks pretty good), but I'm not at all an expert on the product.

With ERwin's many strengths, they do have a few long-standing weaknesses that deserve mention. First, they really don't care too much about their AS/400 functionality.  It works ... but it's not up to the level of their Oracle and SQL Server functionality.  In speaking with the ERwin's product manager a few years ago, he told me that the AS/400 is a VERY small fraction of their business, so it didn't make sense to spend a lot of time enhancing the AS/400-specific features.

Also, they can be EXCRUCIATINGLY slow in fixing bugs. I reported MANY bugs to them in those five years. Some that I reported in 1999 are STILL not fixed, and those that were fixed took a LONG time to get fixed.  (Since CA is such a big company, it's easy to get lost in the administratia.)

Someone recently told me that Microsoft had added data modeling capabilities (and DDL generation functionality) to Visio, but I've not tried it.

HTH,
Dave
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article outlines why you need to choose a backup solution that protects your entire environment – including your VMware ESXi and Microsoft Hyper-V virtualization hosts – not just your virtual machines.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question