Updating from arcsde to arcserver

19-May-2016 20:48 by 9 Comments

Updating from arcsde to arcserver - Like webcam xxx com

Is it possible and/or feasible for an Oracle trigger to periodically update Arc SDE via a REST geoprocessing service? The reason for this is that I have an Oracle database that is separate from the SDE database, and there are number of business rules that we want to run first, before inserting the geometry into SDE. Point features via Arc GIS Server via Arc SDE loaded onto web map 2. Edits to points first get written to Oracle, then, via trigger to Arc SDE Would it be possible to work the other way?

I would consider this approach because I'm not sure how feasible it is to have a map service edit fire a trigger on a non SDE database without also having a trigger on SDE Oracle database can access web-based services (incl. You formulate & set-up the request, send it and receive & process the response.I don't have any experience with the package, but your workflow seems to be doable.Update The code could be like this: DECLARE req utl_http.req; resp utl_http.resp; name VARCHAR2(256); value VARCHAR2(1024); BEGIN utl_http.set_proxy('proxy.my-company.com', 'corp.my-company.com'); req := utl_http.begin_request(' utl_http.set_header(req, 'User-Agent', 'Mozilla/4.0'); resp := utl_http.get_response(req); LOOP utl_http.read_line(resp, value, TRUE); dbms_output.put_line(value); END LOOP; utl_http.end_response(resp); EXCEPTION WHEN utl_http.end_of_body THEN utl_http.end_response(resp); END; What database platform is the Arc SDE database hosted on ?Using Oracle and SDO_GEOMETRY as the data type this could work with the workflow below, but you need to take over management of the layer yourself rather than letting Arc SDE do this for you otherwise Arc SDE will get confused by the direct updates to the business table.As suggested by @ujjwalesri you may find it easier to use a Feature Service to edit the features directly, or investigating the use of Spatial Views if that is possible in your architecture.Pre-requisites If you are wishing to make these kind of direct updates to layers from the database side then you are really only using Arc SDE like a viewer interface to see the spatial data held in your database tables.

Once you start updating spatial information directly from the database then it's no longer trivial to edit this using the Arc GIS/Arc SDE versioning and editing stack.is to install it on a new machine or set of machines.This allows you to go back and reference your existing applications and service properties while you are creating your new Arc GIS Server site.It also minimizes downtime because you can set up the 10.1 site and then immediately redirect traffic to it once you are ready.The other approach, migrating a machine "in place", requires some downtime while you uninstall the 10.0 software, install 10.1, redeploy your services (which is not automatic), and update your applications.An in-place migration requires you to take careful notes about your service configurations before you uninstall.