Data Type correspondence

The types for the columns in the staging table are based on the DbType of the .Net library System.Data (https://learn.microsoft.com/fr-fr/dotnet/api/system.data.dbtype?view=net-8.0 ). They are translated into database type depending on the target database type that you have.

Here is the matching table for each type. Note that the types marked as cross mark cannot be used in a staging table for the target database and will result in an error during the creation of the staging table.

beVault	PostgreSQL	SQL Server	Snowflake	IBM db2
AnsiString	varchar	varchar	VARCHAR	VARCHAR
Binary	bytea	varbinary	BINARY	VARBINARY
Byte		binary	BINARY	BINARY
Boolean	bool	bit	BOOLEAN	BOOLEAN
Currency	numeric	decimal	NUMBER	DECIMAL
Date	date	date	DATE	DATE
DateTime	timestamp	datetime2	TIMESTAMP_NTZ	TIMESTAMP
Decimal	numeric	decimal	NUMBER	DECIMAL
Double	float8	float(8)	FLOAT	DOUBLE
Guid	uuid	uniqueidentifier	BINARY	BINARY
Int16	int2	smallint	NUMBER	SMALLINT
Int32	int4	int	NUMBER	INTEGER
Int64	int8	bigint	NUMBER	BIGINT
Object			OBJECT
SByte			BINARY	VARBINARY
Single	float4	float(8)	FLOAT	REAL
String	varchar	varchar	VARCHAR	VARCHAR
Time	time	time	TIME	TIME
UInt16	int2	smallint	NUMBER	SMALLINT
UInt32	int4	int	NUMBER	INTEGER
UInt64	int8	bigint	NUMBER	BIGINT
VarNumeric	numeric	decimal	NUMBER	DECIMAL
AnsiStringFixedLength	bpchar	char	VARCHAR	CHARACTER
StringFixedLength	bpchar	char	VARCHAR	CHARACTER
Xml	xml	xml	VARCHAR	XML
DateTime2	timestamp	datetime2	TIMESTAMP_NTZ	TIMESTAMP
DateTimeOffset			TIMESTAMP_TZ	TIMESTAMP