Trying to encrypt passwords for use in project publishing variables

book

Article ID: 8450

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Trying to encrypt passwords for use in project publishing variables for use in Javelin.

Getting an error when attempting to replace variable password with an encrypted password. The error message reads as follows: 

Column PD_VALUE has data type varchar2 (255) and is NULLABLE 
^_^KxwsUEquejqz/Ay46XOtYA==^_^ - Invalid column used 

Cause

^ is special character in Datamaker. 

Environment

TDM 4.3

Resolution

Use the Encryption Utility to Encrypt Passwords 
https://docops.ca.com/ca-test-data-manager/4-3/en/administrating/use-the-encryption-utility-to-encrypt-passwords 

^ is special character in Datamaker. you should use @caret()@ instead