Create a Physical Data Model

Once you have created data sources for your database, generate a physical data model (PDM).

The PDM describes the tables of your database and represents how the actual data is organized and stored in the database. The logical data model (LDM) is then mapped to the PDM and ultimately determines your analytical options when you build insights and dashboards.

To generate a PDM, follow these steps:

  1. Check the data types in your database

  2. Generate a PDM in the LDM modeler or using the API

Check the Data Types In Your Database

Make sure that the columns that you want to include in the PDM have the supported data types assigned. The data types are validated using the JDBC data types. To find out how the JDBC data types are mapped to the data types in your database, see the documentation for your database.

The following JDBC data types are supported:

  • BIGINT
  • BIT
  • BOOLEAN
  • CHAR
  • CLOB
  • DATE
  • DECIMAL
  • DOUBLE
  • FLOAT
  • INTEGER
  • LONGNVARCHAR
  • LONGVARCHAR
  • NCHAR
  • NCLOB
  • NUMERIC
  • NVARCHAR
  • REAL
  • ROWID
  • SMALLINT
  • SQLXML
  • STRING
  • TIMESTAMP_WITH_TIMEZONE
  • TIMESTAMP
  • TINYINT
  • VARCHAR

Columns with an unsupported data type (for example, when the UUID database data type is mapped to the OTHER JDBC data type) are skipped and not included in the PDM. You will get the following warning during the generation of the PDM:

Column <column_name>
Data type <data_type> of column is not supported
Generate a Physical Data Model In the LDM Modeler