IBM InfoSphere Master Data Management, Version 10.1

Importing a physical data model using the import wizard

Ensure that there is no unnecessary content in the physical data model that you wish to import. If there is, then edit the data model accordingly.
Convert the Database Definition Language (DDL) content into a physical data model:
1. From the main file menu, choose File > New > Other > Data > Data Design Project.
  The New Data Design Project wizard opens.
2. Complete the steps in the wizard.
3. From the main file menu, choose File > New > Other > Data > Physical Data Model. The New Physical Data Model wizard opens.
4. Complete the steps of the wizard, choosing to reverse engineer the model from a database or DDL file.
  Note: For more information, see Creating a physical data model using a wizard in the IBM® Integrated Data Management information center.
Import the physical data model (.dbm file) into a Hub Module model:
1. From the main file menu, select File > Import > InfoSphere Master Data Management Server > Import physical data model. The Import Physical Data Model wizard opens on the Select Source and Destination page.
2. Click Browse to choose a physical data model. A new window opens, enabling to you choose from the physical data model files found in the workspace.
3. Choose the required source physical data model file, then click OK.
4. Choose the required Hub Module model from the drop down list, then click Next. The Classify Database Table page is displayed. New tables in the physical data model are each shown in the Import As New Entities list.
  Existing tables in the Hub Module model are shown in the Update Existing Entities and Code Tables lists. During the import process, the wizard requires that each table to be imported is classified as either an entity or a code table. If a physical data model element has already been imported into the Hub Module, then it has already been classified and is displayed in the Update Existing Entities and Code Tables lists.
5. To change the classification of one or more database tables, select each table and click either Entity or Code Table to move the table into the appropriate list.
6. Select Display import report to automatically view the import report.
7. Click Finish. The import process begins. Progress is displayed in the progress monitor.

Feedback

Last updated: 9 Aug 2012

Topic URL: