Skip to Content

Accessing PowerDesigner Internal Object Identifiers

Hi,

I am a fairly novice SAP PowerDesigner (PD) user. Our organization uses PD to for Conceptual, Logical, and Physical Data Models.

We recently undertook an initiative to build a custom user-friendly web-based Data Governance tool, external to PowerDesigner. We are hoping to export our Logical Entities, Attributes, and LDDs from PD to the Data Governance tool, and then keep them in-sync going forward with changes PD. Same goes for the Physical Tables, Columns and PDDs.

The challenge is that once we have the PD objects in the Data Governance Tool, we are extending the properties, plus linking them to other PD objects and/or non-PD objects. We cannot do a complete re-load each time. Any new PD objects should be inserted into the Tool, but updated PD objects should be updated in-place within the Tool.

How would we link the PD Objects to the Tool Objects? We can't use the Object Name, because it might change. The Object Code also seems to change when the Name is changed - can this be disabled? Or Is there an internal PD object identifier we might be able to access, which would never change?

Other suggestions?

Thanks....

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Aug 01, 2018 at 06:13 AM

    You need the ObjectID property, Michael. values will look like this:

    72E72A5F-D174-4825-9F72-A67009C8D003

    Add comment
    10|10000 characters needed characters exceeded

    • @John Stinnett - last time I saw a Collibra roadmap, they were planning to include a PD-Collibra connector in their marketplace around about now. I know it's possible, I helped them build one for a client of theirs last year :). The bad news is that this connector (at least, the one we built last year) is triggered manually:

      • upload from PD by running a model export in PD to create a JSON file from the model, which is posted to a location monitored by Collibra
      • download from Collibra by generating an export file, and using a VBscript program to create a model in PD, which the user then would manually compare with the original model in PD

      You can check the automation options by looking at the stuff that comes with PD - look in this folder:

      C:\Program Files\SAP\PowerDesigner 16\Ole Automation