read spatial SQL i arcGIS portal using FME server

570
2
12-20-2016 03:55 AM
RonnieUtter
New Contributor

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 )

0 Kudos
2 Replies
DerekLaw
Esri Community Moderator

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,

0 Kudos
RonnieUtter
New Contributor

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. 

0 Kudos