Convert PDM to CDM

Understanding PDM and CDM file formats

PDM (Physical Data Model) and CDM (Conceptual Data Model) are file formats commonly used in database modeling tools such as PowerDesigner. A PDM file represents the physical implementation of a database, including tables, columns, indexes, and relationships as they exist in a specific database system. In contrast, a CDM file describes the high-level structure of data, focusing on entities, relationships, and attributes without implementation details.

Why convert PDM to CDM?

Converting a PDM to a CDM is useful when you need to abstract the physical details and return to a conceptual view of your data model. This can help in documentation, communication with non-technical stakeholders, or when redesigning the database structure from a business perspective.

How to convert PDM to CDM

The most reliable way to convert a PDM file to a CDM file is by using PowerDesigner by SAP, as it natively supports both formats and provides built-in conversion tools.

Steps using PowerDesigner

1. Open your PDM file in PowerDesigner (File → Open).
2. Go to Tools → Generate Conceptual Data Model.
3. Follow the wizard to select the objects and relationships you want to include in the CDM.
4. Save the generated CDM file (File → Save As).

Best software for PDM to CDM conversion

PowerDesigner is the industry standard for working with PDM and CDM files. It offers seamless conversion and advanced modeling features. There are no widely recognized third-party converters that support this conversion as reliably as PowerDesigner.

Tips and considerations

• Some physical details may be lost during conversion, as CDM files do not store implementation-specific information.
• Review the generated CDM to ensure all necessary entities and relationships are correctly represented.
• Always back up your original PDM file before conversion.