Supported data types from databases

Insights in ArcGIS Enterprise
Insights desktop
Note:

Database connections are supported in Insights in ArcGIS Enterprise and Insights desktop.

The following tables list data types for each supported database, and how each type maps to Esri field types. Field types listed as not supported will not appear in your database tables in Insights.

Google BigQuery data types

Note:

BigQuery only supports GEOGRAPHY data types using spatial reference 4326 (World Geodetic System 1984).

BigQuery data typeEsri field type

STRING

esriFieldTypeString

BYTES

Not supported

INTEGER

esriFieldTypeInteger

FLOAT

esriFieldTypeDouble

NUMERIC

esriFieldTypeDouble

BOOLEAN

Not supported

RECORD

Not supported

TIMESTAMP

esriFieldTypeDate

DATE

esriFieldTypeDate

TIME

esriFieldTypeDate

DATETIME

esriFieldTypeDate

ARRAY

Not supported

STRUCT

Not supported

GEOGRAPHY

esriFieldTypeGeometry

REPEATED COLUMNS

Not supported

BIGNUMERIC

esriFieldTypeDouble

Microsoft SQL Server data types

Microsoft SQL Server data typeEsri field type

bigint

esriFieldTypeDouble

binary

esriFieldTypeString

bit

Not supported

char

esriFieldTypeString

date

esriFieldTypeDate

datetime

esriFieldTypeDate

datetime2

esriFieldTypeDate

datetimeoffset

Not supported

decimal

esriFieldTypeDouble

float

esriFieldTypeDouble

geography

esriFieldTypeGeometry

geometry

esriFieldTypeGeometry

image

Not supported

int

esriFieldTypeInteger

money

esriFieldTypeDouble

nchar

esriFieldTypeString

ntext

Not supported

numeric

esriFieldTypeDouble

nvarchar

esriFieldTypeString

real

esriFieldTypeSingle

smalldatetime

esriFieldTypeDate

smallint

esriFieldTypeSmallInteger

smallmoney

esriFieldTypeDouble

text

Not supported

time

esriFieldTypeDate

timestamp

Not supported

tinyint

esriFieldTypeSmallInteger

udt

Not supported

uniqueidentifier

esriFieldTypeString

varbinary

Not supported

varchar

esriFieldTypeString

xml

Not supported

Oracle data types

Oracle data typeEsri field type

Any types

Not supported

BFILE

Not supported

BINARY_DOUBLE

esriFieldTypeDouble

BINARY_FLOAT

esriFieldTypeDouble

BLOB

Not supported

CHAR

esriFieldTypeString

CLOB

Not supported

DATE

esriFieldTypeDate

INTERVAL DAY TO SECOND

Not supported

INTERVAL YEAR TO MONTH

Not supported

LONG

Not supported

LONG RAW

Not supported

Media types

Not supported

NCHAR

esriFieldTypeString

NCLOB

Not supported

NUMBER

One of the following, based on precision and scale:

  • esriFieldTypeSmallInteger (precision: 1–4, scale: 0)
  • esriFieldTypeInteger (precision: 5–9, scale: 0)
  • esriFieldTypeSingle (precision: 1–6, scale: 1–6)
  • esriFieldTypeDouble (precision: 7+, scale: 7+ or precision: 10+, scale: 0+)

NVARCHAR2

esriFieldTypeString

RAW

Not supported

ROWID

esriFieldTypeString

SDO_GEOMETRY

esriFieldTypeGeometry

SDO_GEORASTER

Not supported

SDO_TOPO_GEOMETRY

Not supported

ST_GEOMETRY

esriFieldTypeGeometry

Note:

ST_GEOMETRY data types require external procedures to be configured before they can be used in Insights. For more information, see Configure the extproc to access ST_Geometry in Oracle.

TIMESTAMP

esriFieldTypeDate

TIMESTAMP WITH LOCALTIME ZONE

Not supported

TIMESTAMP WITH TIMEZONE

Not supported

URI types

Not supported

UROWID

esriFieldTypeString

VARCHAR2

esriFieldTypeString

XML types

Not supported

User-defined types

Not supported

PostgreSQL data types

PostgreSQL data typeEsri field type

BIGINT

esriFieldTypeDouble

BIGSERIAL

