Skip to main content
Question

How to write feature by feature to ArcSDE Geodb?

  • December 17, 2019
  • 2 replies
  • 25 views

arekpierchala
Contributor
Forum|alt.badge.img+1

Hi All

I would like to perform writing feature by feature to ArcSDE Geodb. I was trying to "roll" all feature attributes into one attribute (using Aggregator and GeometryExtractor) and provide such feature via WorkspaceRunner to slave workspace, "roll out" attribute into feature definition and then pass to Writer. Is it a good direction or any other suggestions?

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

erik_jan
Contributor
Forum|alt.badge.img+26
  • Contributor
  • December 17, 2019

The ArcSDE Geodb writer has the option to limit the size of a transaction.

If you set the transaction size to 1, you write feature by feature and the database will commit after each feature:

Hope this is what you were looking for.


arekpierchala
Contributor
Forum|alt.badge.img+1
  • Author
  • Contributor
  • December 20, 2019

The ArcSDE Geodb writer has the option to limit the size of a transaction.

If you set the transaction size to 1, you write feature by feature and the database will commit after each feature:

Hope this is what you were looking for.

I wasn't precise. I need to perform a feature by feature loading in order to catch all features that were not saved by the database. In your idea FME stops writing at first bad transaction