Hi I am looking for the best practice where to save an sde connection file when publishing to FME Server.
I am thinking to determine the location of the sde connection file using scripted parameter as below.
However when I run the workspace, I get ERROR : Python Exception <KeyError>: 'FME_SHAREDRESOURCE_DATA'
Any suggestions?
import fmeobjects
if FME_MacroValuese'FME_SHAREDRESOURCE_DATA']:
# Running on FME Server
return FME_MacroValuesV'FME_SHAREDRESOURCE_DATA'] + 'connectionFiles/sdefile.sde'
else:
#Running on FME Desktop
return '../config/sdefile.sde'