Skip to main content
Question

SDE Connection Files and Versions

  • June 18, 2020
  • 3 replies
  • 36 views

Hi,

I'm trying to figure out a way to create a couple of paramaters in my workflow so that the user can select from a picklist of SDE Connection Files and available Versions to use in the various FeatureReader transformers in the workflow. Is there a way to do this without hard-coding all the values in ahead of time??

 

Thanks,

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

stalknecht
Contributor
Forum|alt.badge.img+22
  • Contributor
  • June 18, 2020

What I would do is put the connectionfiles in a folder. Use the "Directory and filepath names"-reader to output the list to a csv. Then you can import all the items in the parameter.

hope this helps


  • Author
  • June 18, 2020

Thanks @stalknecht. But what I'm looking for is something a bit more dynamic. The workflows I am working on are meant to be shared amongst a group of users, and there is a high likelyhood that people will name their connections differently than what is in a static list.

With the FeatureReader transformer, it presents a list of both SDE Connections and Versions to the user through the Parameters button. Is there not a way to tap into those lists and attach them to a paramater somehow??

 


stalknecht
Contributor
Forum|alt.badge.img+22
  • Contributor
  • June 18, 2020

Thanks @stalknecht. But what I'm looking for is something a bit more dynamic. The workflows I am working on are meant to be shared amongst a group of users, and there is a high likelyhood that people will name their connections differently than what is in a static list.

With the FeatureReader transformer, it presents a list of both SDE Connections and Versions to the user through the Parameters button. Is there not a way to tap into those lists and attach them to a paramater somehow??

 

I think you need a workspacerunner because parameters are evaluated before the translation or maybe a scripted parameter.