Test Data Manager

  • 1.  Masking(FDM) -Creating connection file in aix environment

    Posted Apr 19, 2017 10:09 AM

    Hi,

    Is there any way a connection file can be created on aix platform? Such that user can key in the details and once saved the password can be stored in the encrypted form similar to the Fast Data masker functionality on windows platform/

     

    We are planning to run the masking scripts in the production aix server and hence will require the password to be entered from the prod server itself.

     

    Please let know of any feasible/alternative solution that will allow us to leverage this tool for masking.

     

    Regards,

    Ekta



  • 2.  Re: Masking(FDM) -Creating connection file in aix environment
    Best Answer

    Broadcom Employee
    Posted Apr 19, 2017 11:48 AM

    Per the documentation, the Supported answer is No.

     

    Fast Data Masker System Requirements

    https://docops.ca.com/ca-test-data-manager/4-0/en/provisioning-test-data/mask-production-data/fast-data-masker-system-requirements

    Operating System

    Windows 7 (or higher) is supported.

    Java

    Fast Data Masker requires a Java Runtime Environment (JRE 1.8 or higher).

    Note: If there is a problem with Java, Fast Data Masker contains a /jre folder that contains a suitable Java version.

     

    However, even though it is unsupported and untested officially by CA, we have had a Client try and do a remote batch following this documentation (it must be noted they got Java errors related to XWindows not being configured properly (AIX issue) – NOT CA’s issue.):

     

    Run Fast Data Masker Scripts Remotely

    https://docops.ca.com/ca-test-data-manager/4-0/en/provisioning-test-data/mask-production-data/run-fast-data-masker-scripts-remotely

     

    When you save the defined masking information in Fast Data Masker, Fast Data Masker creates a batch file. This batch file includes information about the location of the connection file, masking file, masking file, options file, and other related information (for example, start memory). You can use this batch file to run from a remote location where Fast Data Masker is not installed. This is helpful in scenarios where you are facing performance issues on your server because of different components installed on the server. And, to improve the performance, you want to run the batch script from a different server.

    To run this batch file from a remote location, edit the batch file and update the paths to the Fast Data Masker .jar, connection file, masking file, and options file. Ensure that they all point to valid locations. You can then run the file from a that remote location. 

    The following example snippet shows the content of a masking batch file; update the required file locations based on your requirement:

    java -Djava.util.logging.config.file="C:/Program Files/Grid-Tools/FastDataMasker/logging.properties" -Xms1000M -Xmx10000M -jar "C:/Program Files/Grid-Tools/FastDataMasker/Fastdatamasker.jar" "C:/Program Files/Grid-Tools/FastDataMasker/doc/connectSQLSERVER.txt" "C:\Users\<username>\AppData\Roaming\Grid-Tools\Fastdatamasker\MyMask.csv" "C:\Users\<username>\AppData\Roaming\Grid-Tools\Fastdatamasker\MyMask_options.txt"

    In this snippet, you can find the following example locations:

    • C:/Program Files/Grid-Tools/FastDataMasker/Fastdatamasker.jar shows the location of the Fast Data Masker .jar file.
    • C:/Program Files/Grid-Tools/FastDataMasker/doc/connectSQLSERVER.txt shows the location of the Microsoft SQL Server connection file.
    • C:\Users\<username>\AppData\Roaming\Grid-Tools\Fastdatamasker\MyMask.csv shows the location of the file that contains masking information.
    • C:\Users\<username>\AppData\Roaming\Grid-Tools\Fastdatamasker\MyMask_options.txt shows the location of the file that contains the applied options information.

     

    Our Developer states the following:

     

    “It 'should' run on AIX as well , as long as it has Java 1.8 installed - however the only customer that tried got Java errors related to XWindows not being configured properly (AIX issue) 

    so theoretically yes - but much easier to run the mask over a network from windows.”

     

    Hope this helps.

    Cheers!
    Les