Reloading the schema metadata

When a database schema is updated, the schema must be reloaded for the data module to remain synchronized with the database.

To create a data module that is based on a data server source, the database schema metadata must be loaded and saved to the content store. This task is performed by administrators in the administration component after the data server connection is created. For more information, see Loading metadata.

For existing data modules, the modeler can reload the schema metadata after the schema is updated. This step might be needed when you encounter validation errors in the data module.

Before you begin

To access the Reload metadata action in a data module, you need the following permissions:
  • Data server - Write permission
  • Administration capability - Traverse permission
  • Data Source Connections capability (child of the Administration capability) - Access permission

Procedure

  1. Open the data module that is based on a relational data server.
  2. Click the Source view icon Source view icon to open the Sources panel.
  3. From the schema context menu, click Reload metadata.

    If this action is not available for a data server schema, ensure that you have the required permissions for the data server and the Administration and Data Source Connections capabilities, as documented earlier in this topic.

Results

The tables and columns are reloaded based on the latest state of the data server. If the source contains renamed items, or items were removed from the source, validation error icons Validation error icon appear next to the affected columns in the Data module panel.

What to do next

To compare the data in the schema and the data module, in the Sources panel toolbar, click the Source tree settings icon, and select the Show unused items check box. The tables and columns that are not in the data module are highlighted in the Sources panel. You can proceed to update the columns in the data module.