Supported Data Stores

1Integrate supports the following types of Data Stores for Read and Commit mapping and Copy To mapping. Pay particular attention to the prerequisites attached to certain Data Store types.

Data Stores are grouped into one of the following types:

• Core - Data Stores that are provided by default in 1Integrate
• Extension - Supported extensions which require additional licensing. For example, Contextual Data Store or Google BigQuery. Please contact 1Spatial support.
• Custom - Bespoke or custom built Data Sores that are loaded as extensions to the core product.
• Deprecated - Data Stores that are not recommended for use.

There are two methods for writing data in 1Integrate, however these are not supported by all Data Store types:

• Commit Task

• Copy To Task

Data Store Type	Read	Write
		Commit	Copy To
Core
Autodesk DWG
Bentley Microstation Design V8 DGN
Delimiter Separated Values (DSV)
Esri ArcGIS Services
Esri File Geodatabase
Esri Shapefile
FME Flow
GeoJSON
Geography Markup Language (GML)
MapInfo TAB
MariaDB
Microsoft Access
Microsoft SQL Server
Non-Conformance Report
OGC GeoPackage
OGC Web Feature Service (WFS)	1 This format only supports 2D geometries.
Oracle
PostgreSQL/PostGIS
Schema Only (No Data)
Extensions
Google BigQuery	2 This format is only available as an Extension.		3 This format is only available as an Extension.
Contextual Data Store	4 This format is only available as an Extension.