Add Seedlists From a Database Table

This page explains how to create seedlists from a table in a database.
tdm48
HID_DB_seedlists
Some masking functions use a seedlist to generate replacement data. These seedlists can come from two sources:
  • Text files
  • A table in a database.
This page explains how to create seedlists from a table in a database.
 Users who initiate masking operations must have permission to access the Connection Profile for the Database that contains the Seedlist (otherwise the masking job fails with the error "Configuration did not contain any masking information so FDM cannot be started").
We recommend that you share the Connection Profile with this group.
For example, you can use a table from the Scramble database, included with the software. These tables already contain seedlists, and you can add to these tables, to use both the existing seedlists and your own. See Install Scramble Components for more information.
 
 
Seedlists from database columns
To generate seedlist(s) from a database table, you must identify three columns within the database that contains the seedlist(s):
  •  
    Name Column
    This column supplies the name(s) of the seedlist(s). CA TDM groups matching values in this column into seedlists, and takes the values for that seedlist from the corresponding values in the Value column.
  •  
    Value Column(s)
    This column(s) supplies the values for a seedlist. Values for all seedlists must be in this column(s).
  •  
    Index Column
    This column acts as an enumerator for each seedlist. For each seedlist it should start with 1 and increase in increments of 1. See the table below for a worked example.
Guide to creating a seedlist from a database table
This guide details how to add seedlists from data in tables in your database, for use with masking functions.
 
Follow these steps:
 
  1. Click 
    Configuration
     in the left-hand navigation pane.
  2. Click 
    Masking
     under the 
    Configuration
     section.
    The 
    Masking Configuration
     page opens.
  3. To use the database table that you define on this page to generate masking seedlist(s), check 
    Use Database seedlist
    .
  4. To define seedlist(s) from a database table, select it/them with the fields on this page:
    •  
      Connection Profile
      Select the connection profile from a dropdown list of the connection profiles you define. For more information, see Create and Edit Connection Profiles.
    •  
      Seedlist Table
      The name of the table that contains seedlist data (by default 'gtsrc_reference_data').
    •  
      Seedlist Name Column
      The name of the column that contains the name(s) of the seedlist(s) (by default 'rd_ref_id').
    •  
      Seedlist Value Columns
      The name(s) of the column(s) that contains the values for the seedlist(s) (by default 'rd_ref_value').
    •  
      Seedlist Index Column
      The name of the column that contains the enumerator values for each seedlist (by default 'rd_index').
  5. Click 
    Save
     to save the options above.
    Your seedlist(s) from these columns are now available for use with masking functions that take seedlists as a parameter (e.g. HASHLOV).
Example of seedlists from database table
For the table 
Seedlist_Table
 below, if you use the 
Seedlist_Name
 column as the Name column, the 
Seedlist_Value
 column as the Value column, and the 
Seedlist_Index
 column as the Index column, you create the following 3 seedlists (each of which contains 4 values):
  • UK_MALE_FIRSTNAME
  • UK_FEMALE_FIRSTNAME
  • UK_SURNAME
 
Seedlist_Table
 
Seedlist_Name
Seedlist_Value
Seedlist_Index
UK_MALE_FIRSTNAME
John
1
UK_MALE_FIRSTNAME
Peter
2
UK_MALE_FIRSTNAME
David
3
UK_MALE_FIRSTNAME
Richard
4
UK_FEMALE_FIRSTNAME
Sarah
1
UK_FEMALE_FIRSTNAME
Anne
2
UK_FEMALE_FIRSTNAME
Lucy
3
UK_FEMALE_FIRSTNAME
Jane
4
UK_SURNAME
Smith
1
UK_SURNAME
Jones
2
UK_SURNAME
Bennett
3
UK_SURNAME
Wright
4