Datatype Mapping Changes

Changes to datatype mappings from Oracle, Microsoft SQL Server, and DB2 UDB to SAP HANA database in Replication Server 15.7.1 SP200.

The datatype mappings that remain unchanged are not listed here. For the complete list of datatype mappings, see Datatype Translation and Mapping in the Heterogeneous Replication Guide.

Table 1: Oracle-to-SAP HANA Database Datatype Mappings
Oracle Datatype	Replication Definition Datatype	SAP HANA Database Datatype
`CHAR`	`char`	`varchar`
`NCHAR`	`unichar`	`nvarchar`
`RAW`	`rs_oracle_binary`	`varbinary`

Table 2: Microsoft SQL Server-to-SAP HANA Database Datatype Mappings
Microsoft SQL Server Datatype	Replication Definition Datatype	SAP HANA Database Datatype
`bigint`	`rs_msss_bigint`	`bigint`
`char`	`char`	`varchar`
`datetime`	`rs_msss_datetime`	`timestamp`
`datetime2`	`rs_msss_datetime2`	`timestamp`
`nchar`	`unichar`	`nvarchar`
`nvarchar(max)`	`rs_msss_nvarchar_max`	`nclob`
`smalldatetime`	`rs_msss_datetime`	`seconddate`
`timestamp`	`timestamp`	`varbinary(8)`
`time`	`rs_msss_time`	`timestamp`
`uniqueidentifier`	`char(36)`	`varchar(36)`
`varbinary(max)`	`rs_msss_varbinary_max`	`blob`
`varchar(max)`	`rs_msss_varchar_max`	`clob`

Table 3: DB2 UDB-to-SAP HANA Database Datatype Mappings
DB2 UDB Datatype	Replication Definition Datatype	SAP HANA Database Datatype
`BLOB`	`rs_udb_varchar_for_bit`	`blob`
`CHAR`	`char`	`varchar`
`CHAR FOR BIT DATA`	`rs_udb_char_for_bit` (recommended) `binary`	`varbinary`
`DECFLOAT(16)`	`rs_udb_decfloat`	`double`
`GRAPHIC`	`unichar`	`nvarchar`
`INTEGER`	`rs_udb_bigint`	`integer`