ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Can we connect Scramble DB from Target server when performing Inflight masking

book

Article ID: 199537

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

We are working on inflight masking

Table A is in Server 1
Table B is in Server 2
Scramble db is available in Server 2

The requirement is to do inflight masking from table 1 to table 2

I have created Transformation maps

I opened Data subset and set Source and Target Connection. Then I selected MS Sql Server Scrambled extract option


Can we connect Scramble DB from Target server  when performing Inflight masking

Environment

Release : 4.8, 4.9

Component : CA Test Data Manager

Resolution

We should have Scramble database in Source system. Then only dump file will be generated with masked data during export.