Mapping tables between Talend MDM and Talend Data Stewardship
The following introduce the mapping tables between Talend MDM and Talend Data Stewardship.
Upon the deployment of a data model with one or more match rules attached to it, the changes of the MDM data model are propagated to Talend Data Stewardship automatically. Meanwhile, MDM data types are mapped intoTalend Data Stewardship data types, and MDM element constraints (if any) are translated into Talend Data Stewardship attribute constraints.
The table below shows how Talend MDM data types are mapped into
Talend Data Stewardship data
types:
| MDM data type | Talend Data Stewardship data type |
|---|---|
| boolean | boolean |
| date | date |
| time | time |
| dateTime | timestamp |
| int | integer |
| integer | integer |
| short | integer |
| long | integer |
| base64Binary | integer |
| byte | integer |
| negativeInteger | integer |
| nonNegativeInteger | integer |
| positiveInteger | integer |
| nonPositiveInteger | integer |
| unsignedByte | integer |
| unsignedInt | integer |
| unsignedLong | integer |
| unsignedShort | integer |
| decimal | decimal |
| double | decimal |
| float | decimal |
| string | text |
| anyURI | text |
| normalizedtext | text |
| tokentext | text |
| language | text |
| hexBinary | text |
| duration | text |
| AUTO_INCREMENT | text |
| MULTILINGUAL | text |
| PICTURE | text |
| URL | text |
| UUID | text |
In an MDM data model, an entity may have elements with
constraints. Upon deployment of the MDM data model, those constraints will be translated into
the corresponding Talend Data Stewardship
attribute constraints based on their mapped Talend Data Stewardship data types in the data
stewardship data model. However, some MDM element constraints may be ignored because they do
not have the corresponding Talend Data Stewardship attribute constraints.
The table below shows how MDM element constraints are translated into constraints supported by Talend Data Stewardship attributes:
| Talend Data Stewardship data type | MDM element constraint | Talend Data Stewardship attribute constraint |
|---|---|---|
| text | minLength | minLengthText |
| maxLength | maxLengthText | |
| length | minLengthText and maxLengthText | |
| pattern | patternText | |
| enumeration | allowedValues | |
| integer | minInclusive | minInteger |
| maxInclusive | maxInteger | |
| decimal | minInclusive | minDecimal |
| maxInclusive | maxDecimal | |
| fractionDigits | scaleDecimal | |
| date | minInclusive | minDate |
| maxInclusive | maxDate | |
| time | minInclusive | minTime |
| maxInclusive | maxTime | |
| datetime | minInclusive | minDatetime |
| maxInclusive | maxDatetime |