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 CSV Files

Discovery from CSV Files

You can maintain data models of source databases in CSV files. Use the relationships defined in the CSV file to discover 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.
The CSV file must be in a predefined format. The format is based on the table that stores the suggested table relationships.
When you import the relationships defined in the CSV file, the Enterprise Data Manager uses the values in the file for the tables in the application version or the application module that you specify. The Enterprise Data Manager imports the suggested foreign and primary key relationships to a profiling suggestion table in the ILM repository. The Enterprise Data Manager does not create the constraints. You must review the suggestions and then choose which suggestions you want to create constraints from. No jobs are involved in this process.

0 COMMENTS

We’d like to hear from you!