Skip to main content
Question

Securing ArcSDE connection files on FME Server

  • March 6, 2020
  • 1 reply
  • 75 views
tim_wood
Contributor
Forum|alt.badge.img+8

See https://knowledge.safe.com/questions/38060/sde-connection-files-and-fme-server.html

I might be OK with read only ArcSDE connection files being in a shared area, but ones with write access need to be restricted. So new system share may be the answer.

If I have a Workspace with a read only ArcSDE connection and a write ArcSDE connection, I can't seem to choose separate locations on server for each one - they both have to go in the same place (that's using FME 2018). So it looks like I will have to create a Workspace with the read only connection file and publish that to upload it to the shared area, then use that in Workspace with the write connection file stored locally.

Is there no way to load ArcSDE connection files into the shared area outside of Workspace publishing? Can you just copy the files to the appropriate folder on the FME Server server?

    1 reply

    david_r
    Celebrity
    • david_rCelebrity
    • March 6, 2020

    I use Python scripted parameters to determine the location of the SDE connection files, then link those to the appropriate reader/writer. Example:

    import fme
if fme.macroValues['FME_SHAREDRESOURCE_DATA']:
    # We're running on FME Server
    return fme.macroValues['FME_SHAREDRESOURCE_DATA'] + 'connectionFiles/myConnection.sde'
else:
    # We're running on FME Desktop
    return 'C:/dev/sde/myConnection.sde'

    Very trivial example, but you get the idea, I hope. This lets me pool all the connection files in a shared directory structure on the FME Server, and not having to upload the connection files every time I republish a workspace.

    Reply


    Helpful Members This Week

    Community Stats

    31,423
    Posts
    119,155
    Replies
    39,047
    Members

    Latest FME

    Terms & ConditionsCookie settingsAccessibility statement

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