|
<< Click to Display Table of Contents >> Data Type Support |
Overview
When setting Replication or Virtualization through the Wizard (that is, when using the default components and Classes for Replication or Virtualization provided by Bizagi), Bizagi will support the mapping of attributes to a comprehensive set of supported data types.
The following information lists the supported data types when using Bizagi's native integration to external SQL Server.
The tables below shows the column mappings from the data source to Bizagi when using Replication or Virtualization. The first column displays the source data types, and the second column presents the equivalent data type in Bizagi, if supported.
SQL Server data types |
|
|---|---|
Character Strings |
|
CHAR |
String |
VARCHAR |
String |
TEXT / VARCHAR(MAX) |
Not supported |
Exact Numbers |
|
BIGINT |
Big Integer |
INT |
Integer |
SMALLINT |
Small Integer |
TINYINT |
Tiny Integer |
DECIMAL |
Currency |
NUMERIC |
Integer If the number is too big, after the Replication or Virtualization configuration, it has to be changed manually to Big Integer. |
MONEY |
Currency |
SMALLMONEY |
Currency (limited support) |
BIT |
Boolean |
Approximate Numbers |
|
FLOAT |
Float |
REAL |
Real |
Date and Time |
|
DATE |
Date-time |
DATETIME |
Date-time |
SMALLDATETIME |
Not supported |
Binary strings |
|
BINARY |
Not supported |
VARBINARY |
Not supported |
IMAGE |
Not supported |
Unicode Character Strings |
|
NCHAR |
String |
NVARCHAR |
String |
NTEXT |
Not supported |
Other Data Types |
|
UNIQUEIDENTIFIER |
Not supported |
TIMESTAMP |
Not supported |
CURSOR |
Not supported |
SQL_VARIANT |
Not supported |
TABLE |
Not supported |
XML |
Not supported |
Important
When using data virtualization or data replication, consider that you should guarantee the same (or at least very similar) collations (for SQL Server), between the external database and Bizagi's database.
This is critical if the data you will be synchronizing (mainly for string data types), contain information which has a strong dependency on such configuration.
Last Updated 2/4/2022 4:25:04 PM