Visualization of existing Oracle Databases

In Luna Modeler, all database connections are available in the Connections section.

How to create a new connection to your Oracle Database

To create a new connection, click the Connections button on the main toolbar, and then click Create New Connection. A new modal form opens. Select Oracle and enter the connection details.

How to create a new database connection to Oracle Database in Luna Modeler.

When you are finished, click the Save Connection button. Your new PostgreSQL connection will appear in the list of all database connections.

Loading existing database structures

To start the reverse engineering process and to create a project with an ER diagram, navigate to your connection and click Connect and load the existing database structure.

A list of Oracle Database connections stored in Luna Modeler - database design tool for Oracle

As a result, you will see the ER diagram for your database structure. If you reverse engineered multiple schemas, you might find it useful to enable the Display schema mode.

Option to display schema in ERD for Oracle Database.

In the Professional edition of Luna Modeler, you can also split the main diagram to multiple sub-diagrams by schemas.

A context menu with the Add diagrams by Schemas item.

If you wish to visualize another Oracle Database, either create a new connection or create a copy of an existing connection by clicking the Duplicate link.

#

DATA MODELING TOOLS
DRAW Diagrams and
GENERATE Scripts
Download data modeling tools
Blog Categories
Blog by Platforms