View Source

This section covers data type conversions between the and SQL Server databases.

NOTE: The listed in this page reflect the raw data type of the converted column. Depending on the contents of the column, the Transformer Page may re-infer a different data type, when a dataset using this type of source is loaded.

Access/Read

Source Data Type	Supported?
Bigint	Y	Integer
BIGINT IDENTITY	Y	Integer
Binary	Y	String (Base64)
Bit	Y	Bool
Char	Y	String
Cursor	N
Date	Y	Date
Datetime	Y	Date
Datetime2	Y	Date
Datetimeoffset	Y	String
Decimal	Y	Integer/Decimal
DECIMAL IDENTITY	Y	Integer
Float	Y	Decimal
GEOGRAPHY	Y	String
GEOMETRY	Y	String
HIERARCHYID	Y	String
Image	Y	String
Int	Y	Integer
INT IDENTITY	Y	Integer
Money	Y	Decimal
Nchar	Y	String
Ntext	Y	String
Numeric	Y	Integer/Decimal
NUMERIC IDENTITY	Y	Integer
Nvarchar	Y	String
Nvarchar(max)	Y	String
Real	Y	Decimal
Smalldatetime	Y	Date
Smallint	Y	Integer
SMALLINT IDENTITY	Y	Integer
Smallmoney	Y	Decimal
Sql_variant	N
Table	N
Text	Y	String
Time	Y	String
Timestamp	Y	String
Tinyint	Y	Integer
TINYINT IDENTITY	Y	Integer
Uniqueidentifier	Y	String
Varbinary	Y	String (Base64)
Varbinary(max)	Y	String (Base64)
Varchar	Y	String
Varchar(max)	Y	String
Xml	Y	String

Write/Publish

	SQL Server Column Type	Notes
Bool	BIT
	VARCHAR(256)
Integer	BIGINT
	INT
	SMALLINT
	DECIMAL
	VARCHAR(256)
String	NVARCHAR
	VARCHAR(256)
Datetime	DATETIME
	DATETIME2
	TIMESTAMP
	VARCHAR(256)
Timestamp	TIME
	VARCHAR(256)
Float	FLOAT
	DECIMAL
	NUMERIC
	VARCHAR(256)
Map	VARCHAR(256)
Array	VARCHAR(256)

NOTE: If you are appending to an existing table where a column's is not mapped to the column data type in the target table, a validation error is thrown, as the platform writes unmapped types as String data type.