Supported data types

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

For information on the target data types, see the section for the target endpoint you are using. For additional information about Qlik Replicate data types, see Replicate data types.

Data types
Salesforce Data Types	Qlik Replicate Data Types
string	WSTRING
boolean	BOOLEAN
int	INT4
double	REAL8
date	DATE Information note The DATE will be represented in UTC format on the target.
time	TIME Information note The TIME will be represented in UTC format on the target.
datetime	DATETIME Information note The DATETIME will be represented in UTC format on the target.
ID	WSTRING
reference	WSTRING
currency	REAL8
textarea	If length is <= 1000 WSTRING If length is > 1000 CLOB
percent	REAL8
phone	WSTRING
url	WSTRING
email	WSTRING
combobox	WSTRING
picklist	WSTRING
multipicklist	WSTRING

Unsupported data types

The following data types are not supported:

AnyType
Base64

Compound columns (e.g. Address) will not be replicated in their original form. Only their underlying columns (such as country, city, etc.) will be replicated (as separate columns).

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