Unable to connect to a Netezza database in Fast Data Masker

Document ID : KB000004255
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

I need to connect to my Netezza database in Fast Data Masker (FDM), but I am unable to find it within the database management system (DBMS) drop down list. 

Steps to reproduce:

  1. Launch FDM by either double clicking on the icon on your desktop, or going to C:\Program Files\Grid-Tools\FastDataMasker and double clicking on the GTMAPPER.exe.
  2. A ‘Connection Files’ window should appear. Connect to one of the saved profiles you have, or create a new one to connect to. 
  3. Enter in the Connection Name, DBMS, Service Name, User Name, Password, Host Name, Port, and Default Schema of the database you are wanting to use for masking.

Expected result: I continue on to 'Save' and 'Connect' to my Netezza database profile connection. 
Actual result: Under the 'DBMS' drop down list, I cannot find the Netezza database option.

fdm connection profile.PNG

Environment:
This issue was originally found in Fast Data Masker (FDM) release version 4.2. This issue has been resolved in FDM release version 4.5.0.42.
Cause:

Netezza is an officially supported data source for data masking and data subset. However, when FDM was enhanced to use a new mapper user interface, Netezza was accidently removed from the DBMS drop down list. 

More can be read about using Netezza with the Test Data Management product package here:

  • https://docops.ca.com/ca-test-data-manager/4-1/en/installing/supported-data-sources
  • https://docops.ca.com/ca-test-data-manager/4-1/en/javelin/visual-work-flow-actions/automating-database-activities
  • https://docops.ca.com/ca-test-data-manager/4-1/en/provisioning-test-data/mask-production-data/fast-data-masker-system-requirements
Resolution:

Since the issue has been resolved in FDM 4.5.0.42, we recommend upgrading to that version or higher. Then you will be able to see Netezza as an option in the DBMS drop down list. 

 

To download the latest release of Test Data Manager (TDM) or Fast Data Masker (FDM):

  1. Login to https://support.ca.com/irj/portal/anonymous/newhome 
  2. Hover over the 'Download Center' icon and choose 'Download Products' from the list that appears.
  3. Select a Product you need to download by typing the name into the 'Enter the Product name here' text box.
    - What options appear to you here depend on what was purchased and the name that was recorded in your contract. The options below will include FDM.
    - CA Test Data Manager for Data Generation and Test Matching
    - CA Test Data Manager for Masking and Subsetting
    - CA Agile Requirements Designer Workgroup
  4. Select a Release. 
    - What numbers are shown here depends on what you chose for the product name.
    - You will need to have 3.5 or 4.5 (or higher) to see the correct FDM version for this issue.
  5. Select a Gen level.
    - Choose the highest number listed. 
  6. Check the box for 'Show me published solutions for this release' and leave all the options highlighted. 
  7. Click the 'Go' button.
  8. Next to the CA Test Data Manager Full Package 3.5.0 option that will appear, click the blue 'Download' link.
  9. On the 'Download Method' page, you will be given three options on how to download the product. 
    - Follow the prompts in order to download the product in the download method that best suits your company's policies. 
    - You can download the product through HTTP via download, through HTTP via internet browser, or FTP.
    - HTTP via download manager is the CA recommended method for download. 

If you experience any issues on the CA Support Online site either finding the product your need to download, or actually downloading the product, please call 1-800-225-5224 and a global support center representative will be able to assist you.

 

To install (finish the upgrade process) for TDM/FDM:

  1. Once the product is downloaded, you can follow the installation instructions provided in our online documentation set. Those can be read at https://docops.ca.com/ca-test-data-manager/4-1/en/installing
  2. If you would only like to upgrade the Fast Data Masker component, then from the GTServer Setup 'Prerequisites' page in the installation wizard, only check the box for 'FastDataMasker' and click the 'Next' button.
  3. Follow the installation (upgrade) prompts for the Fast Data Masker component.
  4. Once finished, restart Fast Data Masker by either double clicking on the icon on your desktop, or going to C:\Program Files\Grid-Tools\FastDataMasker and double clicking on the GTMAPPER.exe.
  5. A ‘Connection Files’ window should appear. Connect to one of the saved profiles you have, or create a new one to connect to. 
  6. Enter in the Connection Name, DBMS, Service Name, User Name, Password, Host Name, Port, and Default Schema of the database you are wanting to use for masking.
    - You should now see the Netezza database option in the DBMS drop down list. 
  7. Click the 'Save' button to save the connection details for next time.
  8. Click the 'Connect' button to connect to the Netezza profile.
    - You should now be on the FDM masking homepage. 

