Replicate data types

Qlik Replicate converts source data to its own data type. For data that Replicate cannot convert, it returns an error.

To see how a data type is mapped from source to target:

See the chapter for the source endpoint you are using. In the section on data types, see the mapping table to see the Qlik Replicate data type.
See the chapter for the target endpoint you are using. In the section on data types, see the mapping table to see how the Replicate data type maps to the target.

For example, when replicating data from an Oracle source endpoint to a Microsoft SQL Server target endpoint, Replicate first converts the Oracle data type BINARY to the Replicate data type BYTES. BYTES maps to the Microsoft SQL Server data type VARBINARY (Length).

The following table describes the Qlik Replicate data types. Some data types have precision and scale information that applies to them.

Qlik Replicate data type descriptions
ReplicateData Types	Description
STRING	A character string
WSTRING	A double-byte character string
BOOLEAN	A Boolean value
BYTES	A binary data value
DATE	A date value: Year, Month, Day
TIME	A time value: Hour, Minutes, Seconds Only the following format is supported: `HH:MM:SS`
DATETIME	A timestamp value: Year, Month, Day, Hour, Minute, Second, Fractional Seconds The fractional seconds have a maximum scale of 9 digits. Year can have a maximum value of 32767. Only the following format is supported: `YYYY:MM:DD HH:MM:SS.F(9)`
INT1	A one-byte, signed integer
INT2	A two-byte, signed integer
INT4	A four-byte, signed integer
INT8	An eight-byte, signed integer
NUMERIC	An exact numeric value with a fixed precision and scale
REAL4	A single-precision floating-point value
REAL8	A double-precision floating-point value
UINT1	A one-byte, unsigned integer
UINT2	A two-byte, unsigned integer
UINT4	A four-byte, unsigned integer
UINT8	An eight-byte, unsigned integer
BLOB	Binary Large Object
CLOB	Character Large Object
NCLOB	Native Character Large Object

For more information, see LOB support in Task Settings/Metadata.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here