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 Desktop 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

 

FME Server Data Store

 

GeoJSON

OGC GeoPackage

Geography Markup Language (GML)

Google BigQuery

 

MapInfo Tab

MapInfo Tab (FME)

 

MariaDB

 

Microsoft Access

Microsoft SQL Server

 

Microsoft SQL Server Spatial (Deprecated)

3 4

MySQL

Non-Conformance Report

 

Oracle

 

PostGIS

 

PostgreSQL/PostGIS

 

Schema Only Data

No Data

OGC Web Feature Service

5