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.

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

  Data Store Type     Read Write   FME Required
Commit   Copy To

Autodesk AutoCAD DWG/DXF

 

Bentley Microstation Design (V8)

 

Contextual Data Store

Delimiter-separated value (DSV)

Esri ArcGIS Server

 

Esri Enterprise Geodatabase

1 2

Esri File Geodatabase

 

Esri File Geodatabase (FME)

 

Esri Shapefile

 

Esri Shapefile (FME)

Google BigQuery

 

MapInfo Tab

MapInfo Tab (FME)

 

MariaDB

 

Microsoft Access

Microsoft SQL Server

 

Microsoft SQL Server Spatial

3 4

MySQL

Oracle

 

OGC GeoPackage

OGC Web Feature Service

5

PostGIS

 

PostgreSQL/PostGIS