To integrate a new data source with existing enterprise
data, you need to understand how the data in the new source is related to
data in the existing environment. You can build a process that copies data
from the new source into the existing source. By defining mappings and relationships,
you can manipulate a large set of disparate metadata.
This tutorial shows you how to create a mapping between physical
data models. The file that is created in this tutorial is an MSL file.
Learning objectives
When
you complete the exercises, you will know how to do the following tasks:
- Create a new data design project
- Access data models
- Create a new mapping model
- Find relationships between source and target elements
- Transform a source element to match a target element
- Generate an SQL script
This tutorial should take approximately 30 minutes to finish.
If you explore other concepts related to this tutorial, it could take longer
to complete.
Skill level
Advanced
Audience
Integration architects
System requirements
This tutorial can
be completed in the workbench environment and does not require any additional
system requirements.
Prerequisites
In order to complete this tutorial,
you should be familiar with the following concepts:
- Data modeling
- Database design
- Basic database functions and SQL statements