ARC source data type mapping
The table below shows the ARC source data types that are supported when using Qlik Replicate and the default mapping to Qlik Replicate data types.
For an explanation of the supported data types for the ARC CDC Solution you are using, see the CDC Solution reference in the Attunity Replicate Connect User Guide and Reference.
For information on how to view the data type that is mapped in the target, see the section for the target database you are using.
For additional information about Qlik Replicate data types, see Replicate data types.
ARCData Types | Qlik ReplicateData Types |
---|---|
INT |
REAL4 |
REAL |
REAL4 |
FLOAT |
REAL8 |
BIT |
INT1 |
TINYINT |
INT1 |
SMALLINT |
INT2 |
BIGINT |
NUMERIC |
DECIMAL |
NUMERIC |
NUMERIC |
NUMERIC |
MONEY |
NUMERIC |
SMALLMONEY |
NUMERIC |
DATETIME |
DATETIME |
SMALLDATETIME |
DATETIME |
CHAR |
STRING |
VARCHAR |
STRING |
NCHAR |
STRING |
NVARCHAR |
STRING |
BINARY |
BYTES |
VARBINARY |
BYTES |
TIMESTAMP |
BYTES |
UNIQUEIDENTIFER |
STRING |