Linking an External Database through the Mapping Editor

You can use the Mapping Editor to manually create (or modify) mappings between the external database and warehouse tables that will be used to archive the data governed by the lifecycle. This method can be useful when you have PDMs to represent your external and warehouse databases and will be using non-standard mappings to load your data.

To open the Mapping Editor from your warehouse PDM, select Tools > Mapping Editor. If you have no data sources defined in the model, the Data Source Wizard will open, and you should use it to define a data source pointing to the external database PDM, which will then be opened in the Mapping Editor.

Note: For detailed information about using the Mapping Editor (and the Data Source Wizard) see Core Features Guide > Linking and Synchronizing Models > Object Mappings.