topic Re: Can I Edit a table (no spatial data) that is registered with the geodatabase using native SQL commands? in Geodatabase Questions

Can I Edit a table (no spatial data) that is registered with the geodatabase using native SQL commands?

KimberlyGarbade — Mon, 15 Jan 2024 16:10:53 GMT

I have a table that contains no spatial data. It exists in an SDE enterprise geodatabase (SQL Server). The table contains log information generated by an FME process; data related to if a certain process ran successfully or not and why or why not. Again, this table contains no spatial data, but it is registered with the GDB. My question (and I should know this after 100 years) is can I use straight up SQL Server SQL commands to update the table (using SQL Executor in FME) or do I have to use a Writer that points specifically to an "Esri geodatabase (SDE)" format.

Basically my question is can I edit a non-spatial table that is registered with the geodatabase using native SQL commands and cut an Esri client out of the picture? The native SQL just seems much faster without the overhead.

At different times I've heard Yes, I've heard No, I've heard Yes but you shouldn't, I've heard Yes and it didn't hurt anything.... but nothing official.

Thank you for your time.

Re: Can I Edit a table (no spatial data) that is registered with the geodatabase using native SQL commands?

Bud — Mon, 15 Jan 2024 16:13:08 GMT

Unversioned?

Re: Can I Edit a table (no spatial data) that is registered with the geodatabase using native SQL commands?

MarceloMarques — Mon, 15 Jan 2024 18:35:18 GMT

@KimberlyGarbade - read this document in detail.

SQL access to enterprise geodatabase data—ArcMap | Documentation (arcgis.com)

Yes, you can edit the table (no spatial data) directly via SQL,

if the table is not registered as traditional version, then you can edit the base table directly via SQL

On the other hand, if the table is registered as traditional version, then you can edit via SQL using the multi-version view and you can even edit data in the sde.default version and in any other version.

I hope this clarifies.

Re: Can I Edit a table (no spatial data) that is registered with the geodatabase using native SQL commands?

KimberlyGarbade — Mon, 15 Jan 2024 18:46:53 GMT

Un... sorry. Should have mentioned that.

Re: Can I Edit a table (no spatial data) that is registered with the geodatabase using native SQL commands?

Bud — Mon, 15 Jan 2024 20:07:20 GMT

Editing nonversioned geodatabase data in SQL Server using SQL