Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
General
GeneralPortable MacsHardwareNetworking
Applications
Mac ApplicationsEudoraFirefox / MozillaInternet ExplorerOutlook ExpressMS OfficeEntourageExcelPowerPointWordVirtual PCMedia PlayerOther MS Products
Programming
Mac ProgrammingCodeWarriorPerl
Country Specific
Australian Mac GroupUK Mac Group

Mac Forum / Programming / Mac Programming / September 2005



Tip: Looking for answers? Try searching our database.

ER Diagram tool

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
lrojas - 15 Sep 2005 19:48 GMT
Hi all,

i been looking around and i was wondering if one of you guys know of a
tool similar to PowerDesigner :
http://www.sybase.com/products/developmentintegration/powerdesigner

Anybody know of any alternatives that run on the mac?

thanks in advance

Luis R. Rojas
Rob Cowie - 16 Sep 2005 22:02 GMT
> Hi all,
>
[quoted text clipped - 7 lines]
>
> Luis R. Rojas

Visual Paradigm is good (http://www.visual-paradigm.com/product/)

Eclipse - the well known IDE has many UML/ER/andbusiness process
plugins. (www.eclipse.org)
Simon Slavin - 18 Sep 2005 15:54 GMT
On 15/09/2005, lrojas wrote in message
<1126810134.488906.95790@g14g2000cwa.googlegroups.com>:

> i been looking around and i was wondering if one of you guys know of a
> tool similar to PowerDesigner :
> http://www.sybase.com/products/developmentintegration/powerdesigner

It's just another development environment.  There are at least 40 for
the Mac.  What is it that you actually want when you ask for 'similar' ?
Are you restricted to Java ?  Or to J2EE ?  Or do you just want to write
programs and not care what language they're in ?  Do you need cross-
platform compiled code ?

Simon.
lrojas - 28 Sep 2005 20:45 GMT
i would like soemthing as simple as being able to make the
Entity-Relationship diagrams fro Database Objects, be able to put in
graphic format how tables in an Oracle Database link to each other?
wich fields are Primary key and wich ones are Foreign Keys.

If this also generates SQL code it would be a plus but right now i
would be content with the diagraming part.

thanks in advance.

Luis R. Rojas
David Phillip Oster - 29 Sep 2005 04:04 GMT
> i would like soemthing as simple as being able to make the
> Entity-Relationship diagrams fro Database Objects, be able to put in
[quoted text clipped - 3 lines]
> If this also generates SQL code it would be a plus but right now i
> would be content with the diagraming part.

XCode will let you do the diagrams, and even produce code form the
diagram (for MySQL or XML). You probably already have it
/Developer/Applications/ Read up in its on like help on its "Design"
menu.

Signature

David Phillip Oster

Chris Hanson - 29 Sep 2005 04:44 GMT
> XCode will let you do the diagrams, and even produce code form the
> diagram (for MySQL or XML). You probably already have it
> /Developer/Applications/ Read up in its on like help on its "Design"
> menu.

This is incorrect in several ways.  Xcode contains ER-style data
modeling tools for the Core Data framework that's part of Cocoa.  This
produces data models that can be used by Core Data to manage and
persist your object graph using several different persistent store
types, including SQLite (not MySQL) and XML.

The data modeling tool in Xcode is not a general database-design ER tool.

 -- Chris
David Phillip Oster - 29 Sep 2005 16:38 GMT
> > XCode will let you do the diagrams, and even produce code form the
> > diagram (for MySQL or XML). You probably already have it
[quoted text clipped - 10 lines]
>
>   -- Chris

Chris is right: I should have written SQLite, not MySQL.

The original poster wanted an E-R graphing tool. I point to a portion of
XCode that does that, possibly well enough.

Signature

David Phillip Oster

Chris Hanson - 29 Sep 2005 20:01 GMT
> Chris is right: I should have written SQLite, not MySQL.
> The original poster wanted an E-R graphing tool. I point to a portion
> of XCode that does that, possibly well enough.

Right, my point is that the Core Data modeling tools are specific to
Core Data and cannot reverse-engineer arbitrary databases or XML into
ER diagrams, and cannot generate SQL or XML schema with which to
generate databases or XML.  These are two features the original poster
specifically brought up that disqualify the Core Data modeling tools
that are included by default with Xcode 2.0 and later.

Actually though, you *are* correct for people who have both Xcode 2.1
and WebObjects 5.3 installed.  (WebObjects 5.3 developer tools are
included free with Xcode 2.1 as an optional install.)  There is an
Xcode-based modeling tool for the Enterprise Objects Framework in
WebObjects 5.3 that includes a subset of EOModeler.app's functionality.
EOModeler.app is also included; it can reverse-engineer an EOModel
from an existing database, you can work with this EOModel in either
EOModeler.app or the Xcode EOModel tool, and you can generate an SQL
schema from an EOModel.

So really, you're right, if the original poster installs WebObjects.

 -- Chris
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.