Skip to main content
Question

Parameter that shows both database and web connections?

  • March 2, 2026
  • 4 replies
  • 50 views

todd_davis
Influencer
Forum|alt.badge.img+23

I think the answer is No, but I hope someone can tell me that I am wrong.

I want a user to be able to select any existing database or webconnection for a custom transformers. Is there a parameter that allows me to do that?

Why I don’t think it is possible:

  • Existing parameters require you to select a database format first
  • webservices python doesn’t offer the capability to get a connection without knowing its name 

4 replies

david_r
Celebrity
  • March 2, 2026

I haven’t used the FME connection API, but isn’t it possible to retrieve a list of all available connections with it?

If so, you could perhaps use a scripted selection parameter to present the resulting list of connections to the user: https://docs.safe.com/fme/html/fmetools/fmetools/scripted_selection.html


todd_davis
Influencer
Forum|alt.badge.img+23
  • Author
  • Influencer
  • March 2, 2026

Thanks ​@david_r, but I don’t believe there is a way to get all connections via this method. For instance, FMENamedConnectionManager allows for getNamedConnection(), but a name is a required input.

I presume that this will likely be a security thing

 


itsmatt
Celebrity
Forum|alt.badge.img+47
  • Celebrity
  • March 3, 2026

Also from what I can tell a scripted selection is only available to an FMEPackage transformer, not your run-of-the-mill Custom Transformer

 


waterbeemds
Contributor
Forum|alt.badge.img+8
  • Contributor
  • March 3, 2026

Hi,

Have you tried using the conditional visibility option in the User Parameter section. 
With some work you can make the following: 

  • A choice list parameter with all the database types you want to use
  • A conditional visible Database Connection parameter based on you choice in the list of the previous parameter.

You could make something like this:
 

The Choice list parameter
Which then gives you a Select database parameter based on previous selected type. Prepared/existing Database connections are visible here
Add database connection opens the database connection designer for the selected database

 

You can do the same for Web connections. This should also work in the Transformer designer as it uses the same parameter structure, but you will need to test that. 
As this is made in FME Workbench, it will also work in FME Flow products like Workspace apps.

Good luck!