Hello GeoNet Community,
I manage a fairly simple and straightforward flex viewer for a government agency. There is a "static" map service/feature layer I publish in arc server and consume in our viewer. When updates to the data occur (on a spreadsheet) I must go into arcMap, pull the new sheet in, geocode it, and publish it over the current map service/feature layer. Recently my office has indicated that they want to get away from our "static" feature layer where I must update it after a change and instead migrate our data to a database on the server. They want input from the database to dynamically update the main feature layer in our tool.
This database work is new to me. If anyone's involved in this type of work and could help me better understand how one would go about implementing this, I would be greatly appreciative.
Some basic questions off the bat:
- What is the best type of server to utilize? PostGreSQL?
- Do I need any other licenses outside arcMap, arcServer? I see mentioning s online of ArcSDE, isn't that BIG $ (deal breaker for client)??
- Are there any solid tutorials out there on this?
Thanks for taking the time to read my post.