Linking an External Database by Generation

You can use the model generation mechanism to generate tables from your external database to your warehouse PDM and create the required data source and mappings in your warehouse PDM.

1. Create a PDM to model the external database containing the tables to be archived by the lifecycle.
2. Select Tools > Generate Physical Data Model to open the PDM Generation Options dialog.
3. On the General tab, choose whether you will create a new PDM to represent your warehouse database or add the tables to be generated to an existing warehouse PDM.
4. On the Detail tab, ensure that the Generate mappings option is selected.
   These mappings are used in the subsequent generation of the lifecycle to route the data to be archived in the warehouse.
5. On the Selection tab, select the tables that contain the data you want to archive via the lifecycle.
6. Click OK to begin the generation.

   If you are adding the tables to an existing warehouse PDM, the Merge Models dialog will open, allowing you to review the changes that will be made to it before clicking OK to continue with the generation.

   The selected tables are generated to the warehouse PDM, along with a data source object and the appropriate mappings.

   Note: For detailed information about model generation, see Generating Other Models from a Data Model. For information about using the Merge Models dialog, see Chapter 10, Generating Models and Model Objects in the Core Features Guide .