Test Data Manager

I have a complex requirement to perform masking over incoming data from Production to Test environment.

Also, Requirement is to work with Netezza Database. It don't support Data Maker as mentioned in the below comments from CA.

#CA TDM 4.0 supports Netezza Data warehouse to perform synthetic data generation? 

Is there any way to perform in-flight masking over incoming data without transformation maps??

Would someone suggest an idea that would help us?

Hi Jagadeesh, 

You will be able to use Fast Data Masker (FDM) with Netezza to accomplish masking scenarios. If you would like to use FDM, you need to make sure you have these requirements met:

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 read more about using FDM starting here: Mask Production Data - CA Test Data Manager - 4.1 - CA Technologies Documentation  

If you would like help implementing in flight masking 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