FDM-Connection Files DB password encryption

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

   We are planning to execute FDM within Linux shell. FDM connection file is generated using windows GUI tool.

Server DB password gets randomly generated every time we request for access and that needs FDM connection to be updated. 

To update the connection file with new password we need to use windows . This is a bottleneck and process cant be automated.

Only field encrypted is DB password, can we find out the encryption methodology/function used here ? so that we can generate the encrypted password using scripts and update FDM connection file within Linux shell itself. 

Environment

Release : 4.9

Component :

Resolution

There are two alternates to run the masking scripts from linux using connection file.

Option-1:

   In connection file, Instead of using epassword, use property as password and give the password like below.

username=Travel
password=travel

Option-2:

    You can give password value as empty and add a property promptforpassword with value as y. With this change, for every masking job execution, it prompts for a password. Once you enter the password, job starts the execution.

username=Travel
epassword=
promptforpassword=y