topic Re: Register view as a layer to use in GeoProcessing tool in Data Management Questions

Register view as a layer to use in GeoProcessing tool

MichaelBlom — Thu, 03 Apr 2014 12:50:20 GMT

Hi there,

In the past, there was the command line tool "sdelayer -o register" and I could register a view as a layer.

From what I read in this blog posting http://blogs.esri.com/esri/supportcenter/2013/10/04/do-this-not-that-alternatives-to-using-sde-command-line-tools/, instead of using "sdelayer -o register ...."
If needing to take advantage of geodatabase functionality, you can register the feature classes/tables with the geodatabase, which will also registers them with the ArcSDE system tables during the process.

So I used this register with Geodatabase tool, and apparently "views are not supported".

Help please me with registering my view as a layer if you can.

Thanks

Mike

Re: Register view as a layer to use in GeoProcessing tool

MichaelBlom — Thu, 03 Apr 2014 13:43:52 GMT

If I right click on the view, I can see there is an option to Manage-> Register with Geodatabase, but this is greyed out

Is this because views are not supported?

Re: Register view as a layer to use in GeoProcessing tool

VinceAngelo — Fri, 04 Apr 2014 11:23:58 GMT

Views cannot have SDE-set rowid columns, and are therefore not eligible for
geodatabase registration. They are supported as simple feature classes if
the geometry column is registered with ArcSDE via 'sdelayer -o register'.

- V

Re: Register view as a layer to use in GeoProcessing tool

MichaelBlom — Fri, 04 Apr 2014 11:56:34 GMT

...which I exactly what I ended up doing... breaking out the old command line tools.