Populate a SDE Feature Class from an independent SQL Database

Question

We have real time data that is collected  in the field that then lives on a SQL database. I have a sde point feature class (I believe its on a separate server) for the corresponding data. My question is, what is the best way to link these together so that the sde FC is always updated with what was recorded in the field without interrupting services i.e. the web map the sde data is hosted on as well as other applications that use the same data.

One solution I have thought of would be to have a script that dumps the SQL data into a csv at the desired time increments and then do a simple table join with the  feature class. It has been expressed to me that it would be more desirable to reduce the moving parts (and reliability upon a csv) and attempt a SQL to SQL/SDE transaction if at all possible.

We are on 10.2

Any thoughts would be appreciated!

-L

Screen Shot 2014-03-25 at 4.16.38 PM.png.zip

Screen Shot 2014-03-25 at 4.16.50 PM.png.zip

CyrilCherian · Answer

I would suggest to create a simple windows service that run 24/7. This service will read data from SQL Server database and use ArcObjects to update SDE featureclass. Once you are using ArcObjects, it is easy for you to update versioned or un-versioned geodatabse.

Anonymous User · Answer

Original User: vangelo

Some of the se_toolkit tools can query versioned tables, but none of them can
insert or update into versions (though I started some edits that would allow
'sdeupdate' to operate in a large chain of change states).  In general, a realtime 
insert application isn't likely to be versioned, so we're talking about a very 
different use paradigm.

I'm not prepared to talk about the Python port until after I see how it works out.

- V

JoeBorgione · Answer

Hey Vince- will the current approach work with versioned feature classes?  And will your new approach work for one?