Available Formats

FME supports a number of readers/writers for SDE and Geodatabase. Which to use depends on the platform you are running on, and what your needs are.


For a comparison of the capabilities of each of these see ESRI Readers and Writers.
  • Esri Geodatabase (Personal Geodatabase)
  • Esri Geodatabase (File Geodatabase ArcObjects)
  • Esri Geodatabase (File Geodatabase Raster Dataset)
  • Esri Geodatabase (File Geodatabase API)
  • Esri Geodatabase (XML Workspace Document)
  • Esri Geodatabase (ArcSDE Geodatabase)
  • Esri Geodatabase (ArcSDE Geodatabase Raster Dataset)
  • Esri ArcSDE
  • Esri ArcSDE Raster
  • Esri ArcSDE Raster Map
  • Esri ArcSDE Raster Catalog

Esri Geodatabase

In the case of ALL ESRI Geodatabase formats you need an install of ArcGIS (or equivalent) on the same server as FME and an appropriate ArcGIS license. See ESRI Licensing. FME uses the ArcGIS ArcObjects API and this must be both accessible and licensed.

Supported Versions

FME support will be available for an ArcGIS version as long as ESRI considers it still active.

Public documents that contain ESRI Product Life Cycle information can be found at:

http://resources.arcgis.com/content/product-life-cycleshttp://support.esri.com/knowledgebase/relatedDocs/ProductLifeCycle.pdf

According to these, ArcGIS 8.3 was retired on the 1st September 2008, ArcGIS 9.0 in December 2008 and ArcGIS 9.1 in June 2010.

Version Compatibility

This table provides an overview of which version of FME is required if you are working with a particular version of ESRI ArcGIS.


       ArcGIS Version       

     FME Version     

     Comment    

ArcGIS 10.0

  FME 2010 SP2 or higher, including FME 2011 and FME 2012

 

ArcGIS 9.3

FME 2009 or higher

 

ArcGIS 9.2

FME 2008 or higher

 

ArcGIS 9.1

FME 2006GB or higher

  ESRI has retired this 



Additional information on version compatibiilty between client versions and geodatabase versions can be found via this Esri page


Esri ArcSDE

This section relates to accessing native ArcSDE with the ESRI ArcSDE or ESRI ArcSDE Raster Reader and Writer.
It does not apply to FME's Geodatabase Readers and Writers; these access Enterprise Geodatabase (ArcSDE) via ArcObjects and have always required an appropriately-licensed version of ArcGIS software to be installed - see above.

FME 2012 and ESRI ArcSDE Compatibility

FME 2012 does not support ArcSDE 9.1. FME 2012 has no other known compatibility issues other than those identified for FME 2009 below, relating to the distribution of the ArcSDE libraries.

FME 2011 and ESRI ArcSDE Compatibility

FME 2011 no longer supports ArcSDE 9.1 as ESRI has ceased support for ArcGIS 9.1 as of June 2010. FME 2011 has no other known compatibility issues other than those identified for FME 2009 below, relating to the distribution of the ArcSDE libraries.

FME 2010 and ESRI ArcSDE Compatibility

ArcGIS no longer uses the ARCGISHOME environment variable. FME 2010 SP2 still looks for this variable to determine the location of the SDE libraries. Add this environment variable and set it to the same location as the AGSDESKTOPJAVA or AGSSERVERJAVA variable. This has been fixed in FME 2010 SP3 and FME 2011.

FME 2010 has no other known compatibility issues other than those identified for FME 2009 below, relating to the distribution of the ArcSDE libraries.

FME 2009 and ESRI ArcSDE Compatibility

In order to avoid problems of version incompatibility, as of FME2009, FME no longer installs the required libraries for reading and writing ArcSDE.

You should instead obtain these libraries from an ESRI product to ensure compatibility between FME and your SDE database.

There are three methods for obtaining the required libraries:

1) Install ArcGIS Desktop 9.3

OR

2) Install the SDE C SDK (available on your ArcGIS Server 9.3 DVD) and set up the environment variable described below

OR

3) Install ArcEngine and check for the environment variable described below


For options 2 or 3 you will need to set up a system environment variable as follows:

 Variable Name - SDEHOME Value - <ArcGIS Directory>\arcsde\ (i.e. pointing to whichever folder contains the bin folder which contains the SDE .dlls which are sde.dll, pe.dll & sg.dll)


Q) Does FME 2009 or higher work with ArcSDE 9.2?

Yes - however the same requirements exist as described above for ArcSDE 9.3. Install a 9.2 product and ensure that the system environment variable ARCGISHOME has been set as described above.


Q) Does FME 2009 or higher work with ArcSDE 9.1?

A) Yes. However you will need to download and install some other ESRI product with newer versions of the dlls than are available in an ArcGIS 9.1 install. The simplest solution is to download and install ArcGIS Explorer and then add the SDEHOME variable as described above. As of FME 2011 we can no longer guarantee support for ArcSDE 9.1.


