Skip to main content

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.

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.