If you experience any issues upgrading or are still not seeing the Netezza database as an option in FDM, please open a support case.

 

If you come across this issue and you cannot upgrade to FDM 4.5.0.42 or higher, then we can provide a patch for you. To receive the patch, please open a support case referencing this knowledge base article. 

To open a support case:

  1. Login to https://support.ca.com/irj/portal/anonymous/newhome 
  2. Hover over the 'Case Management' icon and choose 'Open a new case' from the list that appears.
  3. Enter in the following Product Information:
    - Product: (Whichever name your contract has: CA Test Data Manager for Generation and Test Matching or CA Test Data Manager for Masking and Subsetting)
    - Release: (What numbers are shown here depends on what you chose for the product name: 3.1, 3.2, 3.5 versus 4.0, 4.2, 4.5)
    - Component: (This is whatever module the issue appears in with the TDM package. In this case, choose CA Test Data Manager- Fast Data Masker)
    - Operating System: (Whichever you have TDM or FDM installed on: Windows 2008, 2012, etc.)
  4. Enter in the following Case Information:
    - Severity: (This can be a 2, 3, or 4 depending on how urgent the issue is)
    - Case Title: (Need Netezza database patch for Fast Data Masker)
    - Description: (I am referencing knowledge base article ID TEC1267407. I cannot upgrade to FDM 4.5.0.42, but need to see the Netezza database option in my FDM DBMS drop down list)
    - Business Impact: (List here any urgency or deadlines that you need this by or how this is affecting your deliverables) 
  5. Verify your Contact Information:
    - Please make sure that your Primary Phone number and Email Address are correct. 
  6. Click the 'Submit' button at the bottom of the screen.

A member of the support team will be assigned your case and they will contact you. Your patch will be uploaded to CA Support Online and they will give you the below information. 

To download the patch:

  1. Login to https://support.ca.com/irj/portal/anonymous/newhome 
  2. Hover over the 'Case Management' icon and choose 'View Cases' from the list that appears.
  3. Enter in the support case number in the search field text box.
  4. Click the 'Go' button.
  5. Click on the case number from the results list. 
  6. Click on the 'File Attachments' tab.
  7. Choose the 'File Transfer Using Thin Client' option.
  8. Click on the 'files_from_CA' button.
  9. Choose the file you need to download. (fdm_netezza.zip)
  10. Click the 'Download' button.

Apply the patch:

  1. Take a backup copy of your FDM directory folder. The default location for that is C:\Program Files\Grid-Tools\FastDataMasker 
  2. Extract the zip file over C:\Program Files\Grid-Tools\FastDataMasker 
  3. Copy the nzjdbc.jar from you Netezza client install into the FDM lib folder located at C:\Program Files\Grid-Tools\FastDataMasker\lib
  4. Restart Fast Data Masker by either double clicking on the icon on your desktop, or going to C:\Program Files\Grid-Tools\FastDataMasker and double clicking on the GTMAPPER.exe.
  5. A ‘Connection Files’ window should appear. Connect to one of the saved profiles you have, or create a new one to connect to. 
  6. Enter in the Connection Name, DBMS, Service Name, User Name, Password, Host Name, Port, and Default Schema of the database you are wanting to use for masking.
    - You should now see the Netezza database option in the DBMS drop down list. 
  7. Click the 'Save' button to save the connection details for next time.
  8. Click the 'Connect' button to connect to the Netezza profile.
    - You should now be on the FDM masking homepage. 
Additional Information:

If you experience any further issues, please open a support case on https://support.ca.com/irj/portal/newhome or call support at one of these numbers https://www.ca.com/us/services-support/ca-support/contact-support.html.