Can these passwords be extracted from the workbench files? I am concerned from a security standpoint.
How do database connection passwords get saved in workbenches?
Best answer by david_r
You should never save any important passwords in your workspace files if you're afraid they might get into the wrong hands.
For someone who is moderately proficient in FME it is quite easy to extract the database connection password into clear text if they have access to the fmw file.
As an added layer of security you could consider also password-protecting the workspace file. Although this is no guarantee, it will help a bit. More info here: https://knowledge.safe.com/articles/603/password-protection-for-fme-workspaces.html
In the more recent versions of FME there is the concept of a named database connection, which is defined independently from the fmw file, and for which the encryption is much stronger. Highly recommended: https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Workbench/!NamedConnections/Using_Database_Connections.htm
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.