Test Data Manager

Expand all | Collapse all

Simple Data masking (Command Line) would be supported for Netezza data source?

Jump to Best Answer
  • 1.  Simple Data masking (Command Line) would be supported for Netezza data source?

    Posted 04-11-2017 09:04 AM

    I have a requirement to perform simple data masking from command line for Netezza data source.

    Please let us know if this option is supported for Netezza data base.



  • 2.  Re: Simple Data masking (Command Line) would be supported for Netezza data source?
    Best Answer

    Posted 04-11-2017 09:15 AM

    Hi Jagadeesh, 

     

    You should be able to accomplish this scenario with Fast Data Masker (FDM). You will just need to make sure you meet all the requirements for masking with Netezza. 

     

    Supported Data Sources - CA Test Data Manager - 4.1 - CA Technologies Documentation 

    Fast Data Masker System Requirements - CA Test Data Manager - 4.1 - CA Technologies Documentation 

    • Ensure that you can create external tables; that is, create external table privileges for the login user.
    • Increase the commit size to at least the size of the largest table to be masked.
    • PARALLEL option is not supported for Netezza, as only one external table can be created at a time.
    • If PTS is being used, this has to be run on the Primary.
    • NPS client needs 1 GB of memory per million rows being masked; this is an approximate estimate. The memory requirement depends on the size of the table to be masked (row count) and the number of columns being masked.
    • Copy the nzjdbc.jar file to the ..\Grid-Tools\FastDataMasker\lib folder.

     

    You can run a masking job remotely with a script/from command line. You can read more about it here: Fast Data Masker Best Practices - CA Test Data Manager - 4.1 - CA Technologies Documentation 

     

    If you would like help implementing masking from a command line using Netezza, I would suggest reaching out to your CA Account Manager. They will be able to find you a resource from pre-sales or services to help implement this scenario in your particular environment. If you do not know who your account manager is, you can call CA Customer Care here and they will be able to tell you: Contact CA Support - CA Technologies 

     

    Best regards,

    Taylor