Hi ,
I'm building a workspace in FME where I need to copy multiple tables from an SDE geodatabase to a File Geodatabase (GDB). I use an Excel file to map the source and destination table names.
Excel structure:
Tablename | Destination |
---|---|
SDE_TABLE_1 | GDB_TABLE_1 |
SDE_TABLE_2 | GDB_TABLE_2 |
Workflow:
-
I read the Excel file using a FeatureReader to get the list of tables.
-
For each row, I use another FeatureReader to read the source table from the SDE using the Tablename attribute.


- I then use a FeatureWriter, setting
fme_feature_type
to the value of the Destination attribute so it writes to the correct table name.
The problem:
The destination tables are created with the correct names in the GDB, but they do not contain any attributes from the source tables only OBJECTIDs.
What am I missing here? My tables are in Excel and will be dynamic, so I can't simply explode all attributes manually.
I have a solution using a PythonCaller, but I'm interested in a more native solution using FME transformers.