Generic Connectors
| Source Data Type | Destination Data Type | Notes |
|---|---|---|
| INTEGER | INTEGER | |
| NUMBER | BIGNUMERIC | |
| STRING | STRING | |
| DATETIME | DATETIME | |
| BOOLEAN | BOOLEAN | |
| ARRAY | JSON | |
| OBJECT | JSON | |
| *Others | STRING |
MySQL CDC
| Source Data Type | Destination Data Type | Notes |
|---|---|---|
| BIGINT | INTEGER | |
| BIGINT UNSIGNED | INTEGER | |
| SMALLINT | INTEGER | |
| SMALLINT UNSIGNED | INTEGER | |
| TINYINT | INTEGER | |
| INT | INTEGER | |
| MEDIUMINT | INTEGER | |
| YEAR | INTEGER | |
| INT UNSIGNED | INTEGER | |
| MEDIUMINT UNSIGNED | INTEGER | |
| CHARACTER | STRING | |
| VARCHAR | STRING | |
| DATE | DATE | |
| DATETIME | DATETIME | |
| TIMESTAMP | TIMESTAMP | |
| TIME | TIME | |
| DOUBLE | FLOAT | |
| DECIMAL | BIGDECIMAL | |
| FLOAT | FLOAT | |
| TEXT | VARCHAR | |
| MEDIUMTEXT | VARCHAR | |
| TINYTEXT | VARCHAR | |
| LONGTEXT | VARCHAR | |
| ENUM | VARCHAR | |
| SET | VARCHAR | |
| BINARY | VARCHAR | |
| VARBINARY | VARCHAR | |
| BIT | BIGINT | |
| GEOMETRY | GEOGRAPHY | |
| GEOMETRYCOLLECTION | GEOGRAPHY | |
| MULTIPOINT | GEOGRAPHY | |
| LINESTRING | GEOGRAPHY | |
| MULTIPOLYGON | GEOGRAPHY | |
| POINT | GEOGRAPHY | |
| POLYGON | GEOGRAPHY | |
| MULTILINESTRING | GEOGRAPHY | |
| BLOB | STRING | |
| TINYBLOB | STRING | |
| MEDIUMBLOB | STRING | |
| LONGBLOB | STRING | |
| *Others | STRING |
PostgreSQL CDC
| Source Data Type | Destination Data Type | Notes |
|---|---|---|
| BIGINT | INTEGER | |
| BIGSERIAL | INTEGER | |
| BOOLEAN | BOOLEAN | |
| CHARACTER | STRING | |
| VARCHAR | STRING | |
| TEXT | STRING | |
| MONEY | STRING | |
| USER DEFINED | STRING | |
| DATE | DATE | |
| DOUBLE PRECISION | FLOAT | |
| INTEGER | INTEGER | |
| SERIAL | INTEGER | |
| NUMERIC | BIGNUMERIC | |
| REAL | FLOAT | |
| SMALLINT | INTEGER | |
| SMALLSERIAL | INTEGER | |
| TIME | TIME | |
| TIME WITHOUT TIMEZONE | TIME | |
| TIMESTAMP | TIMESTAMP | |
| TIMESTAMP WITH TIMEZONE | TIMESTAMP | |
| TIMESTAMP WITHOUT TIMEZONE | TIMESTAMP | |
| JSON | JSON | |
| JSONB | JSON | |
| ARRAY | STRING | |
| BIT VARYING | INTEGER | |
| BIT | INTEGER | |
| *Others | STRING |