Is it possible?
We have today a big sql spatial database. I want to publish the data in our portal inviroment? Is it possible?
Today I do the following.
1. Read sql in arcgis pro and set up the symbols.
2. Share map layers to arcgis portal as copy features
3. Shape map layers to arcgis portal as tiles
4. Repeat step 1 and 2 once a week
But I want to, in real time, read features in portal from the sql. Is is possible?
We have the following Products
arcgis portal
arcgis pro
arcgis desktop advance
arcgis server
fme server
fme desktop
My guess is the following
Reader(SQL)--> Writer (Something) and then publish to fme server ?
(I am a FME beginner )
Hi Ronnie,
Have you looked at the Query Layers functionality in ArcMap? With query layers you can directly query a database with SQL syntax, add the queried data as a new data layer in ArcMap, then publish the map as a map service in ArcGIS Server. Then register the map service with your Portal as a new item. Whenever a request is made on the map service, the query layer requests the latest data from the database.
What is a query layer?—Help | ArcGIS Desktop
Hope this helps,
Thank you for your answer. This is problably the easiest way to do it instead of set up reader and writer function in fme ( if thats even possible in an easy way)
I have now Query layers. Unfortunately it seemes we are using SQL server 2008 and its not supported in portal <--> arcgis Pro Inviroment.