Skip to Content
avatar image
Former Member

Metadata updates within PD

Hi All,

Need some expert advise on how to capture Metadata using PowerDesigner(PD).

We have some custom metadata which we maintain for all our projects (source extract data table/column name, to acceptable values, decommission date, personal identifiable information flag etc). Presently we are maintaining these within Excel. Although, once approved we move this metadata to data models in PD and eventually into the physical data objects as Oracle Comments. Any tweaks/updates to excel require the changes to be applied to PD and underlying objects.

We are trying to evaluate how PD could help attain efficiencies in this process. I did try to extend the properties of tables and comments but this seems to be a lot of work at the table/column level. Some of the data elements and metadata is more global in nature and common across projects. Ideally we’ll like to apply these updates to a single object.  Is there an alternative/easy way to do this?

Other options we are considering is to design a normalized database which captures all the underlying metadata. But I am not sure if this is the best way to address the matter.

Any help/thoughts on the matter would be truly appreciated. I must mention that I am fairly new to PD.

Regards!

Sujeev

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    May 31, 2016 at 01:45 PM

    So you have metadata at the column or table level but it will be common across a lot of the tables and columns within a model/project and you don't want to update it in a ton of places if you make a change?

    The way I would do it, would be to create some non-generated 'template' objects and a script to copy the values there to other objects.  You can centralize those template objects in another model if you want.

    If you add a property on each table to point at the object it got its defaults from, you could create an update routine to copy the new values down when you make a changes (or use an event to auto-update when you open the model).  We've done something similar in the past.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member George McGeachie

      Thanks George & Rich. I will explore the report options as well.

      Are there any PD Scripting tutorials available on websites? And do I need to have some special privileges plug in the scripts (or even write up extension files)?

      Thanks Gentlemen!!!!

      Sumit