SQL Server source to Avro target - connect_cdc_mimix_share - 5.8

Connect CDC System Reference Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
5.8
Language
English
Product name
Connect CDC
Title
Connect CDC System Reference Guide
Copyright
2024
First publish date
2003
ft:lastEdition
2024-02-12
ft:lastPublication
2024-02-12T15:11:59.486869

The table displays the mapping for SQL Server as a source to Avro as a target.

SQL Server Avro
bigint long
bit int
binary bytes
date string
datetime string
datetime2 string
datetimeoffset string
float float
DECIMAL float
Double Precision double
Image bytes
int int
real float
Money float
numeric float
nchar string
char string
varchar string
ntext string
nvarchar string
nvarchar(max) string
smalldatetime string
smallmoney float
Text string
tinyint int
time string
uniqueidentifier string
varbinary bytes
xml Not Supported
varchar(max) string
varbinary(max) bytes
smallint int
bigint identity long
int identity int
smallint identity int
tinyint identity int
decimal ( ) identity float
numeric ( ) identity float