In Data modeling studio, several metadata tables exist, which are used:

• On deploy.
• On deploy or export.
• In data modeling.

Metadata tables used on deploy

For Data modeling studio, several metadata tables exist in D365 FO that are used when you deploy a data model. Whether these tables are used is defined by the deployed data model.

These metadata tables are used on deploy:

• Labels (CDPLabel): This table contains the labels from D365 FO. On deploy, the CDPLabelSTAGING table is created in the target database. So, in the target database, the UI labels are shown instead of the technical names.
• Enumerations (CDPEnumerations): This table contains the enum value names from D365 FO. On deploy, the CDPEnumerationsSTAGING table is created in the target database. So, in the target database, the enum value names are shown instead of the enum value numbers.
• Data dictionary (CDPDictionary): This table contains all D365 FO tables. On deploy, the CDPEnumerationsSTAGING table is created in the target database.

Metadata table used on deploy and export

For Data modeling studio, the Entity export status (CDPEntityExportStatus) table exists in D365 FO that is used when you deploy a data model or export data. Whether this table is used is defined by the Entity export status parameter.

If in the Data modeling studio parameters, the Entity export status field is set to 'Yes', on:

• Deploy, the CDPEntityExportStatusSTAGING table is created in the target database. It is also filled with the data that exists in the CDPEntityExportStatus table in D365 FO.
• Data export, for each table for which data is exported, the export status and related dates are set in the CDPEntityExportStatus table in D365 FO and the CDPEntityExportStatusSTAGING table in the target database.

Metadata tables used in data modeling

In Data modeling studio, several metadata tables exist in D365 FO, which are used in data modeling:

• Tables (CDPExcludedTables) and (CDPDataModelTableList): The CDPExcludedTables table lists all tables that are used in data sets. these tables are excluded from selection on data set creation. The CDPDataModelTableList table lists all non-staging D365 FO tables. These tables together define the tables that you can enter or select on data set creation.
• Forms (CDPFormsNameTable): This table is used to define what is shown in the lookup of the Form labels filed on the Design data set page. The table contains all form names and captions of non-CDP tables in D365 FO.
• Master data tables relations (CDPMasterDataProfilesRelationTable): This table is used to define the Available fields for the selected entity on the Master data profile design page. For these entities, data is stored in the CDPMasterDataProfilesRelationTable table:
  • Customer: Information of the CustTable table and of the tables that are linked to the CustTable form.
  • Vendor: Information of the VendTable table and of the tables that are linked to the VendTable form.
  • Product: Information of the EcoResProductDetailsExtended table and InventTable table and of the tables that are linked to the main forms for these tables.
  • Employee: Information of the HcmWorker table and of the tables that are linked to the HcmWorker form.

Update metadata

For the Data modeling studio metadata tables, the data is collected in D365 FO and stored in these tables in D365 FO.
On deploy or export, for some of these metadata tables, the data is taken from these metadata tables in D365 FO. For other metadata tables, the data is used in data modeling.

It is important to keep the data in the metadata tables up-to-date. To update the metadata in the metadata tables in D365 FO, on the Data modeling studio parameters page, on the Metadata synchronization tab, click Update metadata.

Note: Make sure to update the metadata tables after each change or creation of a data model.