Hi all,
I am fairly new to FME. What I wanted to implement I was able to figure out with the community here or the trainings at the Safe academy. But now I struggle as I do not understand, where my mistake is.
Goal: I need to write features with a dynamic schema. So, I added via Readers a “Reader as Resource”. It is an Excel file from where I want to use a specific sheet. There a added my columns which shall be written to my target source. Writing a FFS file works as expected by using the following configuration.
One important note: a sheet in excel has a limitation for the name. As I need to create a dynamic workbench which can read different source files and handle a different amount of dynamic columns per source file, I want to name it like the feature type - but shortened to what Excel can handle.

As I need also to write the same data to an EGDB, I use the JDBC format - with the same configuration:

This does not work as expected. I have 2 observations.
First topic, the value given in “Schema Definition Name” is calculated as ‘’ - meaning empty string. I tried to write it in an attribute and using this one. No success. Putting the name of the sheet hard coded into the field “Schema Definition Name” - it magically works. But it should work dynamically, right?
Second topic, using the hard coded value and trying to get it run, I get an error message like
com.microsoft.sqlserver.jdbc.SQLServerException: The given value of type VARCHAR(22) from the data source cannot be converted to type varchar(13) of the specified target column.
The table in the EGDB is configured with column length varchar(255). Why do I get this error message? And where can I turn off to re-create the table or adjust the column type? Feature Operation is “Insert”, Table Handling is “Use Existing”.
I am using FME Workbench 2024.0, tested it with 2025.0 - same behaviour. Any ideas are appreciated!