Although my experience with SQL Developer Data Modeling is limited yet, I have managed to gain some idea of its logical and physical data modeling function. It is a very powerful tool that compliments SQL Developer nicely and can connect to Oracle databases. The main purpose for this program is to allow users to lay out relational diagrams, which provide information on how entities within databases interact with each other.
I have identified only a couple of problems with this program thus far. First, the software is not available to Macintosh computers, which is a drawback for Mac users like myself. SQL developer is available for Macs, but not the data-modeling program. I guess the only way to deal with this problem is to wait for Oracle to release a program for Mac.
Another inconvenience I have found in using this program is that the data modeler is a separate program within itself. If Oracle could combine the SQL Developer program with the data-modeling program into one, users would not have to toggle back and forth between the developer and the data modeler.
Data Modeling users have documented many tutorials and tips as a reference for new users or people trying to troubleshoot problems. Also, there are many forums, FAQ rooms, blogs, and chat rooms that give further aid to users. Some of these resources can be found in the links below:
1. http://www.thecrumb.com/2008/12/02/developer-toolbox-oracle-sql-developer-data-modeling/
2. http://www.oracle.com/technology/products/database/sql_developer/files/Modeling.html
3. http://it.toolbox.com/blogs/oracle-guide/sql-developer-data-modeling-sod-25841
4. http://sueharper.blogspot.com/2008/10/first-early-adopter-oracle-sql.html
Below is a link that can compliment Data modeling users as it provides instruction on data mapping and other aspects of database programming.
http://philip.greenspun.com/sql/data-modeling.html
If more problems surface, these links can be very helpful in overcoming such obstacles. Also, many of the sites found above post updated information on news and current happenings in the Oracle and database fields, which can also aid in staying up-to-date with such a dynamic field.
