Data Stores

In 1Integrate, a data store describes where some external spatial data is being read from or written to.

This represents the data which will be analysed by Rules and Actions within 1Integrate.

The data store can be:

• Automatically supported formats such as Oracle Spatial databases (with or without workspaces enabled), Esri Shapefile, MapInfo Tab files.

• Other data formats via an FME Desktop integration (requires an FME Desktop licence).

  Formats available include file formats (e.g. Bentley DGN) and database formats (e.g. PostGIS). See Supported Data Store Types.

• Other data formats available via project-specific bespoke data stores.

When running a session using a data store, the data is stored in the cache (see Session Cache).

Note: Names of classes and properties in 1Integrate can contain any ISO 8859 characters. Unicode is not supported.

Note: All lengths, areas, and co-ordinates used in 1Integrate are in dataset units (the co-ordinate system used in the external data source). 1Integrate does not perform any automatic co-ordinate conversions.

Supported Data Store Types

1Integrate supports the following types of datastores for input (reading) and output (writing), either as standard or using FME Desktop (which requires a licence):

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)
Esri Enterprise Geodatabase			1Requires FME Desktop Esri Edition and ArcMap (64-bit).	2Requires FME Desktop Esri Edition and ArcMap (64-bit).
Esri File Geodatabase
Esri Shapefile
MapInfo Tab
Microsoft SQL Server Spatial				3Requires FME Desktop Database Edition.
Oracle
PostGIS