Resolution:
How to generate encrypted password for DX
==============================================
1. Get the encrypted value for a password by running the following python script at the command prompt:
> cmdlineconsole -scr pg.py

a) cmdlineconsole.bat is available at path &lttibco_home>/dx/5.x/bin

b) Contents of pg.py
==============
from com.embarcadero.dt.console.communication.util.crypt import *
#Here src123 is the clear text password
encryptedPassword = CryptUtil.encrypt('src123')
print encryptedPassword

2. Get the password printed on the console and create a properties file (pg1.properties) like the following:


Sample pg1.properties file
====================
URL=jdbc:oracle:thin:@192.168.194.164:1521:DTDB
DRIVER=oracle.jdbc.driver.OracleDriver
DATABASESERVER=ORACLE
USER=src
PASSWORD=$encrypted(5abce682c4488036)

Here the PASSWORD property is created with encrypted value.

3. Create a property group with the above properties.
> pg add pg1 pg1.properties

4. Assign the property group (pg1) to a JDBCTask using DE Designer.

How to set property group in a transformer with encrypted password in it?