Products | Versions |
---|---|
TIBCO DataExchange | - |
Not Applicable | - |
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 <tibco_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.