Oracle SQL Developer Data Modeler 19.4 Installation on Suse Linux Enterprise Desktop 15

Channel:

java frm

Subscribers:

5,740

Published on March 7, 2020 9:47:35 AM ● Video Link: https://www.youtube.com/watch?v=yNlRkMHNnx0

Duration: 3:22

68 views

1

In this video, we are going to see how to install and run Oracle SQL Developer Data Modeler 19.4 using Oracle JDK 8 on Suse Linux Enterprise Desktop 15.

Oracle SQL Developer Data Modeler is a free graphical tool that enhances productivity and simplifies data modeling tasks. Using Oracle SQL Developer Data Modeler users can create, browse and edit, logical, relational, physical, multi-dimensional, and data type models. The Data Modeler provides forward and reverse engineering capabilities and supports collaborative development through integrated source code control. The Data Modeler can be used in both traditional and in Cloud environments.

New Features in 19.4
- Added "Star Layout" option for diagrams in relational model
- Support for Implied Foreign Keys
- New features in foreign keys discovery dialog

Regular foreign key or implied foreign key can be created
Work on views
Looking in database for possible implied foreign key definitions - metadata for the following database objects are scanned: bitmap join indexes, materialized views with aggregations, attribute clustering, OLAP definitions (cubes and dimensions), analytic views and SQL dimensions
subview selector can be used to define the scope of analyzed objects

https://www.oracle.com/tools/downloads/sql-data-modeler-downloads.html