Generate a Logical Data Model Automatically in the LDM Modeler

Once you have generated the physical data model (PDM) either using the API or in the LDM Modeler, generate the logical data model (LDM) based on the PDM automatically in the LDM Modeler.

To generate the LDM automatically in the LDM Modeler, do the following:

  1. Learn how the PDM is transformed to the LDM and adjust your database as needed to make the process of generating the LDM smoother and more accurate.
  2. Generate the LDM.

Generate the LDM

Steps:

  1. Open your workspace.

  2. Click the Data tab.

    The LDM Modeler opens in view mode.

  3. Click Edit.

    The LDM Modeler is switched to edit mode. You can see your PDM in the left panel.

    Empty model

  4. Click on the wand icon next to your data source.

    Click wand

    The Generate LDM dialog opens.

    Generate LDM dialog

  5. Specify parameters as needed.

  6. Choose the scan mode.

    • Append to the existing model appends new objects and does not touch the existing objects.

      Use this option if you want to add new objects to the existing PDM (and eventually LDM) or if you want to scan for newly created tables and views in your database without affecting the existing PDM and LDM.

    • Update the existing model appends new objects and replaces the existing ones. If the current PDM contains tables/views that are no longer in the database, these tables/views remain untouched.

    • Replace the existing model replaces the current PDM with the newly scanned PDM and regenerates the LDM. If the current PDM contains tables/views that are no longer in the database, these tables/views are deleted, and the datasets mapped to these tables/views are deleted as well.

  7. Click Generate.

    The scanning process starts. When the scanning completes, the LDM is created.

    LDM after scan

  8. Publish the LDM.

Once you have the LDM published, you can start building insights and dashboards.