Importing a Schema Objects

You can import the schema objects from the database connection you have in Data Source explorer.

Procedure

  1. In the Project Explorer, Right click on the Repository Models folder to which you want to import and select Import.
  2. The Import Wizard is displayed.
  3. Expand MDM Repository Designer folder, select Import Model From Database and click Next.
  4. The New Database Repository Model page is displayed.
  5. By default, the model name is displayed as RepositoryModel.rep in File name field. You can specify a different model name (*.rep) or choose the default name and click Next.
  6. The Database Table Selection page is displayed. Select the profile name from the Profile drop-down list from which you want to select the schema.
  7. Select the schema or catalog from the Schema/Catalog drop-down. For the selected schema, all the Tables and Views are populated on the left hand side of the table. There are checkboxes corresponding to the table or view.
  8. Select the checkboxes corresponding to the table or view which you want to include in the repository model and then, right hand side of the table displays the selected table or view. You can use the type filter text to search for the Table/View. If you want to import Foreign key constraints as relationship for a particular table or view then expand the table or view and select the checkbox corresponding to that constraint.
  9. If you have selected a foreign key of a table and the target table (which is mandatory to make a relationship) is not selected then an error is thrown prompting to select the target Table.
  10. Select the target table or view.
  11. Click Next. The Attribute Selection Page is displayed.
  12. The repository attribute list with the default Name, Type, and Length values is displayed. You can update values from all available columns for an attribute and you can also use Association map to choose any attribute as ID (Record Id), IDEXT (Record ID Extension), or EFFECTIVEDATE.
  13. To delete any attribute, select the attribute and click . To delete more than one attribute, hold the CTRL button select the attributes and click .
  14. Similarly you can modify the relationship properties by selecting foreign key node.
  15. Click Finish. The Repository Model is created and displayed in the canvas.