how to export ldm from sap power designer to excel or json file?

[sbs123]

hi how to export ldm from sap power designer into json format?

[GeorgeMcGeachie]

I've built a couple of JSON exports in the past, for Collibra and Solidatus JSON structures.

[Ondrej_Divis]

Hi,

You can easily export almost all metadata for a single object type at a time into Excel. Simply go to the menu: Model → Entity Attributes.... Here, you can filter the specific properties of Entity Attributes you want to display (use the green ellipsis in the screenshot below). After that, you can easily export the entire list to Excel (red ellipsis in the screenshot below). You can repeat this process for any other object types (entities, relationships, inheritances, etc.).

This method works well for a one-time export. If you're looking for a more automated or sophisticated solution, you have the following options:

1. Create List Report(s): These allow you to export (to CSV) directly from the Object Browser with just two clicks.
2. Build a custom export function: This will perform the export exactly according to your needs and give you the flexibility to format the output Excel file(s) as desired. This is possible thanks to the extensive extension and automation capabilities of the tool.
3. Create a custom JSON template: You can export by just two clicks after setting up your own JSON generation template.

Options 2 and 3 require some familiarity with PowerDesigner, but once you are comfortable, the possibilities are vast. If you need more help with this, feel free to reach out to me on LinkedIn - I`ll be happy to help.

Kind regards,

Ondrej Divis