Question

How use the legacy SDE writer with versioning and archive tables

  • 29 March 2016
  • 1 reply
  • 1 view
D

Is there a parameter that needs to be set or a specific trick to getting the legacy ESRI sde writer to update archive tables when inserting records?

The current setup is as follows

A direct connection to an ArcGIS v10 geodatabase in an oracle 11g database, writing directly to the DEFAULT database version. The schema for the feature class is derived from a workspace resource pointing at the same sde database with the same connection details

This correctly updates the Adds tables for the versioned feature clases but no records are inserted into the archive tables. Is this just a product limitation, a bug or am I missing something?

I can get the archive tables to update correctly when using the ESRI Geodatabase writer, but want to avoid this due to the ArcGIS license requirements and the performance benefits of the legacy writer.

1 reply

fmelizard
Rank
Userlevel 4
Badge +13

Hi David,

This won't be possible using the legacy Esri SDE writer. That writer won't know anything about the archive tables as they are part of the Geodatabase model. It may be possible to write to them as "regular" feature types, adding additional field values as required to maintain the archiving information. But we haven't tried that ourselves so you would be off in uncharted territory if you tried it.

We recommend using the Esri Geodatabase writer for accurately maintaining your archive tables.

Regards,

Robyn

Reply


Community Stats

28,670
Posts
109,366
Replies
36,531
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.