Skip to main content
Solved

how to change paths to SQL server in fmw file?

  • March 21, 2022
  • 2 replies
  • 19 views
T

hello

we migrated to new sql server (names changed from SERVER1 to SERVER2) and now jobs is failing.

i open failing fmw file in FMW Workbench, changed sql server names in parameters (where found), saved file, but jobs keep failing.

any suggestions?

thanks.

Best answer by keziaatsafe

Hi Tadaskiskenas,

 

Is the job failing on FME Desktop, FME Server or both?

There are two ways to add database connections on FME Server: On the Database Connections page or from FME Workbench.

Here are some documentations to look over:

Database connections for FME Server: https://docs.safe.com/fme/html/FME_Server_Documentation/WebUI/Database-Connections.htm

Database connections for FME Desktop: https://docs.safe.com/fme/html/FME_Server_Documentation/WebUI/Database-Connections.htm

https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/!NamedConnections/options_database_connections.htm

 

Hope this helps!

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.

2 replies

keziaatsafe
Safer
Forum|alt.badge.img+8
  • keziaatsafeSafer
  • Safer
  • 153 replies
  • Best Answer
  • March 21, 2022

Hi Tadaskiskenas,

 

Is the job failing on FME Desktop, FME Server or both?

There are two ways to add database connections on FME Server: On the Database Connections page or from FME Workbench.

Here are some documentations to look over:

Database connections for FME Server: https://docs.safe.com/fme/html/FME_Server_Documentation/WebUI/Database-Connections.htm

Database connections for FME Desktop: https://docs.safe.com/fme/html/FME_Server_Documentation/WebUI/Database-Connections.htm

https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/!NamedConnections/options_database_connections.htm

 

Hope this helps!

T
  • tadaskiskenas
  • Author
  • 1 reply
  • March 22, 2022

Hi Tadaskiskenas,

 

Is the job failing on FME Desktop, FME Server or both?

There are two ways to add database connections on FME Server: On the Database Connections page or from FME Workbench.

Here are some documentations to look over:

Database connections for FME Server: https://docs.safe.com/fme/html/FME_Server_Documentation/WebUI/Database-Connections.htm

Database connections for FME Desktop: https://docs.safe.com/fme/html/FME_Server_Documentation/WebUI/Database-Connections.htm

https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/!NamedConnections/options_database_connections.htm

 

Hope this helps!

hello.

long story short: open fmw file with text editor, replace all OLDSERVERNAME with NEWSERVERNAME, save.

Thanks a lot!

Community Stats

32,065
Posts
121,738
Replies
39,692
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.