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.
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 |
|
|