Skip to main content
Solved

Copying exact SDE attributed relationship class records and inserting to FGDB

  • February 12, 2026
  • 2 replies
  • 42 views

timboberoosky
Contributor
Forum|alt.badge.img+7

I have a source SDE Geodatabase reader and destination File Geodatabase writer, both with the exact same attributed relationship classe schemas. The File Geodatabase being written to is blank (I’m using a template) and I don’t need to re-establish any relationships, I want to write the records exactly as they appear in the SDE Geodatabase, to the File Geodatabase. I’ve read in feature types using Ignore relationships, making them type geodb_table, and the destination feature types are also geodb_table (though obviously both are in fact attributed relationship classes).

FME (2024.1.1.1) seems to want to recognize the writer feature types as relationship classes, no matter how I define them. I don’t want to have to establish the whole geodb_rel_origin_oid and geodb_rel_destination_oid values since I know what they should be already from the source (and there is no common attribute between the two source relationship class tables anyways). Is there a way to force read and write attributed relationship classes as simple geodb_tables?

 

Best answer by evieatsafe

Hi ​@timboberoosky looks like this is not possible with the File GDB writer in FME 2024, but looks like they added an advanced option to support this in 2025.0.2! A workaround in 2024 could be to use the File GDB Open API writer instead but I haven’t tested this. 

Details in the documentation for the advanced option here

Let me know if this is what you were hoping to do and if this helps get you unstuck. Happy FMEing :)

2 replies

evieatsafe
Safer
  • Safer
  • Best Answer
  • February 23, 2026

Hi ​@timboberoosky looks like this is not possible with the File GDB writer in FME 2024, but looks like they added an advanced option to support this in 2025.0.2! A workaround in 2024 could be to use the File GDB Open API writer instead but I haven’t tested this. 

Details in the documentation for the advanced option here

Let me know if this is what you were hoping to do and if this helps get you unstuck. Happy FMEing :)


timboberoosky
Contributor
Forum|alt.badge.img+7
  • Author
  • Contributor
  • March 2, 2026

Thanks ​@evieatsafe, using the File GDB Open API writer for just my direct-write annotated relationship classes, setting them as no geometry, did the trick!