Unsupported Data Types in a Replication Flow

Replication flows support all data types in SAP Datasphere (see, Column Data Types), except for the following sources and target connections.

Unsupported Sources Data Types

The following source data types are not supported in a replication flow:

Sources

Unsupported Data Types

Microsoft SQL Server (MSSQL) / Microsoft Azure SQL Database

  • binary(n)(5000 < n <= 8000)

  • varbinary(n)(5000 < n <= 8000)

  • varbinary(max)

  • ntext

  • image

  • cursor

  • nvarchar(max)

  • geography

  • geometry

  • table

  • json

  • hierarchyid

  • sql_variant

  • char(n)(5000 < n <= 8000)

  • varchar(n)(5000 < n <= 8000)

  • xml

SAP HANA

  • BLOB

  • CLOB

  • NCLOB

  • TEXT

  • ARRAY

  • ST_GEOMETRY

  • ST_POINT

  • REAL_VECTOR

Snowflake

  • VARIANT, OBJECT, ARRAY, GEOMETRY, GEOGRAPHY, VECTOR.

  • VARCHAR[n], BINARY[n] with n > 5000 characters/bytes.

  • Snowflake also does not support LOB types (BLOB, CLOB), ENUMs, and custom user types.

ABAP

  • D16R – Floating point saved as binary data

  • D34R – Floating point saved as binary data

  • LRAW – Long byte string

  • RAW – Byte sequence

  • LCHR (if length > 5000) – Long character string

  • STRG – String

  • RSTR – Byte string

  • STRING (if length > 5000) - String

REST API

  • time

  • hana.ST_POINT

  • hana.ST_GEOMETRY

All supported sources

  • Binary (length 0, and higher than 5000)

  • String (length 0, and higher than 5000)

Unsupported Targets Data Types

The following target data types are not supported in replication flow, but will be converted to supported data types:

Target

Unsupported Data Types

Google BigQuery

We will convert the following data types during import:

  • decfloat16 will be converted to decimal (38,6)

  • decfloat34 will be converted to decimal (38,6)

  • uint64 will be converted to decimal(20,0)

Local Table (File)

We will convert the following data types during import:

  • decfloat16 will be converted to decimal (38,6)

  • decfloat34 will be converted to decimal (38,6)

  • uint64 will be converted to decimal(20,0)

Data columns with the following data types will not be replicated:

  • time

  • hana.ST_POINT

  • hana.ST_GEOMETRY

  • uint8

  • tiny int

  • datatime

All supported targets

  • Binary (length 0, and higher than 5000)

  • String (length 0, and higher than 5000)