Feature Service from FME Database/logs

You can use the REST interface of FME server: https://docs.safe.com/fme/html/FME_REST/apidoc/v3/index.html

If there is still something missing the default port, user and password are: 7082, fmeserver, fmeserver

good luck

I agree with @stalknecht, that's what the REST API is for. Yes, it's possible to dig directly in the database tables, but

1. they're not documented
2. it's not recommended (as far as I know)
3. they're subject to change without notice between FME versions

The problem with the REST service is that it's not a native Feature Service that I could add to an ArcGIS Operations Dashboard. Would be nice if there was something like this maybe already in FME Server ;)

@runneals If you're willing to give me a day I might have something you could test for me...

Yeah, no rush! It's been low on the to-do list, but would be nice to have headed into winter when we have to start monitoring server more closely.

@runneals I am 99% sure I have a way you can do this.... (It's not easy)

jlutherthomas wrote:

Hi @runneals

 

 

So I managed to get it working.

 

Here is a really basic dashboard (based on the last 1000 jobs):

 

 

Basically, Esri have something called Koop that you can use to 'spoof' Feature Services.

 

 

Koop does allow caching (benefits for spatial data so you're not always running FME Server jobs), but basically every time you view this dashboard, FME Server will get called (workspace calling the REST API) and get you the latest data. If the cache is expired it will go and get new data (you can configure cache timeout).

 

 

 

I'm hoping that soon I'll be able to put up an article on how to do this step-by-step for FME Server with a github repository.

For this you need to configure to Koop on Node JS (to connect to FME Server) behind NGINX (configured for reverse proxy and HTTPS) which makes Esri Feature Services, as long as the workspace returns JSON in the correct format.

 

 

I was initially playing with spatial geoservices for use in AGOL, but remembered this and adapted it for non-spatial too. If the set up doesn't scare you, then I'll let you know when the article/github repo goes up!

Inspiring. Thanks for sharing!

jlutherthomas wrote:

Hi @runneals

 

 

So I managed to get it working.

 

Here is a really basic dashboard (based on the last 1000 jobs):

 

 

Basically, Esri have something called Koop that you can use to 'spoof' Feature Services.

 

 

Koop does allow caching (benefits for spatial data so you're not always running FME Server jobs), but basically every time you view this dashboard, FME Server will get called (workspace calling the REST API) and get you the latest data. If the cache is expired it will go and get new data (you can configure cache timeout).

 

 

 

I'm hoping that soon I'll be able to put up an article on how to do this step-by-step for FME Server with a github repository.

For this you need to configure to Koop on Node JS (to connect to FME Server) behind NGINX (configured for reverse proxy and HTTPS) which makes Esri Feature Services, as long as the workspace returns JSON in the correct format.

 

 

I was initially playing with spatial geoservices for use in AGOL, but remembered this and adapted it for non-spatial too. If the set up doesn't scare you, then I'll let you know when the article/github repo goes up!

That's what I was pretty much looking for!

Is it possible/advisable to install on FME server machine itself or should it be a separate machine? Mainly looking for internal network access only, with only 1-3 users max of it.

The application itself is pretty lightweight so I don't think there would be any issues having it on the same machine, as long as node and nginx are configured to use different ports that won't conflict with FME Server. However, for best practice and just-in-case, it'd probably be better to keep them separate. I also haven't tried installing them all on the same machine, so everything I've said is pure speculation.