esriFieldTypeDouble

BIT

Not supported

BIT VARYING

Not supported

BOOLEAN

Not supported

BOX

Not supported

BYTEA

Not supported

CHARACTER

esriFieldTypeString

CHARACTER VARYING

esriFieldTypeString

CIDR

Not supported

CIRCLE

Not supported

DATE

esriFieldTypeDate

DOUBLE PRECISION

esriFieldTypeDouble

INET

Not supported

INTEGER

esriFieldTypeInteger

INTERVAL

Not supported

JSON

Not supported

JSONB

Not supported

LINE

Not supported

LSEG

Not supported

MACADDR

Not supported

MONEY

esriFieldTypeDouble

NUMERIC

esriFieldTypeDouble

PATH

Not supported

PG_LSN

Not supported

POINT

esriFieldTypeGeometry

POLYGON

esriFieldTypeGeometry

REAL

esriFieldTypeSingle

SMALLINT

esriFieldTypeSmallInteger

SMALLSERIAL

esriFieldTypeSmallInteger

SERIAL

esriFieldTypeInteger

TEXT

esriFieldTypeString

TIME (without time zone)

esriFieldTypeDate

TIME (with time zone)

Not supported

TIMESTAMP (without time zone)

esriFieldTypeDate

TIMESTAMP (with time zone)

Not supported

TSQUERY

Not supported

TSVECTOR

Not supported

TXID_SNAPSHOT

Not supported

UUID

Not supported

XML

Not supported

SAP HANA data types

SAP HANA data typeEsri field type

ALPHANUM

esriFieldTypeString

BIGINT

esriFieldTypeDouble

BINTEXT

Not supported

BLOB

Not supported

BOOLEAN

Not supported

CLOB

Not supported

DATE

esriFieldTypeDate

DECIMAL

esriFieldTypeDouble

DOUBLE

esriFieldTypeDouble

INTEGER

esriFieldTypeInteger

NCLOB

Not supported

NVARCHAR

esriFieldTypeString

REAL

esriFieldTypeSingle

SECONDDATE

esriFieldTypeDate

SHORTTEXT

esriFieldTypeString

SMALLDECIMAL

esriFieldTypeDouble

SMALLINT

esriFieldTypeSmallInteger

ST_GEOMETRY

esriFieldTypeGeometry

ST_POINT

esriFieldTypeGeometry

TEXT

Not supported

TIME

esriFieldTypeDate

TIMESTAMP

esriFieldTypeDate

TINYINT

esriFieldTypeSmallInteger

VARBINARY

Not supported

VARCHAR

esriFieldTypeString

Snowflake data types

Snowflake data typeEsri field type

ARRAY

Not supported

BIGINT

esriFieldTypeInteger

BOOLEAN

Not supported

BINARY

Not supported

CHAR

esriFieldTypeString

CHARACTER

esriFieldTypeString

DATE

esriFieldTypeDate

DATETIME

esriFieldTypeDate

DECIMAL

esriFieldTypeDouble

DOUBLE

esriFieldTypeDouble

DOUBLE PRECISION

esriFieldTypeDouble

FLOAT

esriFieldTypeDouble

FLOAT4

esriFieldTypeDouble

FLOAT8

esriFieldTypeDouble

GEOGRAPHY

Note:

Snowflake GEOGRAPHY data type only supports spatial reference 4326 (World Geodetic System 1984).

esriFieldTypeGeometry

GEOMETRY

esriFieldTypeGeometry

INT

esriFieldTypeInteger

INTEGER

esriFieldTypeInteger

NUMBER

esriFieldTypeDouble

NUMERIC

esriFieldTypeDouble

OBJECT

Not supported

REAL

esriFieldTypeSingle

SMALLINT

esriFieldTypeSmallInteger

STRING

esriFieldTypeString

TEXT

esriFieldTypeString

TIME

esriFieldTypeDate

TIMESTAMP

esriFieldTypeDate

TIMESTAMP_NTZ

esriFieldTypeDate

TIMESTAMP_LTZ

Not supported

TIMESTAMP_TZ

Not supported

VARBINARY

Not supported

VARCHAR

esriFieldTypeString

VARIANT

Not supported

Resources

For more information about databases and Insights, see the following: