Table of Contents

Search

  1. Preface
  2. Introduction
  3. Working with Enterprise Data Manager
  4. Enterprise Data Manager
  5. ILM Repository Constraints
  6. Partition Exchange Purging
  7. APIs
  8. Smart Partitioning
  9. Salesforce Accelerator
  10. SAP Application Retirement Entities
  11. Import Formats for Constraints
  12. Glossary

Enterprise Data Manager Guide

Enterprise Data Manager Guide

Discovery from ERwin Data Models

Discovery from ERwin Data Models

You can use ERwin logical data models to discover relationships between tables in source applications. Export the data model to discover unique, primary, and foreign key constraints. Then, use the suggested relationships to create unique and referential constraint types for the related source metadata in the ILM repository.
You export the logical data model to an XML file and then run the discovery on the exported file. When you export the data model, you export the file in PowerCenter format. The ILM engine uses a PowerCenter DTD file to import the metadata from the XML file into the ILM repository. The PowerCenter DTD file is included as part of the Data Archive installation.
The ILM engine uses the imported source metadata in the ILM repository to drive the import of the metadata from the data model. You initiate the discovery from the application version or from the application module levels of the source metadata. You specify the tables that you want to import metadata for. When you discover relationships at the application version level, the discovery occurs across all schemas in the application version. When you discover from the application module level, then the discovery occurs for that schema only.
All of the information for the table discovery is contained in the exported XML file. You do not need to connect to the ERwin data model or to the source database. You can export data models from any ERwin version that PowerCenter supports.

0 COMMENTS

We’d like to hear from you!