Update Data Models Feature

The Update Data Models transformation feature enables data models in documents to be updated to reflect changes in underlying databases. You must select which data models are to be updated and supply new data models to replace the original. There are two ways in which you can update data models.

The first option, match the full data model, is restrictive and requires that the replacement data model contain all or more tables than the original data model. This is a complete data model match.

The second option, match only the query request, is more flexible. The replacement data model is only required to satisfy the queries that are associated with the original data model. For this, the replacement data model must only contain the tables and columns referenced in the query request line, query filters and sort columns. If the original data model is a master data model, the replacement must satisfy the request line, filters and sort columns of all the queries associated with the master data model. This is a less stringent requirement than matching the full data model.

This process is described in these topics: