Skip to main content
Question

Access Database

  • November 2, 2022
  • 9 replies
  • 21 views

Forum|alt.badge.img+5

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

9 replies

redgeographics
Celebrity
Forum|alt.badge.img+60
  • Celebrity
  • 3704 replies
  • November 2, 2022

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


Forum|alt.badge.img+5
  • Author
  • 170 replies
  • November 2, 2022

i m trying to get the each work space Feature summry

 

image


Forum|alt.badge.img+5
  • Author
  • 170 replies
  • November 2, 2022

Could you please tel me how can i access the database


redgeographics
Celebrity
Forum|alt.badge.img+60
  • Celebrity
  • 3704 replies
  • November 2, 2022

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.


Forum|alt.badge.img+5
  • Author
  • 170 replies
  • November 2, 2022

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


redgeographics
Celebrity
Forum|alt.badge.img+60
  • Celebrity
  • 3704 replies
  • November 2, 2022

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.


Forum|alt.badge.img+5
  • Author
  • 170 replies
  • November 2, 2022

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

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


Forum|alt.badge.img+5
  • Author
  • 170 replies
  • November 3, 2022

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


redgeographics
Celebrity
Forum|alt.badge.img+60
  • Celebrity
  • 3704 replies
  • November 3, 2022

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.