Skip to main content
Question

Read PostGIS database schema from Database using Published parameter

  • March 13, 2020
  • 1 reply
  • 22 views

parashari
Forum|alt.badge.img+2

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
Celebrity
Forum|alt.badge.img+50

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.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings