Skip to main content
Open

Expose sde version for Named ESRI sde connections so can be a parameter at runtime

Related products:FME Form
  • September 23, 2024
  • 4 replies
  • 25 views

mferwerda3
Contributor

Expose sde version for Named ESRI  SDE connections in Readers or FeatureReader so can be a parameter at runtime.

Unless I am missing it, the only way to parameterize sde version at runtime  is to use embedded connections.  It would be nice to have this option for named SDE ESRI connections, as making a named sde connection  every possible sde version is not practical.

4 replies

nordpil
Supporter
Forum|alt.badge.img+10
  • Supporter
  • March 6, 2025

A workaround would be to use arcpy to create a connection file in the workspace, I have done that a few times in Python Caller, then you would be able to use all the parameters there.

I doubt that it would be possible to specify from FME for an existing connection file, they live in the ESRI domain of things...


mferwerda3
Contributor
Forum|alt.badge.img+5
  • Author
  • Contributor
  • March 6, 2025

That might work on a small scale, but we would have to have over 100 sde connections for what we are doing,  and then you would also need to have the credentials someplace  in that that ArcPy script to create the SDE connections. which brings up security issues of having credentials in a script or in a FME Workspace, nether is very good.  


nordpil
Supporter
Forum|alt.badge.img+10
  • Supporter
  • March 7, 2025

You can have credentials in Database connections, and then you read them out in python using  fmewebservices.FMENamedConnectionManager()

I think it might even be more of a good fit for you if you have 100 sde connections, so that you don’t have to manage them separately. The negative is that it takes a bit of time for arcpy to create the connection.

You could also cache them if the values don’t change often.

In a scripted parameter, pseudo-code:

  • read selected db connection from another parameter
  • read version identifier from another parameter
  • Check if a .sde file exists that matches those exists in a cache folder
    • if yes, return that path
  • If not, read out credentials/server from db connection
  • Create new sde connection using arcpy and return that path

LizAtSafe
Safer
Forum|alt.badge.img+15
  • Safer
  • April 5, 2025
NewOpen

Reply


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