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!

Accessing Dynamic Properties of Entities, Tables, etc. via custom scripts?

bpederso-OracleMar 1 2011 — edited Mar 7 2011
I'm attempting to do some scripting so I will probably have a series of questions since the best scripting doc is still in this forum.

My first question is as follows. I would like to apply some transformation operation to some of the Tables (or perhaps Entities) in my model.
I see that there is a way to assign custom 'Dynamic Properties' to many artifacts within Data Modeler (including Tables, Entities, Relationships, etc.).
That seems to be what I would like to use. I would like to 'tag' some subset of Entities to have a certain identifying property such as "IsLookup".
Then later on I'd like to use such distinguishing 'tags' to selectively apply some transformation to a subset of my model.

What is the getter to use within scripting to find these Dynamic Properties? I searched the xml metadata and documentation (i.e. datamodeler/xmlmetadata/doc/list.html)
for potential getters and collections and couldn't find anything that looks like the Dynamic Properties.

I'll give an example of how I might want to use this. It does not appear that Dynamic Properties assigned to an Entity are carried forward to Tables
that are generated from those Entities. It might be useful to write a script that runs in the Relational Model and pulls Logical Model Entity Dynamic Properties forward to
the related generated Tables. Of course this also presupposes that a script that runs on the Relational model can 'reach back' into the Logical Model to find these things.


Thanks, BP


Pps. Is there any way to apply a custom transformation script within the forward engineering process?
It looks like it is only possible to apply a transformation script on a Relational model after it is already generated.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 4 2011
Added on Mar 1 2011
3 comments
740 views