Skip to main content
  • EN

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.

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

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.

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).

Reply


Community Stats

30,159
Posts
114,479
Replies
37,803
Members
Terms & ConditionsCookie settings
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.