Question

Access Database

  • 2 November 2022
  • 9 replies
  • 8 views

Badge +5

Is there any way where I access FME server Database which already installed when i install FME Server .


9 replies

Userlevel 5
Badge +25

Yes, but it's generally not recommended. What are you trying to do?

Badge +5

i m trying to get the each work space Feature summry

 

image

Badge +5

Could you please tel me how can i access the database

Userlevel 5
Badge +25

I think it's better to use the FME Server REST API for this. There's API calls to get the input datasets and feature types of a workspace.

Badge +5

i am new could you please guide me how can i do that

Userlevel 5
Badge +25

i am new could you please guide me how can i do that

There's a recorded training for that, which should get you started. It's 2019 material, but the Rest API hasn't changed.

Badge +5

i did but how can i fetch the data from workspce and create API

http://****/fmerest/v3/repositories?fmetoken=*****

Badge +5

i am trying to get the data in api but its only showing me the file name not shoing thw data

 

 

 

Output should be like this

 

https://www.nhc.noaa.gov/CurrentStorms.json

Userlevel 5
Badge +25

i am trying to get the data in api but its only showing me the file name not shoing thw data

 

 

 

Output should be like this

 

https://www.nhc.noaa.gov/CurrentStorms.json

Can you be a bit more clear about what you want? Do you want to get the feature counts? Those are only shown and tracked in FME Desktop at runtime, if you want to get those in FME Server you'll need to add custom logging/reporting to your workspace, e.g. by adding StatisticsCalculators at the relevant points and write the results to a file of your choice.

Reply