Generate a Physical Data Model In the LDM Modeler

This article describes how to generate the PDM in the LDM Modeler. If you cannot or do not want to use the LDM Modeler, you can use the API. The API will scan your database and save the generated PDM under the corresponding data source. In the LDM Modeler, the scanning and storing operations are executed from a single UI dialog.

Generate the PDM


  1. Open your workspace.

  2. Click the Data tab.

    The LDM Modeler opens in view mode.

  3. Click Edit (or Create model, if it’s your first time setting up a PDM in this workspace).

    The LDM Modeler is switched to edit mode. You can see the registered data sources on the left panel.

  4. Under Data Sources select your data source.

    Select data source

  5. Click Scan now.

    Select scan now

    The scan dialog opens. By default, only tables are selected for scanning.

    Scan Dialog

  6. If you want to also scan the views, select the Scan views check box.

  7. Choose the Scan mode.

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

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

    • Update 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 replaces the current PDM with the newly scanned PDM. If the current PDM contains tables/views that are no longer in the database, these tables/views are deleted.

  8. Click Scan.

    The scanning process starts. It scans the physical tables/views in your database so that you can then map the LDM components to the tables and columns in your database through the PDM.

    When the scanning completes, you can see the tables created from your database.

    Scan complete

Once you have the PDM generated, you can proceed to generate the LDM.

Refresh the PDM

If your database schema changes, you may refresh your schema by opening the data source menu and selecting:

  • Refresh to reload PDM from your data source, in case it was changed via API. This does not change the PDM in data source.
  • Scan Data Source to Open the Scan Data Source dialog to scan PDM from database. This does changes PDM in the data source.
  • Generate logical data model to open the Generate logical data model wizard.

refresh the tables