Select to view content in your preferred language

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

904
4
Jump to solution
01-15-2024 08:08 AM
KimGarbade
Frequent Contributor

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.

0 Kudos
1 Solution

Accepted Solutions
MarceloMarques
Esri Regular Contributor

@KimGarbade - 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.

| Marcelo Marques | Esri Principal Product Engineer | Cloud & Database Administrator | OCP - Oracle Database Certified Professional | "In 1992, I embarked on my journey with Esri Technology, and since 1997, I have been working with ArcSDE Geodatabases, right from its initial release. Over the past 32 years, my passion for GIS has only grown stronger." | “ I do not fear computers. I fear the lack of them." Isaac Isimov |

View solution in original post

0 Kudos
4 Replies
Bud
by
Esteemed Contributor

Unversioned?

0 Kudos
KimGarbade
Frequent Contributor

Un... sorry.  Should have mentioned that.

0 Kudos
MarceloMarques
Esri Regular Contributor

@KimGarbade - 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.

| Marcelo Marques | Esri Principal Product Engineer | Cloud & Database Administrator | OCP - Oracle Database Certified Professional | "In 1992, I embarked on my journey with Esri Technology, and since 1997, I have been working with ArcSDE Geodatabases, right from its initial release. Over the past 32 years, my passion for GIS has only grown stronger." | “ I do not fear computers. I fear the lack of them." Isaac Isimov |
0 Kudos
Bud
by
Esteemed Contributor
0 Kudos