Creating a Data Connection with the Database Connection Wizard

The Database Connection Wizard can be launched from the Mapping Editor to connect a source or remote database to your replication process. The wizard will create a data connection and a database associated with a PDM to specify its schema. You must have at least one source database and one remote database connected to your replication process to create replications.

1. Click the Create Data Connection tool in the Source or Target pane to launch the Database Connection Wizard.
2. On the Databases page, you can:

   • Create a database by entering a new name for the database in the Database field.

   • Select an existing database from the list of available databases by clicking the Select a Database tool.

   Make your selection, and then click Next.

3. [new database] The Physical Data Models page lets you associate a PDM with your database to specify its schema. Select one or more PDMs among the list of models open in your workspace, and click Finish to close the wizard.

   The database is now connected to your replication process, and displayed in the appropriate pane in the Mapping Editor.

   In the following example, the Source_PDM Project Management PDM is selected as the source database for the replication process and the Target_PDM Project Implementation PDM is selected as the remote database for the replication process: