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
Open your workspace.
Click the Data tab.
The LDM Modeler opens in view mode.
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.If you do not have any data source, you cannot generate the PDM. Create a data source first.
Under Data Sources select your data source.
Click Scan now.
The scan dialog opens. By default, only tables are selected for scanning.
If you want to also scan the views, select the Scan views check box.
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 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.If the Replace mode seems too destructive, you can update the declarative definition of the PDM and store it under the corresponding data source using the API.
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.
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.