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

oracle enterprise-architect oracle-sqldeveloper database-diagramming database-diagram
jeph perro picture jeph perro · Dec 14, 2012 · Viewed 12.7k times · Source

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.

Answer

chimp picture chimp · Dec 14, 2012

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

Related questions

Get list of all tables in Oracle?

How do I query an Oracle database to display the names of all tables in it?

Read More
How do I limit the number of rows returned by an Oracle query after ordering?

Is there a way to make an Oracle query behave like it contains a MySQL limit clause? In MySQL, I can do this: select * from sometable order by name limit 20,10 to get the 21st to the 30th rows (skip the …

Read More
ORA-12514 TNS:listener does not currently know of service requested in connect descriptor

We have an application running locally where we're experiencing the following error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor I've tested the connection using TNSPing which resolved correctly and I tried SQLPlus to try …

Read More