today I quickly wanted a visual representation of an oracle schema and remembered that oracle provides sql developer data modeler which will do this for me. headed over to the download page, wanted to download … ups, only a rpm available for linux.
but, there is alien and this makes the conversion from a rpm to a deb package straightforward and easy:
$sudo apt-get install alien $sudo alien datamodeler-3.3.0.744-1.noarch.rpm Warning: Skipping conversion of scripts in package datamodeler: postinst Warning: Use the --scripts parameter to include the scripts. datamodeler_3.3.0.744-2_all.deb generated
done. installed:
$sudo dpkg -i datamodeler_3.3.0.744-2_all.deb Selecting previously unselected package datamodeler. (Reading database ... 150737 files and directories currently installed.) Unpacking datamodeler (from datamodeler_3.3.0.744-2_all.deb) ... Setting up datamodeler (3.3.0.744-2) ...
ready to use:
$which datamodeler /usr/local/bin/datamodeler $ datamodeler Oracle SQL Developer Data Modeler Copyright (c) 1997, 2011, Oracle and/or its affiliates. All rights reserved.
data modeler
Daniel Westermann's Blog 
Reblogged this on Sutoprise Avenue, A SutoCom Source.
Thanks. It’s working.
Thank You Its working :)
Both zip packages labeled windows contains starting point for linux. In root directory you will find sqlmodeler.sh. No need to use rpm packages labeled linux. Work out of box on my Xubuntu 14.04 with java installed. One of the windows packages contains ready to use jre if java is not installed.
Thanks for the Hint Rufus. Makes life a lot easier :)
Cheers, Daniel
Hey guys,
I’ve got it running, too.
But I can’t select data types for columns.
When I create a new table and add a column with data type “logical” the combo box TYP contains “unknown”, only.
(I’ve used the Data Modeler with Windows before, it’s working there).
Any ideas?
Thanks & Best,
Chris
did you try to click on the “unknown” button/text? works for me
cheers
daniel
yes…but the combo box is not opening… :/
cheers.
Chris
which version of datamodeler are you using? which jdk?
For me this combination works:
datamodeler-4.0.2-840-no-jre.zip
openjdk-7-jdk_7u65-2.5.1-4ubuntu1~0.14.04.1_amd64.deb
linux mint 17
cheers
daniel
jdk: java-7-openjdk-amd64
data modeler: Version 4.0.2.840
ubuntu 14.04 LTS
same for FKs….damn!
Need to startup win7 again :/
or switch to mint :)
Thanks! This works for me (: