Solved

Read ArcSDE Enterprise Geodatabase from FME engine and transform to Oracle spatial

  • 22 March 2016
  • 3 replies
  • 4 views

Hi - There is a requirement to read ArcSDE Enterprise Geodatabase from FME engine and transform to Oracle spatial. Need the details of the readers which can be used.

icon

Best answer by david_r 23 March 2016, 09:16

View original

3 replies

Badge +2

According to this http://www.safe.com/fme/format-search/ I think you'll need the Esri Geodatabase (ArcSDE Geodb) reader which needs the Esri Edition licence for FME Desktop, and also Esri installed on the same computer. To directly write to Oracle Spatial SDO geometry you would need an Enterprise Database Edition licence, which looks like it also includes the option to read Esri Geodatabase (ArcSDE Geodb).

What edition do you have?

Also take a look at this article https://knowledge.safe.com/articles/1517/notes-on-...

According to this http://www.safe.com/fme/format-search/ I think you'll need the Esri Geodatabase (ArcSDE Geodb) reader which needs the Esri Edition licence for FME Desktop, and also Esri installed on the same computer. To directly write to Oracle Spatial SDO geometry you would need an Enterprise Database Edition licence, which looks like it also includes the option to read Esri Geodatabase (ArcSDE Geodb).

What edition do you have?

Also take a look at this article https://knowledge.safe.com/articles/1517/notes-on-...

Thanks Mark for the pointers. We are currently using the FME Desktop Oracle Edition license. Is there any plug-in available that can be used with this FME Desktop Oracle Edition license to read Esri Geodatabase (ArcSDE Geodb)?

Userlevel 4

In addition to @mark_1spatial excellent reply, you will also need to install an Oracle client (either full or instant client) on the machine where you intend to run FME. More info here.

To read the SDE data, you can either use the SDE30 reader (which does not need an ArcGIS license, but has a few limitations) or the GEODATABASE_SDE reader (which needs an ArcGIS installation with a valid license). More info here.

David

Reply