The Data Source Wizard guides you through creating an external database data source in your model, and to attach it and the tables to be managed to the first phase of your lifecycle
- Create an age-based lifecycle policy (see Creating a Lifecycle), add a first phase to it, and open the property sheet for this phase.
- Set the retention period for the phase and set the Location property to External database.
- Click the Create tool to the right of the data source field to open the Data Source Creation Wizard.
- On the first page, select the PDM that represents your external database and then click Next.
- On the second page, select the tables that you want to associate with the lifecycle.
- Click Finish to associate the selected tables with the lifecycle.
The wizard creates a data source in the warehouse PDM and associates it with the first phase of the lifecycle. The selected tables are generated to the warehouse PDM if they were not already present, and appropriate mappings are created between the tables in the external database and those in the warehouse PDM.