Supported Datastores

1Integrate supports the following types of datastores 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 datastore 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)
Comma Separated Value (CSV)
Autodesk AutoCAD DWG/DXF
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
MapInfo Tab
Microsoft SQL Server Spatial			3 This format is only available on Windows.	4Windows only. Requires FME Desktop Database Edition.
Oracle
PostGIS
Google BigQuery

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)
Comma Separated Value (CSV)
Autodesk AutoCAD DWG/DXF
Esri Enterprise Geodatabase
Esri File Geodatabase
Esri Shapefile
MapInfo Tab
Microsoft SQL Server Spatial
Oracle
PostGIS
Google BigQuery