Skip to main content

List JDBC data types

GET 
/platform/jobs/jdbc/configs/allowed_datatypes

Retrieve allowed incremental-column types by database plugin before configuring a JDBC migration. The source response has a plugin map in data alongside status: true.

Example response excerpt​

{
  "status": true,
  "data": {
    "postgresql": ["timestamp with time zone", "date", "integer", "bigint"],
    "mysql": ["datetime", "timestamp", "date", "int"],
    "oracle": ["TIMESTAMP", "TIMESTAMP WITH TIME ZONE", "DATE", "NUMBER"],
    "sqlserver": ["datetime", "datetime2", "date", "int"]
  }
}

This is an excerpt, not a complete or permanently fixed allowlist. Retrieve actual values for your deployment. Oracle values are documented as case-sensitive. Prefer automatically updated modification timestamps when changed records must be captured; IDs and creation timestamps generally only catch new records.

Use the returned plugin type in incremental_column_type for Update JDBC sync mode. Qualify mode also needs primary keys.

Responses​

Allowed datatypes by engine