topic Re: Registering a non-spatial view or table with Enterprise Geodatabase in Geodatabase Questions

Registering a non-spatial view or table with Enterprise Geodatabase

HaniDraidi — Sun, 24 Jan 2016 12:49:05 GMT

How can I register a non-spatial view or table with Enterprise Geodatabase using Sde command line?

Any help is appreciated

Best,

Hani

Re: Registering a non-spatial view or table with Enterprise Geodatabase

ChrisDonohue__GISP — Sun, 24 Jan 2016 17:48:31 GMT

To help contributors answer this, what version of SDE are you using? Also, is it tied to Oracle, SQL server, or another? And what version?

Enterprise GIS

Chris Donohue, GISP

Re: Registering a non-spatial view or table with Enterprise Geodatabase

RebeccaStrauch__GISP — Sun, 24 Jan 2016 18:59:58 GMT

It might be worth mentioning that this is related to this other thread (slightly different question, but additional info is in that thread) Spatial view Problem which mentions "SQL Server 2014 in an enterprise geodatabase."

It's harder to find SDE command line help docs these days, but have you looked thru this help doc?

ArcGIS Server for the Microsoft .NET Framework 9.3 Help

Re: Registering a non-spatial view or table with Enterprise Geodatabase

VinceAngelo — Mon, 25 Jan 2016 03:04:19 GMT

Why do you need the non-spatial view registered with ArcSDE? There aren't many use cases that require this.

Any table or view can be registered with ArcSDE with:

sdetable -o register -t tablename -C USER -c rowidcolumn -i sde:... -D ... -u ... -p ...

But if there isn't any pressing reason to do so, I would recommend against it.

- V

Re: Registering a non-spatial view or table with Enterprise Geodatabase

HaniDraidi — Tue, 26 Jan 2016 15:04:15 GMT

Once again, Thank you very much Vince!

It worked fine!