If you do not encrypt your access password, it remains stored and visible in the configuration file (shared connection) or in the graph itself (internal connection). Thus, the access password can be visable in either of these two locations.

Of course, this would not present any problem if you were the only one who had access to your graph and computer. But if this is not the case then it would be wise to encrypt it, since the password allows access to the database in question.

So, in case you want and need to give someone any of your graphs, you need not give him or her the access password to the whole database. This is why it is possible to encrypt your access password. Without this option, you would be at great risk of some intrusion into your database or of some other damage from whoever who could get this access password.

Thus, it is important and possible that you give him or her the graph with the access password encrypted. This way, they would not be able to simply extract your password.

In order to hide your access password, you must select the Encrypt password checkbox in the Database connection wizard, typing a new (encrypting) password to encrypt the original (now encrypted) access password and finally clicking the Finish button.

This setting will prevent you from running the graph by choosing Run as → CloverETL graph. To run the graph, you must use the Run Configurations wizard. There, in the Main tab, you must type or find by browsing, the name of the project, the graph name, and parameter file. Then, type in the Password text area the encrypting password. The access password cannot be read now, it has been already encrypted and cannot be seen either in the configuration file or the graph.

Figure 20.6. Running a Graph with the Password Encrypted

If you should want to return to your access password, you can do it by typing the encrypting password into the Database connection wizard and clicking Finish.