Test Data Manager

Hi,

We are using Subset for executing in-flight masking for Oracle Database (Oracle Masked Data Pump Option) and need to use the built-in seedlist/HASHLOV function.

The scripts will be built on CA TDM Server and handed over to application team for execution.

We are informed that this execution would need a pre-requisite that the Scramble schema needs to be installed on the local Oracle database.

We have downloaded the Scramble schema setup files and our observation is that we need to update only in below section.

rem -----------------------------------------------------------------------------------------------------------
rem SET VARIABLES
rem -----------------------------------------------------------------------------------------------------------
set GT_SYS_USER=system                   --- sysdba credentials for oracle db
set GT_SYS_PASSWORD=manager    --- sysdba password
set GT_TNS=@orcl                                 --- local tns host settings (localhost:port/servicename)
set DB_USER=scramble                        --- do not change
set DB_PASSWORD=Gridt00ls            ---  do not change

Could you please advise if updating above section will suffice in the Scamble.bat file or any other changes required.

Also, please review if the mentioned updates to the variables/parameters is correct.

Regards

Shrini

Hi Shrini,

You are correct. You will need to update the section you referenced, in the scramble.bat file.

Please make sure you have the other files (scramble.ddl, scramble.dmp and scramble-post-config.ddl) in the same folder as the batch file, as these are referenced from the batch file. 

Information about the grants and public synonyms that are involved in creation of the scramble schema may be accessed on this documentation page: Install Oracle Scramble Components - CA Test Data Manager - 4.0 - CA Technologies Documentation

Note that these grants and synonyms are automatically applied when you run the scramble.bat file.

Hope this helps!

Cheers,

Sameer