Mapping Models - Introduction

The logical models can be mapped to the tables and columns of:

• One or more physical data models.
• Any of the configured and discovered connections.

You have these two options to map your models:

• Mapping through the Entity Transformation wizard
• Mapping by drag and drop on the canvas: Drag a table from the physical model to the canvas and establish a link between the columns of the physical and logical tables.

The table below gives a matrix of the compatible data types for mapping of logical models with physical models or connections. For every incompatible mapping the system prompts a warning message saying the data types are incompatible and mapping these might throw errors at run time.

Table 1. Compatible data types in mapping

Logical Model
Physical Model		String	Big decimal	Integer	Long	Float	Double	Boolean	Date	Time	Date time
	String
	Big decimal
	Integer
	Long
	Float
	Double
	Boolean
	Date
	Time
	Date time