Supported databases and data warehouses

You can connect from ArcGIS clients and work with the data in the databases listed here.

Each database type and provider differs from one another in how they are implemented and the functionality they provide. Additionally, the functionality provided through ArcGIS differs when accessing each. As a result, there are caveats or rules you need to be aware of when working with each source type in ArcGIS. These are listed in the following sections.

ArcGIS supports several cloud-based database-as-a-services offerings. For a list of the services currently supported, see the requirements for using ArcGIS with databases in the cloud.

Always co-locate your ArcGIS clients on the same cloud and in the same location (region) as your cloud databases.

ArcGIS clients that connect to most cloud-based database services require a database client.

SQLite is a self-contained database file format that provides access to simple features and supports a single editor. An OGC GeoPackage file is built from an SQLite database file.

Being self-contained, SQLite and GeoPackage files are useful for exchanging data between or embedding data in software packages.

Both these file types are significantly different from the other databases that ArcGIS supports.

They are files; therefore, access is controlled through the folder in which you store the file. Set privileges on the folder to limit who can access its contents.
To access a SQLite database, ArcGIS requires that the database file have the extension .sqlite. You can use Esri ST_Geometry or SpatiaLite to store and access spatial data in a database file with an .sqlite extension.
To access a GeoPackage, ArcGIS requires that the file have the extension .gpkg.
You can use only one spatial storage type per SQLite database. See Spatially enable an SQLite database for information on adding a spatial storage type to an existing database.
Field data type definitions are not enforced by SQLite or the OGC GeoPackage.
You cannot publish data in SQLite or GeoPackage files.

To create an SQLite database that uses either ST_Geometry or SpatiaLite storage, or to create a GeoPackage, use the Create SQLite Database geoprocessing tool.

Data access

You control access to an SQLite database or GeoPackage by controlling permissions on the folder where it is stored. Unlike other databases, you do not create users who are authenticated by the database or grant privileges on specific datasets to other users.

When you connect from ArcGIS to SQLite or a GeoPackage, you add a connection to the folder.

SQLite and GeoPackage files can be read by multiple users, but do not update the database or any of its contents while someone else is editing data or updating the database. For example, do not append data into an existing table or create a table in the database while someone else is loading data or creating a table in the database.

Data types

SQLite is also different from other databases in that fields are not assigned specific data types and data type definitions are not strictly enforced. Instead, SQLite uses storage classes in which values of different data types can be stored.

ArcGIS, however, can only work with one data type per field and strictly enforces data types. You should be aware of this difference in data type enforcement when viewing SQLite data in ArcGIS.

The following example creates a table with integer and text fields:

