SQL Server Data Types Supported in OneData

webMethods, OneData, and Terracotta 10.2 | Managing Master Data with webMethods OneData | Implementing webMethods OneData | Managing an Object Structure | SQL Server Data Types Supported in OneData

When you create a column in OneData the data type of the column created in SQL Server is as follows:

In OneData, if the data type is...	The data type in SQL Server is...
Numeric	NUMERIC
Varchar	NVARCHAR (Supports Unicode) / VARCHAR
Character	NCHAR (Supports Unicode) / CHAR
File Type	NVARCHAR / VARCHAR
Date	DATE
TimeStamp	DATETIME
Boolean	BIT
Percentage	NUMERIC
DataBase Sequence	NUMERIC IDENTITY
Optional Database Sequence	NUMERIC
Contiguous Sequence	NUMERIC

You can import a table created in an external system into OneData using the import features update schema, add from remote table, and synchronize structure. OneData supports the following data types in SQL Server:

If SQL Server data type is...	OneData identifies the Data Type as...
bigint	Numeric
decimal	Numeric
float	Numeric
int	Numeric
numeric	Numeric
tinyint	Numeric
real	Numeric
smallint	Numeric
char	Char
nchar	Char
uniqueidentifier	Char
varchar	Varchar
nvarchar	Varchar
date	Date
datetime	Date
datetime2	Timestamp
smalldatetime	Timestamp
time	Timestamp
varbinary	File type
bit	Boolean