Skip to main content
Solved

Schema Mapper and embedded PostgreSQL connection parameters

  • April 19, 2023
  • 1 reply
  • 25 views

ebygomm
Influencer
Forum|alt.badge.img+44

When using the schema mapper and connecting to a postgres table and choosing embedded connections there are no options to choose a parameter that holds the relevant value.

 

For host, port, database and username, I'm able to type e.g. $(STAGING_DB) and create the link to my user parameter that way. However this doesn't work for the password field.

Is there any trick to link the password parameter?

 

image 

(FME 2021.2.0.0 Build 21784)

Best answer by ebygomm

I've discovered you can link to user parameters via the Navigator which has saved my dayimageThanks to @dbaldacchino for his comment on this idea https://community.safe.com/s/bridea/a0r4Q00000HbqhNQAR/parameterize-schemamappers-dataset-parameters

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

ebygomm
Influencer
Forum|alt.badge.img+44
  • Author
  • Influencer
  • 3422 replies
  • Best Answer
  • April 19, 2023

I've discovered you can link to user parameters via the Navigator which has saved my dayimageThanks to @dbaldacchino for his comment on this idea https://community.safe.com/s/bridea/a0r4Q00000HbqhNQAR/parameterize-schemamappers-dataset-parameters