Skip to main content
Solved

creating parameters that are universal and on all workbenches


Forum|alt.badge.img

Is it possible to make user parameters some way into workspace parameters so each workbench I create I don't have to re-create the same parameter. I can just grab them and go. (ex Database log in parameters).

I create drop down choice multiple parameters sopeople can just select what they want in FME server.

I want to know if I can make these universal so I dont have to create new ones on each work bench

Best answer by erik_jan

In FME 2015 Named connections are introduced.

They allow you to store database connections in a file and select them by name.

This file can be distributed.

View original
Did this help you find an answer to your question?
This post is closed to further activity.
It may be a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, 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.

4 replies

erik_jan
Contributor
Forum|alt.badge.img+17
  • Contributor
  • Best Answer
  • December 2, 2015

In FME 2015 Named connections are introduced.

They allow you to store database connections in a file and select them by name.

This file can be distributed.


Forum|alt.badge.img
  • Author
  • December 2, 2015
erik_jan wrote:

In FME 2015 Named connections are introduced.

They allow you to store database connections in a file and select them by name.

This file can be distributed.

OK, but I have multiple choice parameters for all database connections so I go between different datasets. Doesnt that only work for a single connection to a database. not allowing for a drop down list when the workbench is uploaded to fme server?


erik_jan
Contributor
Forum|alt.badge.img+17
  • Contributor
  • December 2, 2015
kouri1986 wrote:

OK, but I have multiple choice parameters for all database connections so I go between different datasets. Doesnt that only work for a single connection to a database. not allowing for a drop down list when the workbench is uploaded to fme server?

What you can do is create a choice parameter with the needed database connections. These connections have to be in the connections files.

And the link the database connection parameter to the created list.

That can be done for the Readers, Writers and Transformers using the database connection.

So you will only need 1 drop down list if your Reader and Writer are not different databases.


david_r
Celebrity
  • December 3, 2015

For reference, here is a small trick/workaround I often use to copy/paste parameters between workspaces:

  • In the source workspace, insert a ParameterFetcher
  • Populate the ParameterFetcher with the parameters you want to copy
  • Copy/Paste the ParameterFetcher into the target workspace
  • The private/published parameters mentioned in the ParameterFetcher have now been copied

David


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings