No results

    From PowerDesigner

    If you have data models in PowerDesigner and want to leverage them in Hackolade Studio, you need to first export them to XSD, following the instructions below.  Then you should consult this page for an overview of the import functionality in Hackolade Studio.


    You may refer to the following pages for more information: 


    To generate the XML model with configuration so primary keys and foreign key relationships:


    Generate a PowerDesigner physical model (PDM) from a logical model (LDM)

    If you already have a physical model, you may skip this step and go to the next one.


    You may also view this short video on YouTube.


    In PowerDesigner with your logical data model open, go to Tools > Generate Physical Data Model:


    PowerDesigner LSM to PDM menu



    Then choose the DBMS platform for the physical model

    PowerDesigner LSM to PDM general tab



    And make any changes necessary in the Detail tab for model check and or lineage.


    When you click OK, a physical data model gets created in PowerDesigner.  


    Generate a PowerDesigner XML model (XSM) from a physical model (PDM)

    If you already have an XML model, you may skip this step and go to the next one.


    You may also view this short video on YouTube.


    In PowerDesigner with your physical data model open, go to Tools > Generate XML Model:


    PowerDesigner PDM to XSM menu


    Then give your model a name:

    PowerDesigner - Export to XML General



    And in the Details tab, select the following options:

    PowerDesigner - Export to XML Details




    [optional] Click the Target Models tab and specify the target models for any generated shortcuts.


    [optional] Click the Selection tab and select objects to generate.


    Click OK to begin generation.


    You may have to setup the XML extension appropriately:

    PowerDesigner XML extension


    Generate an XSD file from a PowerDesigner XML model (XSM)

    You may also view this short video on YouTube.


    With your XSM model open, go to Language > Generate XML Schema Definition File


    PowerDesigner XSM to XSD menu



    Choose the destination for your output

    PowerDesigner XSM to XSD destination




    More info about XSM:


    Reverse-Engineer XSD file into a Hackolade model

    After the successful export of your model to XSD, use the instructions in this page to import the XSD into a Hackolade Studio model for the target of your choice.


    In Hackolade Studio, go to Tools > Reverse-Engineer > XSD Schema and select previously generated file.


    As PowerDesigner represents some Foreign Key relationships with the embedding of the child table in the paretn table, if it advised to select the check box "Normalize complex data types in separate entities".  Even if your target model allows complex data types and denormalization, you may want to analyze your access patterns and do the denormalization manually.


    PowerDesigner XSD to Hackolade dialog


    After import, Hackolade Studio displays the resulting ER diagram.


    If the XSD does not contain primary key and foreign key constraints, this reverse-engineering process cannot import them, but it is still possible to use the functionality to Infer PKs & FKs.