Trying to encrypt passwords for use in project publishing variables

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 

Environment

TDM 4.3

Cause

^ is special character in Datamaker. 

Resolution

Use the Encryption Utility to Encrypt Passwords 
https://techdocs.broadcom.com/us/en/ca-enterprise-software/devops/test-data-management/4-10/administrating/use-the-encryption-utility-to-encrypt-passwords.html

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