Skip to Main Content
Forums

SQL Developer Data Modeler

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Developer Datamodeler - Design Rules through scripts.

SaubhikJun 26 2020 — edited Jul 2 2020

I have recently started using SQL Developer Data modeler in my new project apart from the other commercial data modeling tools. I am having problems with the automation parts/ scripting parts. Generally Oracle products has very good documentation but this scripting part is not up to the mark.

I want to put all my design rule validations into a Library, I have only the Logical data model, relational is not generated till now, So, all the validations will happen in logical model only.

Now, I have created a Library. ti looks like:

pastedImage_0.png

The custom rule is defined as:

pastedImage_1.png

When I am applying this, to my surprise it is saying everything is fine! Shouldn't it return an false error with "xxx" for every entity in the logical data model?

What I am missing here?

EDIT: I already read about SQLDeveloperDataModelerScripting.docx, index,.html and the only book available on SQL Developer Datamodeler by Heli etc.
This post has been answered by Philip Stoyanov-Oracle on Jun 29 2020
Jump to Answer

Comments

Philip Stoyanov-Oracle
Answer

Hi @"Saubhik" ,

thanks for reporting the problem - I logged a bug.

You still can execute your design rules with correct result:

  1. just select several entities on diagram and in their context menu you'll find option for "Design Rules" and selected design rules will be applied to selected entities

  2. in context menu for diagram

Design_rules_in_diagram_context_menu.png

2.1) if it's a diagram for subview then rules will applied only for objects in theat subview

2.2) if it's the main diagram then rules will be applied for all objects in the model

Philip

Marked as Answer by Saubhik · Sep 27 2020
1 - 1

Post Details

Added on Jun 26 2020
1 comment
252 views