DBMS stand for Database Management System. A database required on all machines that connect to a database management system.
You might have spatial or nonspatial data in a database that you want to use in ArcGIS. That database does not have to contain an enterprise Geodatabase for you to connect directly to it from the Catalog tree in ArcGIS for Desktop.
To set up a database server, install SQL Server Express and enable it to store Geodatabases, add a connection to the SQL Server instance under the Database Servers node in the Catalog tree, and create Geodatabases.
DBMS Data Types supported in ArcGIS
Dameng
IBM Db2
IBM Informix
Microsoft SQL Server
Oracle
PostgreSQL
SAP HANA
SQLite
Teradata Warehouse Appliance
Dameng
Data types
Dameng data types created
BLOB
BLOB
Date
Datetime6
Double
Dec(p,s)
Float
Dec(p,s)
Geometry
ST_Geometry
GUID
Char(38)
Long Integer
Integer
Object ID
Integer
Short Integer
Smallint
Text
Varchar
IBM Db2
Data types
Db2 data types created
BLOB
BLOB
Date
timestamp
Double
decimal(p,s)
Float
decimal(p,s)
Geometry
ST_Geometry
Global ID
char(38)
GUID
char(UUID len)
Long Integer
integer
Object ID
Character(38) when created in enterprise geodatabasesInteger with identity property when created in a database
Raster
BLOB
Short Integer
smallint
Text
varchar
IBM Informix
Data types
Informix data types created
BLOB
BLOB
Date
datetime
Double
decimal(31,8)
Float
decimial(31,8)
Geometry
ST_Geometry
Global ID
char(38)
GUID
char(UUID len)
Long Integer
integer
Object ID
char(38) when created in an enterprise geodatabaseserial when created in a database
Raster
BLOB
Short Integer
smallint
Text
varchar
Microsoft SQL Server
Data types
SQL Server data types created
BLOB
varbinary(max)
Date
datetime2(7)
Double
numeric(p,s)
Float
numeric(p,s)
Geometry
intgeometrygeography
Global ID
uniqueidentifier
GUID
uniqueidentifier
Long integer
int
Raster
BLOB, int
OBJECT ID
int(4) when created in an enterprise geodatabaseinteger with identity property when created in a database
Short integer
smallint
Text
varchar, nvarchar, varchar(max), nvarchar(max)
Oracle
Data types
Oracle data types created
BLOB
BLOB
Date
timestamp
Double
number(38,8)
Float
number(38,8)
Geometry
ST_Geometry, number(38), or SDO_Geometry
Global ID
char or nchar (UUID len)
GUID
char or nchar (UUID len)
Long Integer
number(38)
Object ID
ArcGIS to create a feature class or table in an Oracle 12c database or use the Add Incrementing ID Field geoprocessing tool to add an ID field to a table in an Oracle 12c database.
