Hello - a colleague has set up a table in an MS SQL Esri SDE and they are trying to use the FME Esri Geodatabase (ArcSDE Geodb) writer to truncate the table and insert new data.
However, when the table was created (using ArcGIS Pro) they chose some long attribute names (e.g. 45 characters). This is now causing an issue as the FME ArcSDE writer enforces a 31 character limit for attribute names. This means that we cannot get the writer schema to match the schema of the database table.
It seems that the FME Esri SDE writer is enforcing a character limit to attribute names that is stricter than the limits applied by the Esri SDE itself. Is there any way to override this limit on the FME writer?
I think we could use an MS SQL writer to truncate and insert the data but would prefer to use the Esri SDE specific writer if at all possible.
Thanks in advance.
Question
FME Esri SDE writer - attribute length enforcement
+8- Contributor
+21- Safer
Hi
Thank you for posting your question on the FME Community!
We appreciate your detailed post highlighting this issue. I’ve gone ahead and created an internal ticket for our team to look at (tracked internally as IDEA-2693). We will update this thread when we have more to share.
In the meantime, was the MS SQL Server Writer a viable workaround for you?