Create a mapping between enterprise data models

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.

Time required

To complete this tutorial, you will need approximately 30 minutes.

Prerequisites

In order to complete this tutorial end to end, you should be familiar with the following tasks and concepts:

• Basic data modeling functions.
• Basic database design.
• Basic database functions and SQL statements.

Learning objectives

This tutorial is divided into seven exercises. The exercises show you how to create a mapping model that is ready to deploy to a server.

You will perform 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.
• Save a mapping model.
• Generate an SQL script.

When you are ready, begin Exercise 1: Creating a new data design project.