Teradata source data types

The following table shows the Teradata source data types that are supported when using Qlik Replicate and the default mapping to the Qlik Replicate data types.

For additional information about Qlik Replicate data types, see Replicate data types.

Teradata and Qlik Replicate data types
Teradata Data Types	Qlik Replicate Data Types
BLOB	BLOB
BYTE	BYTES
BYTEINT	INT1
BIGINT	INT8
DATE	DATE
DECIMAL	REAL8
DOUBLE PRECISION	REAL8
FLOAT	REAL8
INTEGER	INT4
INTERVAL DAY	STRING (Support a maximum of 9,999 days)
INTERVAL DAY TO HOUR	STRING
INTERVAL DAY TO MINUTE	STRING
INTERVAL DAY TO SECOND	STRING
INTERVAL HOUR	STRING
INTERVAL HOUR TO MINUTE	STRING
INTERVAL HOUR TO SECOND	STRING
INTERVAL MINUTE	STRING
INTERVAL MINUTE TO SECOND	STRING
INTERVAL SECOND	STRING (Supports up to six fractional seconds)
CHAR	STRING
CLOB	CLOB
GRAPHIC	STRING
INTERVAL MONTH	STRING
INTERVAL YEAR	STRING
INTERVAL YEAR TO MONTH	STRING
REAL	REAL8
SMALLINT	INT2
TIME	TIME
TIMESTAMP	DATETIME
TIMESTAMP WITH TIME ZONE	DATETIME
TIME WITH TIME ZONE	TIME
VARBYTE	BYTES
VARCHAR	STRING (10)
VARGRAPHIC	STRING (10)
NUMERIC	If scale is => 0 and <=37, then: NUMERIC (p,s) If scale is => 38, then: VARCHAR (45)
CHAR VARYING	STRING
LONG VARCHAR	STRING

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