Skip to main content
Best Answer

User Parameters for Database Connections

  • May 20, 2020
  • 3 replies
  • 77 views
dbaldacchino1
Enthusiast
Forum|alt.badge.img+14

I wanted to centralize assignment of Database Connections in my workspace as I have quite a few transformers, readers and writers that use them and want the flexibility of switching this from one central location while testing (dev vs. test vs. production) and am noticing there is no "Connection" or 'Database Connection" type of parameter. I see "Web Connection" but nothing else. Curiously when a SQL reader is added though, a parameter is indeed added to the workspace as you can see below, but it doesn't show what kind it is (2019.1):

I will re-purpose one of these and re-link, then delete the redundant ones, but this does feel a bit of a workaround and was expecting to be able to create the user parameter from scratch. Unless of course I'm missing something? Thanks.

Best answer by david_r

What you are observing is correct, the automatically generated connection parameters have a hidden type. I do not know why, but it's always been like that.

I believe the only option is to keep only one of these connection parameters, then re-link all the other references to this common parameter.

David Baldacchino | HOK.com
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.

3 replies

dbaldacchino1
Enthusiast
Forum|alt.badge.img+14
  • dbaldacchino1Enthusiast
  • Author
  • Enthusiast
  • May 20, 2020

Although there is a way to add this way at least:

David Baldacchino | HOK.com
david_r
Celebrity
  • david_rCelebrity
  • Best Answer
  • May 22, 2020

What you are observing is correct, the automatically generated connection parameters have a hidden type. I do not know why, but it's always been like that.

I believe the only option is to keep only one of these connection parameters, then re-link all the other references to this common parameter.

dbaldacchino1
Enthusiast
Forum|alt.badge.img+14
  • dbaldacchino1Enthusiast
  • Author
  • Enthusiast
  • May 22, 2020

What you are observing is correct, the automatically generated connection parameters have a hidden type. I do not know why, but it's always been like that.

I believe the only option is to keep only one of these connection parameters, then re-link all the other references to this common parameter.

Thanks, that's exactly what I ended up doing to clean things up (see below, separate comment).

David Baldacchino | HOK.com

Community Stats

32,182
Posts
122,179
Replies
39,856
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.