Skip to main content

Teradata for Masking

To configure Teradata for data masking with CUPS options

For Teradata masker, install two JAR files. You can copy these JAR files from the below mentioned locations:

XDGMFunctions.jar

/opt/Dataguise/DgSecure/IDPs/DgMaskerIDP/expandedArchive/WEB-INF/classes/com/dataguise/Worker/Masker/PrerequisiteFiles/Scripts/TeraData

fpe-oracle.jar

opt/Dataguise/DgSecure/IDPs/DgMaskerIDP/expandedArchive/WEB-INF/classes/com/dataguise/Worker/Masker/PrerequisiteFiles/Scripts/CommonFiles

  1. Copy these JAR files to a common place like in C or D drive. To install these Jar files, open “Teradata Studio” and select the database on which you want to create a masker table and functions. Execute below mentioned queries from (as) admin user (to) for install JAR files:

    Query for fpe-oracle.jar: call SQLJ.INSTALL_JAR('CJ?<PATH OF JAR FILE>','fpe-oracle_jar',0);
    Example: call SQLJ.INSTALL_JAR('CJ?D:/teradata/fpe-oracle.jar','fpe-oracle_jar',0);

    Query for XDGMFunctions.jar: call SQLJ.INSTALL_JAR('CJ?<PATH OF JAR FILE>','XDGMFunctions_JAR',0);
    Example: call SQLJ.INSTALL_JAR('CJ?D:/teradata/XDGMFunctions.jar','XDGMFunctions_JAR',0);

  2. After installing the JAR files, copy grants script from below mentioned location:
    GrantScript.sql
    “/opt/Dataguise/DgSecure/IDPs/DgMaskerIDP/expandedArchive/WEB-INF/classes/com/dataguise/Worker/Masker/PrerequisiteFiles/Scripts/TeraData”

    -OR-

    Execute the below mentioned grants queries. Run all these commands from “Teradata Studio”. These queries grant one-to-many permissions:

    1. Grant for One-to-One:
      Grant create procedure, alter procedure, create function, ALTER function, create table, execute procedure, execute function, insert, update, delete, select on <DATABASE_1> to   <DATABASE_1> ;

      Example: grant create procedure, alter procedure, create function, ALTER function, create table, execute procedure, execute function, insert, update, delete, select on Ebay to Ebay;

    2. Grant for One-to-Many:
      Grant create procedure, alter procedure, create function, ALTER function, create table, execute procedure, execute function, insert, update, delete, select on <DATABASE_2> to <DATABASE_1>;

      Example: grant create procedure, alter procedure, create function, ALTER function, create table, execute procedure, execute function, insert, update, delete, select on DG_ebay to Ebay ;

    3. Grant for One-to-One:
      Grant create procedure, alter procedure, create function, ALTER function, create table, execute procedure, execute function, insert, update, delete, select on <DATABASE_2> to <DATABASE_2> ;

      Example: grant create procedure, alter procedure, create function, ALTER function, create table, execute procedure, execute function, insert, update, delete, select on DG_ebay to DG_Ebay ;

    4. Grant for One-to-Many:
      Grant create procedure, alter procedure, create function, ALTER function, create table, execute procedure, execute function, insert, update, delete, select on <DATABASE_1> to <DATABASE_2.;

      Example: grant create procedure, alter procedure, create function, ALTER function, create table, execute procedure, execute function, insert, update, delete, select on Ebay to DG_ebay;

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.