Supported data types for user tables

Before you map user tables in Unica Campaign, ensure that your tables use only the supported data types for each supported database. Data types that are not listed here are not supported.

Note: A column of datatype DATE, DATETIME, or TIMESTAMP of a table, when mapped in an Unica Campaign flowchart, appears as type TEXT with the format of the DATE, DATETIME, or TIMESTAMP stored in brackets, such as [DELIM_D_M_Y] or [DT_DELIM_D_M_Y]. Although its data type in table mapping in the flowchart shows as TEXT, the application knows the format and handles it accordingly. Do not map columns of these three data types or any of the date- or time-related data types as an Audience ID column to a TEXT audience level. Mapping the date-related column as TEXT audience level is not supported.

Amazon Redshift data types

BIGINT
CHAR
DATE
DECIMAL
DOUBLE PRECISION
INTEGER
REAL
SMALLINT
VARCHAR

Apache Hadoop Hive data types

BIGINT
CHAR
DATE
DECIMAL
DOUBLE
FLOAT
INT
SMALLINT
STRING
TIMESTAMP
TINYINT
VARCHAR

GBQ data types

BOOL
DATE
TIMESTAMP
FLOAT64
INT64
NUMERIC
STRING
INT64
INT
SMALLINT
INTEGER
TINYINT
NUMERIC
DECIMAL

DB2® data types*

bigint
char
date
decimal
double
float
int
numeric
real
smallint
timestamp
varchar

*includes dashDB™ and DB2® BLU.

HP Vertica data types

All basic (standard) data types.

Netezza® data types

bigint
byteint
char(n) [1]
date
float(p)
int
nchar(n) [2]
numeric(p, s)
nvarchar(n) [2]
smallint
timestamp
varchar(n) [1]

[1] Not supported when used in the same table with nchar or nvarchar.

[2] Not supported when used in the same table with char or varchar.

Oracle data types

DATE
FLOAT (p)
NUMBER [ (p , s) ] [1]
TIMESTAMP
VARCHAR2(size BYTE)

[1] Precision is required for NUMBER unless you set the data source property Campaign > partitions > partition[n] > dataSources > [dataSourceName] > UseSQLToRetrieveSchema to TRUE. If you do not specify a precision and you do not set UseSQLToRetrieveSchema to TRUE, Unica Campaign assumes it can store the values in a data type that preserves 15 digits of precision. This can be problematic for fields that hold values whose precision exceeds 15 digits because precision will be lost when the value is brought into Unica Campaign.

SQL Server data types

bigint
bit
char(n) [1]
datetime
decimal
float
int
nchar [2]
numeric
nvarchar(n) [2, 3]
real
smallint
text
tinyint
varchar(n) [1]

[1] Not supported when used in the same table with nchar or nvarchar.

[2] Not supported when used in the same table with char or varchar.

[3] nvarchar(n) is supported but nvarchar(max) is not.

Teradata data types

bigint
byteint
char
date
decimal
float
int
numeric
smallint
timestamp
varchar

MariaDB data types

varchar
tinyint
text
date
smallint
mediumint
int
bigint
float
double
decimal
datetime
timestamp
time
year
char
mediumtext