Skip to main content
Question

Would like to use Database Connections as Published Parameter Options

  • June 1, 2020
  • 1 reply
  • 19 views
benvk
Contributor
Forum|alt.badge.img+8

So I have two database connections in Tools | FME Options | Database Connections.

One connection connects to our TEST database, the other to our PRODUCTION database.

I am wanting to setup a published parameter so that the user is prompted for it, then they can select either of the two connection files, when they run the workbench.

I cannot work out how to create a parameter and reference the database connections.

Is this possible?

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.

1 reply

samisnunu
Contributor
Forum|alt.badge.img+12
  • samisnunuContributor
  • Contributor
  • June 2, 2020

Do they have the same name?

Do they reference the same input tables/feature classes?

If yes:

Then you can export the corresponding connection files info as .xml file format, and share with other users so they can import at their end, all is done within the Database Connections dialog you mentioned. Just select both the TEST and PRODUCTION databases entries (multi-select) then, right click, choose Export..., but for other users to select Import... (one time setup process).

And as you have already added the Reader, its published parameter is ready for you to choose from either the TEST, or, the PRODUCTION database.

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.