CREATE TABLE mytable (
  id INTEGER PRIMARY KEY NOT NULL,
  item TEXT,
  weight INTEGER,
  store TEXT;

Even though the weight field is defined as an integer, SQLite will allow you to store numbers with decimals in it. It will also allow you to store text in it. For example, you can insert the following records:

INSERT INTO mytable (id, item, weight, store) VALUES(
 1,
 "magnetic dual elliptical trainer with seat",
 75,
 "CardioPlus Equipment"
);

INSERT INTO mytable (id, item, weight, store) VALUES(
 2,
 "superfit treadmill4000",
 81.2,
 "Sports Pit"
);

INSERT INTO mytable (id, item, weight, store) VALUES(
 3,
 "serenity yoga mat",
 .4588,
 "Aerobic Angels Sporting Goods"
);

INSERT INTO mytable (id, item, weight, store) VALUES(
 4,
 "swim fins",
 "two",
 "The Plunge"
);

However, the values appear as follows in ArcGIS because the weight field is defined as integer:


id	item	weight	store
1	magnetic dual elliptical trainer with seat	75	CardioPlus Equipment
2	superfit treadmill4000	81	Sports Pit
3	serenity yoga mat	0	Aerobic Angels Sporting Goods
4	swim fins	0	The Plunge

See DBMS data types supported in ArcGIS for a list of which SQLite data types map to which ArcGIS data types.

See which versions of SQLite are supported with ArcGIS Pro.

ArcGIS supports querying data from Teradata. You can publish map image layers and web feature layers that reference data in Teradata. If you publish an editable web feature layer from data in Teradata, editors can use the web feature layer to update the data.

To connect from ArcGIS to a Teradata Vantage, you must install the Teradata GSS client, ICU library, and ODBC driver on the ArcGIS client machines in a specific order. See Connect to Teradata for information.

The following is a list of guidelines for using a Teradata Vantage with ArcGIS:

The spatial columns in your tables must be named shape or aliased to shape in a view.

The underlying storage for the TeradataST_Geometry type is CLOB; therefore, the name or alias of the column (shape) is the only way ArcGIS can identify that the column stores spatial data.
When you add tables to Teradata from an ArcGIS client, ArcGIS always creates the tables in the user's own database. ArcGIS does not support creating tables in a database other than the user's own database. (The user and database must have the same name.) Tables added outside of ArcGIS do not have to follow this rule, and users connected to Teradata from ArcGIS can still view and publish the data. If you publish an editable feature service, users can edit the data.
You must use the tessellation functions provided by Teradata to create and maintain a spatial index on a Teradata ST_Geometry column.

Teradata uses the tessellation spatial index with a predefined area of interest. Therefore, ArcGIS spatial operations that are based on dynamic inputs, such as zoom in, zoom out, and pan, cannot use the tessellation index. However, the tessellation index can be used in a query layer if the SQL statement used to define the query layer explicitly uses the tessellation index to query a subset of data based on an area of interest.
ArcGIS requires a unique identification field to render features in a map and to publish web services. ArcGIS Pro prompts you to specify this unique ID field when you add a spatial table to the map.

ArcGIS tools do not insert new values into the unique ID fields in a database; rather, they rely on the database to insert values to the field. Since Teradata does not have a data type or built-in mechanism to populate values in an ID field, ArcGIS tools that create rows in a database table cannot be used with Teradata.
In most cases, you store large amounts of data in a Teradata Vantage. To visualize, perform analyses, or publish data from an ArcGIS client, use a subset of data. How you do this depends on what you want to do with the data.
- If you are adding data to ArcGIS Pro for viewing and analysis within the map, add a query layer and define the query layer expression to return only a subset of the data.
- If you are adding data to ArcGIS Pro to publish a map image layer that references registered data, define a database view that contains only a subset of the data. Database views are stored in the database. You can use the Create Database View geoprocessing tool or an SQL client to define views.
- If you are adding data to ArcGIS Pro to publish a feature layer that references registered data or to publish to a portal, uncheck the option to Make newly added layers visible by default before adding your data to the map. Next, create a definition query for the layer that defines a subset of data using SQL. After you restrict the amount of data that displays on the map, make the layer visible and prepare the map for publishing.
Caution:

Unless your map is set so that data is not automatically displayed when added, do not drag data directly from your database connection to the map if you have not already defined a subset of data. Extremely large datasets, as are normally stored in a data warehouse appliance, would take an inordinate amount of time to display on the map.
If you use ArcGIS to add a feature class to your Teradata database and the spatial reference you specify for the feature class is not in the Teradata system table, ArcGIS adds a record to the Teradata SPATIAL_REF_SYS table and, consequently, the GEOMETRY_COLUMNS table.

This allows you to use more spatial references than are provided by default with Teradata. However, upgrades to major Teradata releases may drop these tables and re-create them with only default values in them.

Before you upgrade Teradata, you should always make a backup of your database. Be sure that this includes the records in these tables so you can restore them, if necessary, after a Teradata upgrade. You can follow this general procedure to back up and restore the SPATIAL_REF_SYS and GEOMETRY_COLUMNS records during a database upgrade operation:
1. Create a backup of the database.
2. Connect to a database in which you will make copies of the SPATIAL_REF_SYS and GEOMETRY_COLUMNS tables.
  
  In this example, the database is named mybackupdb.
  
  database mybackupdb;
3. Create backup copies of your tables.
  
  In this example, source tables are in the sysspatial database.
```
CREATE TABLE mybackupdb.spatial_ref_sys
  AS sysspatial.spatial_ref_sys WITH DATA;

CREATE TABLE mybackupdb.geometry_columns
  AS sysspatial.geometry_columns WITH DATA;
```
4. Upgrade the Teradata source database.
5. Connect to the database to which you copied the tables.
6. Restore the tables to the upgraded database.
```
--Restore the geometry columns table.
INSERT INTO sysspatial.geometry_columns
  SELECT * FROM mybackupdb.geometry_columns;

--Restore the spatial_ref_sys table.
INSERT INTO sysspatial.spatial_ref_sys
  SELECT * FROM mybackupdb.spatial_ref_sys
  MINUS
    SELECT * FROM sysspatial.spatial_ref_sys;
```
7. Once the contents of the tables are restored, you can delete the backup copies of the tables.
```
DROP TABLE mybackupdb.spatial_ref_sys;

DROP TABLE mybackupdb.geometry_columns;
```
8. If necessary, regrant privileges on these tables to users who create data in the database.

See which versions of the Teradata Vantage and client libraries are supported with ArcGIS.

Table of Contents

Supported databases and data warehouses

Tip:

Data access

Data types

Caution: