Question

Read PostGIS database schema from Database using Published parameter

  • 13 March 2020
  • 1 reply
  • 3 views
parashari
Badge +1

Hi. I am working with FME 2019.1 and I have created a workbench that needs to be run by a person new to FME.

The wb uses PostGIS database where the connection details are 'Embed Connection Parameters'. There are multiple hosts which come as dropdown options (choice parameter). So, when I have select a database from the dropdown, next thing is the schema that should be reading/loading by itself of the selected host. But, that's not coming.

What is now-

 

Problem faced: It is done manually by copying the schema name from PostgreSQL server to FME. Any ideal solution for this?

Thanks.

1 reply

redgeographics
Rank
Userlevel 4
Badge +25

If you use a FeatureReader rather than a PostGIS reader you'll have some more liberty in prepping the parameters, I think that might come in useful for you.

Reply


Community Stats

28,666
Posts
109,340
Replies
36,535
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.