topic Re: Open SDE enterprise versioned layer using GDAL/OGR in ArcGIS Pro SDK Questions

Open SDE enterprise versioned layer using GDAL/OGR

MK13 — Wed, 27 Sep 2023 02:08:18 GMT

Since EditOperation.Execute is excruciatingly slow when it comes to updating versioned sde feature classes, I am looking into utilising GDAL/OGR. I am able to update File geodatabase layers but not sde layers. I imagine that it's because I don't have the SDE driver but I am unsure as to how to get said driver. For gdal, I am utilising Tamas' gdal nuget packages which support FileGDB drivers but not SDE drivers unfortunately. Has anyone had success performing any gdal/ogr processing on sde data?

@Wolf @CharlesMacleod @UmaHarano @RichRuh

Re: Open SDE enterprise versioned layer using GDAL/OGR

nita14 — Thu, 28 Sep 2023 15:17:43 GMT

Hi,

You should not edit sde versioned data outside of ArcGIS client. You risk data corruption. GDAL will not help you with that, I am afraid. On the other hand, you can give a try with versioned views. Since you call SQL-commands, it should be way faster. More you can find here: What is a versioned view?—ArcMap | Documentation (arcgis.com)

Hope this helps.

Re: Open SDE enterprise versioned layer using GDAL/OGR

MK13 — Fri, 29 Sep 2023 16:27:41 GMT

Thanks for the tip and the link. Do you know if there are any code samples on how to create and edit versioned views utilizing sql with the pro sdk?

Re: Open SDE enterprise versioned layer using GDAL/OGR

nita14 — Thu, 05 Oct 2023 14:00:20 GMT

I reckon, you should use directly hit the database. ArcGIS Pro SDK does not provide any additional layer to work with versioned views.