Oracel Designer/ERWIN/PowerDesigner

[Guest_imported]

I am gathering some information on Oracle designer , ERWIN and PowerDesigner and trying to compare these tools. I have used Oracel Designer a bit.
Please post comparision of these 3 tools.

TIA

 

[spenglerr]

Hugh,

that's quite dangerous. You will find always developers who prefer the one or the other tool, if you find any that have worked with more than one of them.

First it is quite long ago that I worked the last time (3years) with PowerDesigner. It had good features to get a database model and redesign it then. We liked working with it, but had a lot of troubles concerning the request-rights and connection to the Oracle databases. In this times it didn't like the Oracle 8 drivers and you had to work all the time with old 7 drivers to connect to the database even though 8i was about to get released. I don't think this is still a problem.

I like ERWin as a tool giving you the possibility to do ERM-modelling, but I miss the Business Rule-/ Function-/ Data-Flow-Management facilitites. To get them you will have to buy an Extra license of the Process Modeler and/or Model Manager, Data Model Validator. I also don't like that the relationship-drawings are vanishing when they are below a table. This is better in the Oracle Designer.

At present I am only rarely working with ERWin, just for compatibility reasons. I prefer working with Oracle Designer since I have the possibilities to do Upper CASE as well as Lower CASE. Also it is quite nice when you are using Versioning to work with developer groups! As well as the possibility to get a nice ISO9001 documentation with it, that you can personalize to your companies QM by using the repository reports. The features to find inconsistencies by repository reports are also quite nice, as well as the possibiltites to work together with Oracle Forms and Reports in a quite easy way. But I miss the possibilities of Modelling with Java and an interconnection to the JDeveloper.

So actually I think all three tools are a good choice, but you will have to look what you intend to do with these tools. If you plan to use Oracle Developer also, then Designer is the best choice to have all business and application logic in a central repository and do just the layout in the special tools then. If you are working with Java it doesn't look that good, since Designer misses the object-oriented features and java programming features. But I can't tell PowerDesigner will guide you with that. But I'm sure ERWin won't.

 

[CASEsearching]

Hi,

I am doing the research about Oracle9i designer and Powerdesigner. I am also wondering what the differences between them. Are they both I CASE tool? What are the major differences between them? Thank you.

Best,
Catherine.