Skip to main content
Solved

Copy Tables from SDE to FileGDB Using Excel Mapping in FME

  • June 23, 2025
  • 1 reply
  • 30 views

jugoslaviaa
Enthusiast
Forum|alt.badge.img+6

 

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:

  1. I read the Excel file using a FeatureReader to get the list of tables.

  2. For each row, I use another FeatureReader to read the source table from the SDE using the Tablename attribute.

  1. 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.

Best answer by j.botterill

You may need to read up about  dynamic writing in FME to achieve this.

You may need to connect the schema port of a feature reader from source SDE to the Feature writer.

Inspect the data stream going into the same feature writer and ensure the FME Feature Type is indeed matching that of the schema stream. You may need to feature merger between using the excel data stream to swap out the names.

On the feature type Feature writer, you need to define the schema definition source… then check/remove all the records in the ‘Dynamic’ attributes tab, adjacent the user attribute definition… which you are overwriting with the schema from the feature reader SDE source. 

NB. the schema port of the feature reader has the schema in a “list” attribute{}

View original
Did this help you find an answer to your question?

1 reply

j.botterill
Influencer
Forum|alt.badge.img+40
  • Influencer
  • Best Answer
  • June 24, 2025

You may need to read up about  dynamic writing in FME to achieve this.

You may need to connect the schema port of a feature reader from source SDE to the Feature writer.

Inspect the data stream going into the same feature writer and ensure the FME Feature Type is indeed matching that of the schema stream. You may need to feature merger between using the excel data stream to swap out the names.

On the feature type Feature writer, you need to define the schema definition source… then check/remove all the records in the ‘Dynamic’ attributes tab, adjacent the user attribute definition… which you are overwriting with the schema from the feature reader SDE source. 

NB. the schema port of the feature reader has the schema in a “list” attribute{}


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings