Supported Data Stores

1Integrate supports the following types of data stores for input (reading) and output (writing), either as standard or using FME Desktop (which requires a licence). Pay particular attention to the prerequisites attached to certain data store types:

Note: All formats listed below as using FME Desktop require FME Desktop Professional Edition, unless otherwise indicated.

Data Store Type	As standard		Using FME Desktop
	Read	Write	Read	Write
Bentley Microstation Design (V8)
Delimiter-separated value (DSV)
Autodesk AutoCAD DWG/DXF
Esri ArcGIS Server
Esri Enterprise Geodatabase			1 This format is only available on Windows. Requires FME Desktop (64-bit) Esri Edition, and ArcGIS Desktop, ArcGIS Desktop Background Processing (64-bit) and Database client (64-bit).	2This format is only available on Windows. Requires FME Desktop (64-bit) Esri Edition, and ArcGIS Desktop, ArcGIS Desktop Background Processing (64-bit) and Database client (64-bit).
Esri File Geodatabase
Esri Shapefile
Google BigQuery
MapInfo Tab
Microsoft SQL Server Spatial			3 This format is only available on Windows. The Microsoft SQL Server 2012 Native Client must be installed.	4Windows only. Requires FME Desktop Database Edition. The Microsoft SQL Server 2012 Native Client must be installed.
Oracle
PostGIS
Web Feature Service	5 This format is only supports 2D geometries.

Commit / Copy-To Support

Not all data store types support the Commit task as a method of writing data back to a data store (see Commit Task). However, all data store types support the Copy-To task (see Copy To Task).

Data Store Type	Task Supported
	Commit	Copy-To
Bentley Microstation Design (V8)
Delimiter-separated Value (DSV)
Autodesk AutoCAD DWG/DXF
Esri ArcGIS Server
Esri Enterprise Geodatabase
Esri File Geodatabase
Esri Shapefile
MapInfo Tab
Microsoft SQL Server Spatial
Oracle
PostGIS
Google BigQuery