Supported Data Stores

1Integrate supports the following types of Data Stores for Read and Commit mapping and Copy To mapping, 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

tick cross tick tick

Bentley Microstation V8

tick cross tick  tick

Contextual Data Store

tick tick tick cross

Delimiter Separated Values (DSV)

tick cross tick cross

Esri ArcGIS Server

tick tick tick  cross

Esri Enterprise Geodatabase

tick1 tick tick2 tick

Esri File Geodatabase

tick tick tick  cross

Esri File Geodatabase (FME)

tick cross tick  tick

Esri Shapefile

tick cross tick  cross

FME Server

tick cross cross cross

GeoJSON

tick

cross

tick

cross

Geography Markup Language (GML)

tick

cross

cross

cross

Google Big Query

tick3 cross tick4  cross

MapInfo Tab

tick cross tick cross

MapInfo Tab (FME)

tick cross tick  tick

MariaDB

tick tick tick  cross

Microsoft SQL Server

tick tick tick  cross

Non-Conformance Report

tick cross cross cross

OGC GeoPackage

tick tick tick cross

OGC Web Feature Service (WFS)

tick5 cross cross cross

Oracle

tick tick tick  cross

PostgreSQL/PostGIS

tick tick tick  cross

Schema Only

tick cross cross cross