Nota:
Insights in ArcGIS Enterprise e Insights desktop admiten conexiones de base de datos.
En las tablas siguientes se incluye una lista de tipos de datos para cada base de datos compatible y cómo cada tipo se asigna a tipos de campos de Esri. Los tipos de campo enumerados como no compatibles no aparecerán en las tablas de su base de datos en Insights.
Tipos de datos de Google BigQuery
Nota:
BigQuery solo admite tipos de datos GEOGRAPHY que utilizan la referencia espacial 4326 (Sistema Geodésico Mundia 1984).
| Tipo de datos de BigQuery | Tipo de campo de Esri |
|---|---|
CADENA DE CARACTERES | esriFieldTypeString |
BYTES | No compatible |
INTEGER | esriFieldTypeInteger |
FLOAT | esriFieldTypeDouble |
NUMERIC | esriFieldTypeDouble |
BOOLEAN | No compatible |
RECORD | No compatible |
TIMESTAMP | esriFieldTypeDate |
DATE | esriFieldTypeDate |
TIEMPO | esriFieldTypeDate |
DATETIME | esriFieldTypeDate |
ARRAY | No compatible |
STRUCT | No compatible |
GEOGRAPHY | esriFieldTypeGeometry |
REPEATED COLUMNS | No compatible |
BIGNUMERIC | esriFieldTypeDouble |
Tipos de datos de Microsoft SQL Server
| Tipo de datos de Microsoft SQL Server | Tipo de campo de Esri |
|---|---|
bigint | esriFieldTypeDouble |
binario | esriFieldTypeString |
bit | No compatible |
char | esriFieldTypeString |
fecha | esriFieldTypeDate |
datetime | esriFieldTypeDate |
datetime2 | esriFieldTypeDate |
datetimeoffset | No compatible |
decimal | esriFieldTypeDouble |
flotante | esriFieldTypeDouble |
geografía | esriFieldTypeGeometry |
geometría | esriFieldTypeGeometry |
imagen | No compatible |
int | esriFieldTypeInteger |
dinero | esriFieldTypeDouble |
nchar | esriFieldTypeString |
ntext | No compatible |
numérico | esriFieldTypeDouble |
nvarchar | esriFieldTypeString |
real | esriFieldTypeSingle |
smalldatetime | esriFieldTypeDate |
smallint | esriFieldTypeSmallInteger |
smallmoney | esriFieldTypeDouble |
texto | No compatible |
hora | esriFieldTypeDate |
marca de hora | No compatible |
tinyint | esriFieldTypeSmallInteger |
udt | No compatible |
uniqueidentifier | esriFieldTypeString |
varbinary | No compatible |
varchar | esriFieldTypeString |
xml | No compatible |
Tipos de datos de Oracle
| Tipo de datos de Oracle | Tipo de campo de Esri |
|---|---|
Cualquier tipo | No compatible |
BFILE | No compatible |
BINARY_DOUBLE | esriFieldTypeDouble |
BINARY_FLOAT | esriFieldTypeDouble |
BLOB | No compatible |
CHAR | esriFieldTypeString |
CLOB | No compatible |
DATE | esriFieldTypeDate |
INTERVAL DAY TO SECOND | No compatible |
INTERVAL YEAR TO MONTH | No compatible |
LONG | No compatible |
LONG RAW | No compatible |
Tipos de medio | No compatible |
NCHAR | esriFieldTypeString |
NCLOB | No compatible |
NUMBER | Uno de los siguientes, en función de la precisión y la escala:
|
NVARCHAR2 | esriFieldTypeString |
RAW | No compatible |
ROWID | esriFieldTypeString |
SDO_GEOMETRY | esriFieldTypeGeometry |
SDO_GEORASTER | No compatible |
SDO_TOPO_GEOMETRY | No compatible |
ST_GEOMETRY | esriFieldTypeGeometry Nota:Los tipos de datos ST_GEOMETRY requieren la configuración de procedimientos externos antes de poder utilizarlos en Insights. Para obtener más información, consulte Configurar el extproc para acceder a ST_Geometry en Oracle. |
TIMESTAMP | esriFieldTypeDate |
TIMESTAMP WITH LOCALTIME ZONE | No compatible |
TIMESTAMP WITH TIMEZONE | No compatible |
Tipos de URI | No compatible |
UROWID | esriFieldTypeString |
VARCHAR2 | esriFieldTypeString |
Tipos de XML | No compatible |
Tipos definidos por el usuario | No compatible |
Tipos de datos de PostgreSQL
| Tipo de datos de PostgreSQL | Tipo de campo de Esri |
|---|---|
BIGINT | esriFieldTypeDouble |
BIGSERIAL | esriFieldTypeDouble |
BIT | No compatible |
BIT VARYING | No compatible |
BOOLEAN | No compatible |
BOX | No compatible |
BYTEA | No compatible |
CHARACTER | esriFieldTypeString |
CHARACTER VARYING | esriFieldTypeString |
CIDR | No compatible |
CIRCLE | No compatible |
DATE | esriFieldTypeDate |
DOUBLE PRECISION | esriFieldTypeDouble |
INET | No compatible |
INTEGER | esriFieldTypeInteger |
INTERVALO | No compatible |
JSON | No compatible |
JSONB | No compatible |
LINE | No compatible |
LSEG | No compatible |
MACADDR | No compatible |
MONEY | esriFieldTypeDouble |
NUMERIC | esriFieldTypeDouble |
PATH | No compatible |
PG_LSN | No compatible |
POINT | esriFieldTypeGeometry |
POLÍGONO | esriFieldTypeGeometry |
REAL | esriFieldTypeSingle |
SMALLINT | esriFieldTypeSmallInteger |
SMALLSERIAL | esriFieldTypeSmallInteger |
SERIAL | esriFieldTypeInteger |
TEXTO | esriFieldTypeString |
TIME (sin zona horaria) | esriFieldTypeDate |
TIME (con zona horaria) | No compatible |
TIMESTAMP (sin zona horaria) | esriFieldTypeDate |
TIMESTAMP (con zona horaria) | No compatible |
TSQUERY | No compatible |
TSVECTOR | No compatible |
TXID_SNAPSHOT | No compatible |
UUID | No compatible |
XML | No compatible |
Tipos de datos de SAP HANA
| Tipo de datos de SAP HANA | Tipo de campo de Esri |
|---|---|
ALPHANUM | esriFieldTypeString |
BIGINT | esriFieldTypeDouble |
BINTEXT | No compatible |
BLOB | No compatible |
BOOLEAN | No compatible |
CLOB | No compatible |
DATE | esriFieldTypeDate |
DECIMAL | esriFieldTypeDouble |
DOUBLE | esriFieldTypeDouble |
INTEGER | esriFieldTypeInteger |
NCLOB | No compatible |
NVARCHAR | esriFieldTypeString |
REAL | esriFieldTypeSingle |
SECONDDATE | esriFieldTypeDate |
SHORTTEXT | esriFieldTypeString |
SMALLDECIMAL | esriFieldTypeDouble |
SMALLINT | esriFieldTypeSmallInteger |
ST_GEOMETRY | esriFieldTypeGeometry |
ST_POINT | esriFieldTypeGeometry |
TEXTO | No compatible |
TIEMPO | esriFieldTypeDate |
TIMESTAMP | esriFieldTypeDate |
TINYINT | esriFieldTypeSmallInteger |
VARBINARY | No compatible |
VARCHAR | esriFieldTypeString |
Tipos de datos de Snowflake
| Tipo de datos de Snowflake | Tipo de campo de Esri |
|---|---|
ARRAY | No compatible |
BIGINT | esriFieldTypeInteger |
BOOLEAN | No compatible |
BINARY | No compatible |
CHAR | esriFieldTypeString |
CHARACTER | esriFieldTypeString |
DATE | esriFieldTypeDate |
DATETIME | esriFieldTypeDate |
DECIMAL | esriFieldTypeDouble |
DOUBLE | esriFieldTypeDouble |
DOUBLE PRECISION | esriFieldTypeDouble |
FLOAT | esriFieldTypeDouble |
FLOAT4 | esriFieldTypeDouble |
FLOAT8 | esriFieldTypeDouble |
GEOGRAPHY Nota:El tipo de datos GEOGRAPHY de Snowflake solo admite la referencia espacial 4326 (Sistema geodésico mundial de 1984). | esriFieldTypeGeometry |
GEOMETRY | esriFieldTypeGeometry |
INT | esriFieldTypeInteger |
INTEGER | esriFieldTypeInteger |
NUMBER | esriFieldTypeDouble |
NUMERIC | esriFieldTypeDouble |
OBJECT | No compatible |
REAL | esriFieldTypeSingle |
SMALLINT | esriFieldTypeSmallInteger |
CADENA DE CARACTERES | esriFieldTypeString |
TEXTO | esriFieldTypeString |
TIEMPO | esriFieldTypeDate |
TIMESTAMP | esriFieldTypeDate |
TIMESTAMP_NTZ | esriFieldTypeDate |
TIMESTAMP_LTZ | No compatible |
TIMESTAMP_TZ | No compatible |
VARBINARY | No compatible |
VARCHAR | esriFieldTypeString |
VARIANT | No compatible |
Recursos
Para obtener más información sobre bases de datos y Insights, consulte lo siguiente: