Skip to main content
Solved

Batch Update SDE Connection Parameters

  • November 4, 2013
  • 1 reply
  • 23 views
travis
Contributor
Forum|alt.badge.img

We are moving away from connecting to SDE via a 3-Tier connection type to a direct connection type.  We have several hundred workspaces with connections to SDE with the 3-Tier.  I was wondering if anyone has wrote a script or know of an easy way to do change the parameters in how it connects in some type of batch process so we don't have to edit and touch each one of our workspaces manually.  Any advice or asiistance would be appreciated.

 

Thanks

Travis

Best answer by david_r

Hi,

 

 

FME workspace files are simply text files, so you could try to use an editor like Notepad++ to search and replace the connection parameters.

 

 

A couple of suggestions for more sustainable solutions:
  • Use a connection file (*.sde) rather than hardcoding the connection parameters into the reader/writer
  • Use an external configuration file that is read into scripted parameters when the workspace starts
David
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

david_r
Celebrity
  • david_rCelebrity
  • Best Answer
  • November 5, 2013
Hi,

 

 

FME workspace files are simply text files, so you could try to use an editor like Notepad++ to search and replace the connection parameters.

 

 

A couple of suggestions for more sustainable solutions:
  • Use a connection file (*.sde) rather than hardcoding the connection parameters into the reader/writer
  • Use an external configuration file that is read into scripted parameters when the workspace starts
David

Community Stats

32,154
Posts
122,043
Replies
39,812
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.