SymmetricDS Community Edition passwords hard-coding in property files

Question

We have setup SymmetricDS on Windows for SQL server databases and it's working fine. But we have hard-coded the passwords in property files. My question here is, is there any way to avoid hard-coding?

score 1 · Accepted Answer · answered Oct 14 '20 at 11:51

1

You can encrypt your passwords.

https://www.symmetricds.org/doc/3.12/html/user-guide.html#_encrypted_passwords

answered Oct 14 '20 at 11:51

chenson42

1,108
6
13

score 0 · Answer 2 · answered Oct 14 '20 at 17:07

0

If you set SQL-Server to use Windows authentication for the SymmetricDS user, then you can leave the db.user and db.password properties empty.

Sql Server - connect with windows authentication

answered Oct 14 '20 at 17:07

Eric Long

926
4
3

Thanks, Eric. Just a query...Do all users need to have windows authentication or only SymmetricDS user which currently is being used in property files? – sweenal Oct 15 '20 at 05:56
You probably have SQL-Server in mixed mode, so you can set each user to use either Windows authentication or SQL-Server authentication. You only need to affect the SymmetricDS user to use Windows authentication. – Eric Long Nov 11 '20 at 18:49

SymmetricDS Community Edition passwords hard-coding in property files

2 Answers2