Skip to main content
Solved

how to change paths to SQL server in fmw file?


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!

View original
Did this help you find an answer to your question?

2 replies

keziaatsafe
Safer
Forum|alt.badge.img+7
  • Safer
  • 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!


keziaatsafe wrote:

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!


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