Skip to main content
Open

Database Connections - make connection parameters available as published paramet

Related products:FME Form
  • April 1, 2019
  • 3 replies
  • 157 views

fmelizard
Safer
Forum|alt.badge.img+22

***Note from Migration:***

Original Title was: Database Connections - make connection parameters available as published parameters


Make it possible to make the connection parameters such as host or database name available as published parameters so that they can be used in other readers, writers, or transformers, such as SystemCaller.

More details in this Forum discussion: Database connections retrieve parameters programmatically

3 replies

Forum|alt.badge.img+2

Just to clarify: as you create a database connection, allow some of the parameters to be created as a published parameter, so the user has to enter those parameters when the connection is used - for example user name and password

'


giosp
Contributor
Forum|alt.badge.img+7
  • Contributor
  • September 30, 2019

Yes that works without problem. The idea is to set a database connection in the fme options or in the fme server database connection and retrieve each parameter from example in python... (for example: username, password,...) or in a systemCaller command ( --dbuser @username --dbpassword @password or greater for example @connectionName.username o @connectionName.password ).


LizAtSafe
Safer
Forum|alt.badge.img+21
  • Safer
  • February 8, 2024
The following idea has been merged into this idea:

All the votes have been transferred into this idea.