Documentation Index
Fetch the complete documentation index at: https://www.integrate.io/docs/llms.txt
Use this file to discover all available pages before exploring further.
Data Type Mapping
Generic Connectors
| Source Data Type | Destination Data Type | Notes |
|---|
| INTEGER | BIGINT | |
| NUMBER | DOUBLE PRECISION | |
| STRING | VARCHAR | |
| DATETIME | TIMESTAMP WITHOUT TIMEZONE | |
| BOOLEAN | BOOLEAN | |
| ARRAY | VARCHAR | |
| OBJECT | VARCHAR | |
| *Others | VARCHAR | |
MySQL CDC
| Source Data Type | Destination Data Type | Notes |
|---|
| BIGINT | BIGINT | |
| BIGINT UNSIGNED | NUMERIC | |
| SMALLINT | SMALLINT | |
| SMALLINT UNSIGNED | INTEGER | |
| TINYINT | SMALLINT | |
| INT | INTEGER | |
| MEDIUMINT | INTEGER | |
| YEAR | INTEGER | |
| INT UNSIGNED | BIGINT | |
| MEDIUMINT UNSIGNED | BIGINT | |
| CHARACTER | VARCHAR | |
| VARCHAR | VARCHAR | |
| DATE | DATE | |
| DATETIME | TIMESTAMP WITHOUT TIMEZONE | |
| TIMESTAMP | TIMESTAMP WITHOUT TIMEZONE | |
| TIME | TIME WITH TIMEZONE | |
| DOUBLE | DOUBLE PRECISION | |
| DECIMAL | NUMERIC | |
| FLOAT | REAL | |
| TEXT | VARCHAR | |
| MEDIUMTEXT | VARCHAR | |
| TINYTEXT | VARCHAR | |
| LONGTEXT | VARCHAR | |
| ENUM | VARCHAR | |
| SET | VARCHAR | |
| BINARY | VARCHAR | |
| VARBINARY | VARCHAR | |
| BIT | BIGINT | |
| GEOMETRY | GEOMETRY | |
| GEOMETRYCOLLECTION | GEOMETRY | |
| MULTIPOINT | GEOMETRY | |
| LINESTRING | GEOMETRY | |
| MULTIPOLYGON | GEOMETRY | |
| POINT | GEOMETRY | |
| POLYGON | GEOMETRY | |
| MULTILINESTRING | GEOMETRY | |
| BLOB | VARCHAR | |
| TINYBLOB | VARCHAR | |
| MEDIUMBLOB | VARCHAR | |
| LONGBLOB | VARCHAR | |
| *Others | VARCHAR | |
PostgreSQL CDC
| Source Data Type | Destination Data Type | Notes |
|---|
| BIGINT | BIGINT | |
| BIGSERIAL | BIGINT | |
| BOOLEAN | BOOLEAN | |
| CHARACTER | CHARACTER | |
| VARCHAR | VARCHAR | |
| TEXT | VARCHAR | |
| MONEY | VARCHAR | |
| USER DEFINED | VARCHAR | |
| DATE | DATE | |
| DOUBLE PRECISION | DOUBLE PRECISION | |
| INTEGER | INTEGER | |
| SERIAL | INTEGER | |
| NUMERIC | NUMERIC | |
| REAL | REAL | |
| SMALLINT | SMALLINT | |
| SMALLSERIAL | SMALLINT | |
| TIME | TIME WITHOUT TIMEZONE | |
| TIME WITHOUT TIMEZONE | TIME WITHOUT TIMEZONE | |
| TIMESTAMP | TIMESTAMP WITHOUT TIMEZONE | |
| TIMESTAMP WITH TIMEZONE | TIMESTAMP WITH TIMEZONE | |
| TIMESTAMP WITHOUT TIMEZONE | TIMESTAMP WITHOUT TIMEZONE | |
| JSON | VARCHAR | |
| JSONB | VARCHAR | |
| ARRAY | VARCHAR | |
| BIT VARYING | VARCHAR | |
| BIT | BIGINT | |
| *Others | VARCHAR | |
SQL Server CDC
| Source Data Type | Destination Data Type | Notes |
|---|
| BIGINT | BIGINT | |
| BIT | BOOLEAN | |
| CHAR | CHARACTER | |
| VARCHAR | VARCHAR | |
| DATE | DATE | |
| FLOAT | DOUBLE PRECISION | |
| INT | INTEGER | |
| NUMERIC | NUMERIC | |
| DECIMAL | NUMERIC | |
| REAL | REAL | |
| SMALLINT | SMALLINT | |
| TIME | TIME WITHOUT TIMEZONE | |
| *Others | VARCHAR | |
Salesforce CDC
| Source Data Type | Destination Data Type | Notes |
|---|
| ID | VARCHAR | |
| REFERENCE | VARCHAR | |
| EMAIL | VARCHAR | |
| PHONE | VARCHAR | |
| PICKLIST | VARCHAR | |
| STRING | VARCHAR | |
| TEXTAREA | VARCHAR | |
| ADDRESS | VARCHAR | |
| URL | VARCHAR | |
| COMBOBOX | VARCHAR | |
| DATETIME | TIMESTAMP WITH TIMEZONE | |
| DATE | DATE | |
| DOUBLE | DOUBLE PRECISION | |
| PERCENT | NUMERIC | |
| CURRENCY | NUMERIC | |
| *Others | VARCHAR | |
Salesforce V2
| Source Data Type | Destination Data Type | Notes |
|---|
| address | VARCHAR / SUPER | Only if JSON is selected as S3 File Format |
| anyType | VARCHAR / SUPER | Only if JSON is selected as S3 File Format |
| base64 | VARCHAR | |
| boolean | BOOLEAN | |
| byte | VARCHAR | |
| calculated | VARCHAR | |
| combobox | VARCHAR | |
| currency | NUMERIC | |
| datacategorygroupreference | VARCHAR | |
| date | DATE | |
| datetime | TIMESTAMP_WITH_TIMEZONE | |
| double | DOUBLE_PRECISION | |
| email | VARCHAR | |
| encryptedstring | VARCHAR | |
| id | VARCHAR | |
| int | INTEGER | |
| json | VARCHAR / SUPER | Only if JSON is selected as S3 File Format |
| location | VARCHAR / SUPER | Only if JSON is selected as S3 File Format |
| long | BIGINT | |
| masterrecord | VARCHAR | |
| multipicklist | VARCHAR | |
| percent | NUMERIC | |
| phone | VARCHAR | |
| picklist | VARCHAR | |
| reference | VARCHAR | |
| string | VARCHAR | |
| textarea | VARCHAR | |
| time | TIME_WITHOUT_TIMEZONE | |
| url | VARCHAR | |
File Storage Taps (S3 Source)
| Source Data Type | Destination Data Type | Notes |
|---|
| STRING | VARCHAR | default value |
| BOOLEAN | BOOLEAN | |
| NUMBER | DOUBLE_PRECISION | |
| INTEGER | INTEGER | |
| ARRAY | VARCHAR | Inserted as truncated blob |
| OBJECT | VARCHAR | Inserted as truncated blob |
| BIGINT | BIGINT | |
| DATE | TIMESTAMP_WITHOUT_TIMEZONE | |
| DATETIME | TIMESTAMP_WITH_TIMEZONE | |
