Venzi's Tech-Blog

3 November 2008

Finally a good tool for Data Modeling: Oracle SqlDeveloper Data Modeling

Filed under: Oracle,Work — Venzi @ 12:42

How long did you search for a good tool to do Data Modeling. Well not long I guess, I always used Microsoft Visio for it. But how long did you search for a tool to create a Data Model and export the DDL statements or vice versa and also for one which is free? I did it now for around 4 year and then I found this blog entry: Finally – free tool for Oracle Data Modeling

It’s called Oracle SqlDeveloper Data Modeling

I just downloaded it and tried it out: It’s absolutely nice. You can create logical models like you know it from Visio but you can also create relational models where you can already define column data types, constraints and so.

But not even that, you can create relational models out from logical and vice versa!

Oracle SqlDeveloper Data Modeling can also export it to DDL (a feature I searched long for!). And even better: You can choose which DDL (Oracle 9i, 10g, 11g; SQL Server 2000, 2005; DB2 7, 7.1, 8, 8.1). The only bad thing: MySql isn’t supported right now 😦 (Already gave feedback on that! πŸ˜‰ )

Of course you’re also able to play it the other way round and import DDL and create a datamodel out of it – really cool stuff! And you can again import it for any databases listed above!

And now the best feature: If you’ve access to the DB catalog, you can even create a data model out of an existing schema!

Sorry for the grey shadows but a little bit of data protection must be! πŸ˜‰

All in all Oracle SqlDeveloper Data Modeling is really a good tool. It has lots of more features which I didn’t try out so far (Design Rules, Multidimensional Models, Process Models, …) and the best thing: It’s free – at the moment. It seems that there were some rumors about a license for this tool. We’ll see!



  1. nice tool, gibts das auch fΓΌr OSX?

    Comment by schmidi — 7 November 2008 @ 13:37 | Reply

  2. Klar, ich benutz nur Tools, die auch auf meinem MacBook funktionieren! πŸ˜‰

    Comment by venzi — 7 November 2008 @ 13:54 | Reply

  3. […] Venzl writes that he has found a good tool for Data Modeling: Oracle SqlDeveloper Data Modeling. He has put it through its paces and has the results for […]

    Pingback by Log Buffer #122: a Carnival of the Vanities for DBAs — 7 November 2008 @ 19:40 | Reply

  4. There is already a tool for MySQL like this… and its there since several years. Search for FabForce DBDesigner or its successor MySQL Workbench.

    But nice to have this for Oracle DBs πŸ™‚

    Comment by Marco — 7 July 2009 @ 22:31 | Reply

  5. Interessant!
    Was kostet das Tool (wir wollen es nicht ewig lang “ausprobieren”)?

    Comment by OracleFan — 1 February 2010 @ 04:59 | Reply

  6. Tja, das ist die traurige Nachricht:

    Zu Anfang war es gratis, jetzt moechte Oracle satte 3000 Dollar pro Named User!
    Das Gute ist, dass ich noch eine Version habe, die damals gratis war! πŸ™‚

    Comment by venzi — 1 February 2010 @ 07:59 | Reply

  7. […] Finally a good tool for Data Modeling: Oracle SqlDeveloper Data Modeling November 2008 6 comments 5 […]

    Pingback by 2010 in review « Venzi's Weblog — 2 January 2011 @ 18:56 | Reply

  8. I am trying to create a data model using SQL developer. after successfully creating a connection to database i cant see any table names at the screen where it asks to “Select the objects you want to import” .
    I can query tables using SQL developer.

    Comment by Aashish — 20 September 2012 @ 18:55 | Reply

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at

%d bloggers like this: