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!
9 thoughts on “Finally a good tool for Data Modeling: Oracle SqlDeveloper Data Modeling”
nice tool, gibts das auch für OSX?
Klar, ich benutz nur Tools, die auch auf meinem MacBook funktionieren! 😉
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 🙂
Was kostet das Tool (wir wollen es nicht ewig lang “ausprobieren”)?
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! 🙂
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.