Skip to main content
Question

Read PostGIS database schema from Database using Published parameter

  • March 13, 2020
  • 1 reply
  • 25 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.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

redgeographics
Celebrity
Forum|alt.badge.img+59
  • redgeographicsCelebrity
  • Celebrity
  • 3700 replies
  • March 17, 2020

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.

FME rocks! \m/

Community Stats

32,076
Posts
121,798
Replies
39,707
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.