Skip to Main Content

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
Post Details
Added on Jun 26 2020
1 comment
260 views