How to create a database diagram with Enterprise Architect and an Oracle database?

Question

I need to create a database diagram in Enterprise Architect.

I understand how I can create each table and add the columns by hand. But that will take me a really long time.

The database is Oracle 11g and I use Oracle SQL Developer.

Is there any way to export/import the database schema into Enterprise Architect ? I can't figure out how to create a connection to my database.

What commands did you try?

John Saunders
– John Saunders

2012-12-13 23:39:20 +00:00
Commented Dec 13, 2012 at 23:39 — John Saunders
– John Saunders, Commented Dec 13, 2012 at 23:39

chimp · Accepted Answer · 2012-12-14 01:03:11Z

2

You need to have an ODBC connection to your database. Then you can select a package in the Project Browser, right-click > Code Engineering > Import DB schema from ODBC...

answered Dec 14, 2012 at 1:03

chimp

1,84910 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to create a database diagram with Enterprise Architect and an Oracle database?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related