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.

If you cannot or do not want to use the LDM Modeler, you can use the API.

Generating the LDM automatically is suitable for quick onboarding and exploring the content of your database or if your database is prepared for building analytics and does not contain the complex analytical scenarios. If this is not the case, create the LDM manually 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

    If you do not have a PDM, you cannot generate the LDM. Generate a Physical Data Model first.

  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.

    Choose the mode carefully. If you have made breaking changes in your database (for example, dropped a table mapped to the existing LDM), the related metrics or insights will stop working. If an insight cannot be displayed, a generic error message is displayed. A user-friendly error message is available via the browser’s developer console. If a mapped table or column does not exist, an error message contains information sufficient for troubleshooting.

    • 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.

Generate a Logical Data Model Automatically Using the API
Create a Logical Data Model Manually