Versions required for ArcSDE Writing

This table provides an overview of which version of FME is required if you are WRITING to ArcSDE or Enterprise Geodatabase.

  • = supported
  • User-added image = supported but see comments
  • - = not supported

FME Version   ArcSDE 9.1 ArcSDE 9.2 ArcSDE 9.2 SP5+ and 9.3 ArcSDE 10.0 Comment
ArcGIS 9.2 DataInterop Import Tool User-added image - -  
ArcGIS 9.3 DataInterop Import Tool -  
ArcGIS 10.0 DataInterop Import Tool  
ArcGIS 9.2 Extended with FME   - Needs FME 2008 or higher available from Our Download Site
ArcGIS 9.3 Extended with FME   -  
ArcGIS 10.0 Extended with FME   User-added image Requires FME 2010 SP2 or higher available from Our Download Site
FME 2009 ArcSDE Vector - See Direct Connect Issues
Geodatabase - ArcGIS/ArcEngine Client needs to be compatible with the Geodatabase
ArcSDE Raster -  
FME 2010 ArcSDE Vector Requires SP2 available from Our Download Site
Geodatabase User-added image
Requires SP2 available from Our Download Site.

ArcGIS/ArcEngine Client needs to be compatible with the Geodatabase

ArcSDE Raster Requires SP2 available from Our Download Site
FME 2011 ArcSDE Vector -  
Geodatabase - ArcGIS/ArcEngine Client needs to be compatible with the Geodatabase
ArcSDE Raster -  
FME 2012 ArcSDE Vector -  
Geodatabase (Vector & Raster) - ArcGIS/ArcEngine Client needs to be compatible with the Geodatabase
ArcSDE Raster -  


See Safe Software for additional information on the FME Desktop editions (license levels) that work with ESRI data formats and products.


64 bit FME and the Esri formats

This table explains the interaction of the platform of the OS and FME with the various components of the Esri formats.


OS FME ArcGIS Geodatabase ArcSDE
(SDE30)
Direct Connect
32 bit Windows 32 bit 32 bit fully supported can access 32 and 64 bit SDE databases  (1) requires a 32 bit database client (2)
           
  32 bit File Geodatabase API supported (6) not supported not supported
           
64 bit Windows 32 bit 32 bit fully supported can access 32 and 64 bit SDE databases (1) requires a 32 bit database client (2)
           
  64 bit 32 bit not supported (3) supported if the 64 bit SDE SDK is installed (1) requires a 64 bit database client and the 64 bit direct connect libraries (4)
           
  64 bit FME Server (5) 64 bit ArcGIS Server 10.1 supported supported supported
           
  64 bit File Geodatabase API supported (6) not supported not supported
           
64 bit Linux 64 bit File Geodatabase API supported (6) not supported not supported

 
 (1) - 32 bit and 64 bit FME both support the Esri ArcSDE formats. See here for information on which .dlls are required and where to put them. However this reader/writer does not provide full geodatabase support e.g. Annotation is read as polygons rather than text - see here for information on the differences

(2) - Direct connect can be used with both the Geodatabase and ArcSDE readers and writers but requires a database client which matches the platform of the FME install.

(3) - 64 bit FME does not support the Esri Geodatabase formats as the ArcObjects library is a 32 bit library. See here for more information related to running 64 bit FME.

(4) - 64 bit FME can only Direct Connect using the ArcSDE reader/writer. There are no Geodatabase reader/writers in 64 bit FME with 32 bit ArcGIS installed.

(5) - 64 bit FME Server will provide full Geodatabase support when 64 bit ArcGIS Server 10.1 is installed on the same machine. This will allow 64 bit FME Server to run workspaces which read/write Geodatabases. However the workspaces will still have to be built and tested using a 32 bit FME Desktop with ArcGIS installed

(6) - The File Geodatabase API reader/writer provides geodatabase support on 64 bit Windows and Linux however it is a limited set of geometry and only works with 10.0 File Geodatabases. For example annotation is unsupported. See here for more information.
 

**  If the Esri formats are greyed out in the format galley then additional troubleshooting information can be found can be found here for Esri Geodatabase and here for Esri ArcSDE.

 


Direct Connect Issues

See this fmepedia page for issues related specifically to Reading and Writing to Enterprise Geodatabases using Direct Connect.

Data Interoperability Version Information

The FME Build indicates the build number of FME that shipped with the Data Interoperability Extension

Application          App Version    FME Version     FME Build
ESRI Data Interop     9.2 Final      2006GB           2687
ESRI Data Interop     9.2 SP3        2006GB           2696
ESRI Data Interop     9.3            2008             5301
ESRI Data Interop     9.3 SP1        2008             5303
ESRI Data Interop     9.3.1          2009             5658
ESRI Data Interop     10.0           2010             6213
ESRI Data Interop     10.0 SP1       2010 SP3+        6233