Table of Contents

Search

  1. Preface
  2. Introduction to TDM Administration
  3. User and Role Administration
  4. Security Administration
  5. System Preferences
  6. TDM Server Administration
  7. Connections
  8. Pass Phrases
  9. Global Parameters
  10. Dictionaries
  11. User-Defined Datatypes

Administrator Guide

Administrator Guide

Storage Tables for Repeatable Masking

Storage Tables for Repeatable Masking

To perform expression masking or substitution masking with repeatable values, you must assign a storage table for the repeatable values. You can create the table in the TDM repository database or in another database. TDM creates a default storage connection and creates storage tables for this connection.
If you choose to use a different storage connection, you must set this connection as the default connection and create the storage tables for the connection. Set the connection as the default storage and staging connections and create storage tables in Test Data Manager.
Staging connections and storage connections can be on Oracle, Sybase, IBM DB2, or Microsoft SQL Server databases. You can create a staging connection on Teradata and Teradata Parallel Transporter connections.
To use a Teradata or a Teradata Parallel Transporter connection as a staging connection, the Teradata JDBC JAR files
tdgssconfig.jar
and
terajdbc4.jar
must be present in the following location:
<Informatica installation directory>\TDM\utilities\mapgen\thirdpartylib
. Create a
thirdpartylib
folder and copy the JAR files before you configure the connection as a staging connection.
You can create the storage tables for the required staging and storage connection from the
Administrator
view in Test Data Manager.
You can also use the SQL scripts that Informatica provides to create the storage tables. Use your database client tool to run the SQL script and create the table in the database. For example, you can use the SQL*Plus client for Oracle to create the storage table in an Oracle database.
Run the storage table SQL script for your database. For example, to create the substitution storage table in a Microsoft SQL Server database, run the
Substitution_SQL_Server.sql
file. The SQL scripts to create the storage table for repeatable expression masking are installed in the following TDM directory:
<TDM Installation Directory>/TDM/storage_script/expression_storage
After you run the expression storage script, verify that the script created the IDM_EXPRESSION_STORAGE table in the database. The SQL scripts to create the storage table for repeatable substitution masking are installed in the following TDM directory:
<TDM Installation Directory>/TDM/storage_script/substitution_storage
After you run the substitution storage script, verify that the script created the IDM_SUBSTITUTION_STORAGE table in the database.
The expression and substitution storage tables can contain original values from the source database and the corresponding masked values from the target database. Ensure that access to the storage table is secure. Alternatively, you can create the expression or substitution storage table in a database with limited user access.

0 COMMENTS

We’d like to hear from you!