SAP HANA data types supported in ArcGIS

When you create a table or add a column to a table in a database, you define a specific data type for the column. Data types determine the following:

  • What values you can store in the column
  • What operations you can use on the data in that column
  • How the data in that column is stored in the database

ArcGIS works with specific data types. When you access a database table through a Database Connection, query layer, or web service, ArcGIS filters out any unsupported data types. ArcGIS does not display unsupported data types, and you cannot edit unsupported data types through ArcGIS. Similarly, when you use ArcGIS to copy and paste tables containing unsupported data types from one database to another, ArcGIS only pastes columns that use a supported data type.

The first column in the following table lists the ArcGIS data types. The second column lists the SAP HANA data type that ArcGIS creates. The third column shows what other SAP HANA data types, if any, map to the ArcGIS data type when you view a table that you created outside ArcGIS (not registered with the geodatabase). The last column provides additional information when needed.

ArcGIS data typesSAP HANA data types createdOther SAP HANA data types that can be viewedNotes

BLOB

BLOB

Date

timestamp

date, seconddate, time

Double

decimal(38,8)

decimal(m,n), number(m,n), numeric(m,n), bigint

m > 0

The precision and scale specified in ArcGIS affects the resultant data type created in the database.

Float

decimal(38,8)

decimal(m,n)

m <= 9 and n > 0

The precision and scale specified in ArcGIS affects the resultant data type created in the database.

Geometry

ST_Geometry

Global ID

character(38)

Only supported in geodatabases.

GUID

character(38)

Latin character set

Long Integer

integer

decimal(m,0)

m <= 9

Object ID

bigint

Only 32-bit numbers stored at this time.

Raster

Not applicable

Rasters are only supported in geodatabases. Rasters created in geodatabases in SAP HANA use an Esri proprietary data type.

Short Integer

smallint

tinyint

Text

varchar(50)

alphanum(n), nvarchar(n), CLOB, NCLOB