Importing Your Data Dictionary to a new Oracle SQL Developer Data Modeler Design

thatjeffsmith SQL Developer 6 Comments

Tell Others About This Story:

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

  • Did you notice we got a SubView for each Schema we imported from?
  • Make the diagram look ‘nice’ – rearrange objects, change color schemes, etc.
  • Add your design to Subversion.
  • Tell Others About This Story:

Comments 6

  1. 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

    1. thatjeffsmith Post
      Author
      1. Hi
        Thanks for the quick reply, I really appreciate it.
        I do have some fields with the same name in the tables and that I usually use to do a join. Is there anyother way i can make a data model for this ?

        Regards,
        Irfan

      2. thatjeffsmith Post
        Author
  2. 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

Leave a Reply

Your email address will not be published. Required fields are marked *