Supported and Unsupported Mappings from Enterprise Database Server to Kafka table lists if a mapping from a source Enterprise Database Server data type to a target XSD data type is supported, unsupported, or results in an error, warning, or may have warning.
For more information about the data type mapping compatibility, refer to Interpreting Mapping Compatibility between Data Types.
Table 18. Supported and Unsupported Mappings from Enterprise Database Server to Kafka
| Enterprise Database Server Data Types | XSD Data Types | ||||
|---|---|---|---|---|---|
| Supported | Unsupported | Error | Warning | May Have Warning | |
Alpha | Boolean | Duration, NOTATION, Base64Binary, HexBinary | date, datetime, gYearMonth, gMonthDay, time | Integer, NonPositiveInteger, NegativeInteger, NonNegativeInteger, PositiveInteger, Long, Int, Short, Byte, UnsignedLong, UnsignedInt, UnsignedShort, UnsignedByte, Decimal, Float, Double, gYear, gMonth, gDay, string, Qname, normalizedString, Token, ID, IDREF, ENTITY, Name, NMTOKEN, NCName | anyURI, Language |
DBAlpha | Boolean | Duration, NOTATION, Base64Binary, HexBinary | Integer, NonPositiveInteger, NegativeInteger, NonNegativeInteger, PositiveInteger, Long, Int, Short, Byte, UnsignedLong, UnsignedInt, UnsignedShort, UnsignedByte, Decimal, Float, Double, date, datetime, gYearMonth, gMonthDay, time, gYear, gMonth, gDay, anyURI, Language | Nil | string, Qname, normalizedString, Token, ID, IDREF, ENTITY, Name, NMTOKEN, NCName |
Boolean | Integer, Boolean, Long, Int, Short, Byte, UnsignedLong, UnsignedInt, UnsignedShort, UnsignedByte, Decimal, Float, Double, string, anyURI, Qname, normalizedString, Token, Language, ID, IDREF, ENTITY, Name, NMTOKEN, NCName | Duration, NOTATION, Base64Binary, HexBinary | NegativeInteger, date, datetime, gYearMonth, gMonthDay, time | NonPositiveInteger, NonNegativeInteger, PositiveInteger, gYear, gMonth, gDay | Nil |
RecordType | Integer, NonNegativeInteger, PositiveInteger, Boolean, Long, Int, Short, UnsignedLong, UnsignedInt, UnsignedShort, UnsignedByte, Float, Double, gYear | Duration, NOTATION, Base64Binary, HexBinary | NonPositiveInteger, NegativeInteger, date, datetime, gYearMonth, gMonthDay, time, ID, IDREF, ENTITY, Name, NCName | Nil | Byte, Decimal, gMonth, gDay, string, anyURI, Qname, normalizedString, Token, Language, NMTOKEN |
Field | Integer, NonNegativeInteger, Boolean, Long, UnsignedLong, Float, Double | Duration, NOTATION, Base64Binary, HexBinary | NonPositiveInteger, NegativeInteger, date, datetime, gYearMonth, gMonthDay, time, ID, IDREF, ENTITY, Name, NCName | PositiveInteger | Int, Short, UnsignedInt, UnsignedShort, UnsignedByte, Byte, Decimal, gYear, gMonth, gDay, string, anyURI, Qname, normalizedString, Token, Language, NMTOKEN |
Numeric | Boolean, Float, Double | Duration, NOTATION, Base64Binary, HexBinary | date, datetime, gYearMonth, gMonthDay, time, ID, IDREF, ENTITY, Name, NCName | gYear, gMonth, gDay | Integer, NonPositiveInteger, NegativeInteger, NonNegativeInteger, PositiveInteger, Long, Int, Short, UnsignedInt, UnsignedShort, UnsignedByte, Byte, UnsignedLong, Decimal, string, anyURI, Qname, normalizedString, Token, Language, NMTOKEN |
Real | Boolean, Float, Double | Duration, NOTATION, Base64Binary, HexBinary | date, datetime, gYearMonth, gMonthDay, time, ID, IDREF, ENTITY, Name, NCName | Integer, NonPositiveInteger, NegativeInteger, NonNegativeInteger, PositiveInteger, Long, Int, Short, Byte, UnsignedInt, UnsignedShort, UnsignedByte, UnsignedLong, Decimal, gYear, gMonth, gDay | string, anyURI, Qname, normalizedString, Token, Language, NMTOKEN |
Real(p) | Integer, Long, Boolean, Float, Double | Duration, NOTATION, Base64Binary, HexBinary | date, datetime, gYearMonth, gMonthDay, time, ID, IDREF, ENTITY, Name, NCName | NonPositiveInteger, NegativeInteger, PositiveInteger | NonNegativeInteger, Int, Short, Byte, UnsignedInt, UnsignedShort, UnsignedByte, UnsignedLong, Decimal, gYear, gMonth, gDay, string, anyURI, Qname, normalizedString, Token, Language, NMTOKEN |
Real(p,s) | Boolean, Float, Double | Duration, NOTATION, Base64Binary, HexBinary | date, datetime, gYearMonth, gMonthDay, time, ID, IDREF, ENTITY, Name, NCName | NonNegativeInteger, NonPositiveInteger, NegativeInteger, PositiveInteger | Integer, Long, Int, Short, Byte, UnsignedInt, UnsignedShort, UnsignedByte, UnsignedLong, Decimal, gYear, gMonth, gDay, string, anyURI, Qname, normalizedString, Token, Language, NMTOKEN |
Date | date, datetime, gYearMonth, gMonthDay, gYear, gMonth, gDay | Duration, NOTATION, Base64Binary, HexBinary | Integer, NonNegativeInteger, NonPositiveInteger, NegativeInteger, PositiveInteger, Long, Int, Short, Byte, UnsignedInt, UnsignedShort, UnsignedByte, UnsignedLong, Decimal, Boolean, Float, Double, time, ID, IDREF, ENTITY, Name, NCName | Nil | string, anyURI, Qname, normalizedString, Token, Language, NMTOKEN |
Time | datetime, time | Duration, NOTATION, Base64Binary, HexBinary | Integer, NonNegativeInteger, NonPositiveInteger, NegativeInteger, PositiveInteger, Long, Int, Short, Byte, UnsignedInt, UnsignedShort, UnsignedByte, UnsignedLong, Decimal, Boolean, Float, Double, date, gYearMonth, gMonthDay, gYear, gMonth, gDay, ID, IDREF, ENTITY, Name, NCName | Nil | string, anyURI, Qname, normalizedString, Token, Language, NMTOKEN |
TimeStamp | date, datetime, gYearMonth, gMonthDay, time, gYear, gMonth, gDay | Duration, NOTATION, Base64Binary, HexBinary | Integer, NonNegativeInteger, NonPositiveInteger, NegativeInteger, PositiveInteger, Long, Int, Short, Byte, UnsignedInt, UnsignedShort, UnsignedByte, UnsignedLong, Decimal, Boolean, Float, Double, ID, IDREF, ENTITY, Name, NCName | Nil | string, anyURI, Qname, normalizedString, Token, Language, NMTOKEN |
External Large Object | Boolean | Duration, NOTATION, Base64Binary, HexBinary | date, datetime, gYearMonth, gMonthDay, time | Integer, NonNegativeInteger, NonPositiveInteger, NegativeInteger, PositiveInteger, Long, Int, Short, Byte, UnsignedInt, UnsignedShort, UnsignedByte, UnsignedLong, Decimal, Float, Double, gYear, gMonth, gDay | string, anyURI, Qname, normalizedString, Token, Language, ID, IDREF, ENTITY, Name, NMTOKEN, NCName |
Group | Boolean | Duration, NOTATION, Base64Binary, HexBinary | date, datetime, gYearMonth, gMonthDay, time | Integer, NonNegativeInteger, NonPositiveInteger, NegativeInteger, PositiveInteger, Long, Int, Short, Byte, UnsignedInt, UnsignedShort, UnsignedByte, UnsignedLong, Decimal, Float, Double, gYear, gMonth, gDay | string, anyURI, Qname, normalizedString, Token, Language, ID, IDREF, ENTITY, Name, NMTOKEN, NCName |
RSN | Integer, NonNegativeInteger, PositiveInteger, Long, Float, Boolean, Double | Duration, NOTATION, Base64Binary, HexBinary | NonPositiveInteger, NegativeInteger, date, datetime, gYearMonth, gMonthDay, time, ID, IDREF, ENTITY, Name, NCName | Int, Short, Byte, UnsignedInt, UnsignedShort, UnsignedByte, UnsignedLong, Decimal, gYear, gMonth, gDay | string, anyURI, Qname, normalizedString, Token, Language, NMTOKEN |
| Count | Nil | Integer, NonPositiveInteger, NegativeInteger, NonNegativeInteger, PositiveInteger, Long, Int, Short, Byte, UnsignedLong, UnsignedInt, UnsignedShort, UnsignedByte, Decimal, Float, Boolean, Double, date, datetime, Duration, gYearMonth, gMonthDay, time, gYear, gMonth, gDay, string, anyURI, Qname, normalizedString, Token, Language, ID, IDREF, ENTITY, Name, NMTOKEN, NCName, NOTATION, Base64Binary, HexBinary | Nil | Nil | Nil |
| Internal Large Object(LOB) | Nil | Integer, NonPositiveInteger, NegativeInteger, NonNegativeInteger, PositiveInteger, Long, Int, Short, Byte, UnsignedLong, UnsignedInt, UnsignedShort, UnsignedByte, Decimal, Float, Boolean, Double, date, datetime, Duration, gYearMonth, gMonthDay, time, gYear, gMonth, gDay, string, anyURI, Qname, normalizedString, Token, Language, ID, IDREF, ENTITY, Name, NMTOKEN, NCName, NOTATION, Base64Binary, HexBinary | Nil | Nil | Nil |
| Filler | Nil | Integer, NonPositiveInteger, NegativeInteger, NonNegativeInteger, PositiveInteger, Long, Int, Short, Byte, UnsignedLong, UnsignedInt, UnsignedShort, UnsignedByte, Decimal, Float, Boolean, Double, date, datetime, Duration, gYearMonth, gMonthDay, time, gYear, gMonth, gDay, string, anyURI, Qname, normalizedString, Token, Language, ID, IDREF, ENTITY, Name, NMTOKEN, NCName, NOTATION, Base64Binary, HexBinary | Nil | Nil | Nil |
| Link | Nil | Integer, NonPositiveInteger, NegativeInteger, NonNegativeInteger, PositiveInteger, Long, Int, Short, Byte, UnsignedLong, UnsignedInt, UnsignedShort, UnsignedByte, Decimal, Float, Boolean, Double, date, datetime, Duration, gYearMonth, gMonthDay, time, gYear, gMonth, gDay, string, anyURI, Qname, normalizedString, Token, Language, ID, IDREF, ENTITY, Name, NMTOKEN, NCName, NOTATION, Base64Binary, HexBinary | Nil | Nil | Nil |
| Aggregate | Nil | Integer, NonPositiveInteger, NegativeInteger, NonNegativeInteger, PositiveInteger, Long, Int, Short, Byte, UnsignedLong, UnsignedInt, UnsignedShort, UnsignedByte, Decimal, Float, Boolean, Double, date, datetime, Duration, gYearMonth, gMonthDay, time, gYear, gMonth, gDay, string, anyURI, Qname, normalizedString, Token, Language, ID, IDREF, ENTITY, Name, NMTOKEN, NCName, NOTATION, Base64Binary, HexBinary | Nil | Nil | Nil |
| Population | Nil | Integer, NonPositiveInteger, NegativeInteger, NonNegativeInteger, PositiveInteger, Long, Int, Short, Byte, UnsignedLong, UnsignedInt, UnsignedShort, UnsignedByte, Decimal, Float, Boolean, Double, date, datetime, Duration, gYearMonth, gMonthDay, time, gYear, gMonth, gDay, string, anyURI, Qname, normalizedString, Token, Language, ID, IDREF, ENTITY, Name, NMTOKEN, NCName, NOTATION, Base64Binary, HexBinary | Nil | Nil | Nil |
| Transaction Count | Nil | Integer, NonPositiveInteger, NegativeInteger, NonNegativeInteger, PositiveInteger, Long, Int, Short, Byte, UnsignedLong, UnsignedInt, UnsignedShort, UnsignedByte, Decimal, Float, Boolean, Double, date, datetime, Duration, gYearMonth, gMonthDay, time, gYear, gMonth, gDay, string, anyURI, Qname, normalizedString, Token, Language, ID, IDREF, ENTITY, Name, NMTOKEN, NCName, NOTATION, Base64Binary, HexBinary | Nil | Nil | Nil |
| Restart Type | Nil | Integer, NonPositiveInteger, NegativeInteger, NonNegativeInteger, PositiveInteger, Long, Int, Short, Byte, UnsignedLong, UnsignedInt, UnsignedShort, UnsignedByte, Decimal, Float, Boolean, Double, date, datetime, Duration, gYearMonth, gMonthDay, time, gYear, gMonth, gDay, string, anyURI, Qname, normalizedString, Token, Language, ID, IDREF, ENTITY, Name, NMTOKEN, NCName, NOTATION, Base64Binary, HexBinary | Nil | Nil | Nil |