I’ve shown how to drag and drop database tables from Oracle SQL Developer into a design. But I’ve never done a start-to-finish, blow-by-blow post on how to import your existing database objects into a data model with SQL Developer.

So let’s do that now.

Warning: Lots of pictures coming up.

Start with a new design, make sure you have a Relational Model to import to.
Start with a new design, make sure you have a Relational Model to import to.
Now go to the file menu and start the import.
Now go to the file menu and start the import.
You can import existing connections from Oracle SQL Developer if you have them - note that you need v4.0.3 of the modeler in order to bring over the passwords.
You can import existing connections from Oracle SQL Developer if you have them – note that you need v4.0.3 of the modeler in order to bring over the passwords.
To create a new connection, put in your username, etc. You can test your connection before you hit 'Ok' if you want to save yourself some time in case you made a mistake.
To create a new connection, put in your username, etc. You can test your connection before you hit ‘Ok’ if you want to save yourself some time in case you made a mistake.

Want to import from SQL Server (or DB2) instead? Check out this great post from Oracle ACE Director @kentgraziano on how to get SQL Server connectivity going in SQL Developer Data Modeler.

You can set some import options here - if you have TONS of partitions - skip them and save a bunch of time.
You can set some import options here – if you have TONS of partitions – skip them and save a bunch of time.
Use the search filter to quickly find your objects and use the Check All box to save yourself some clicks - do this for all the types of database objects you want to import
Use the search filter to quickly find your objects and use the Check All box to save yourself some clicks – do this for all the types of database objects you want to import
Does this look right? If so, hit the 'Finish' button.
Does this look right? If so, hit the ‘Finish’ button.
Your model now has the database objects, and here's a log reminding you what was imported and when.
Your model now has the database objects, and here’s a log reminding you what was imported and when.
Don't forget to save your design!
Don’t forget to save your design!
Ok, it's saved. But now maybe you want to add it to your design repository for change tracking and source control?
Ok, it’s saved. But now maybe you want to add it to your design repository for change tracking and source control?

For Extra Credit

thatjeffsmith
Author

I'm a Master Product Manager at Oracle for Oracle SQL Developer. My mission is to help you and your company be more efficient with our database tools.

8 Comments

  1. Hi Jeff,
    i can start SQL Developer correctly with tns. But If I start data mdeler and try to connect to database with tns, the comobox network alias is empty, i can not get my db.
    I have also tried to set the path for tnsnames.ora in Sql Developer, but the comobox is still empty. What ist wrong? on the maschine ist an oracle client installed. but we use tns.
    Thanks in advance for your help
    Dahei

    • thatjeffsmith

      Version of Data Modeler?

      Did you check the TNS preference? ‘TNS Names Directory’ on the Data Modeler page of Preferences.

  2. Hi Jeff,
    I tried this step by step. First with HR database and it was working fine and i got ERD and later i got the logical model.
    When i tried to apply the same steps on my one of databases at work. It generated just boxes with no relations.

    SOS

    Regards,
    Irfan

  3. Hi Jeff,

    I get an ORA-00942 Table not found error when I choose a connection and press ‘next’. (The connection test was passed successfully.)

    Again, I suspect that some grants/privileges are missing. Can you give me a hint which objects are accessed during this step?

    Thank you,
    Sabine

Write A Comment