I have configured Encrypt functionality for my D1IM 7.0 RP2 installation. Then configured AD synchronization, now i can see encrypted AD password in the table called DPRSystemVariables as CP_d1impassword. When update password value through Synchronization editor, system encrypting password value and stored in the database.
Where as if i run SQL Update command from Object Browser or SQL Management studio, column value stored as Plain Text.
I have used following command to update from SQL:
UPDATE DPRSYSTEMVARIABLE SET VALUE='TESTING1234' WHERE NAME='CP_D1IMPASSWORD'
How can is encrypt database value while running query from SQL? Currently the column property set as SECRET.
D1IM version: D1IM 7.0 RP2
Database: MS SQL Server 2012