Data Masking

To access the Distributed Exporter, click from the main window of Data Masking.

To export from Data Masking, you need to provide the following input:

• Your workspace (machine ID, company)
• Your source data store credentials (source database, source schema, source user ID/password)
  Note: The source database is an ODBC DSN configured to access that data store.
• Your target data store credentials (target database, target scheme, target user ID/password)
  Note: The target database is an ODBC DSN configured to access that data store. The Extension technology does not support case sensitive object names.
• Directory where you want to place output files for Extension Technology (Output directory)

In addition, if you are using ODBC-enabled data stores, you can provide multiple sets of source and target data store credentials.

After you have successfully exported from Data masking, the following files are created in your output directory:

• method.rc - Encoded connection criteria for each data store referenced.
• elab.txt - List of data stores and the enabled columns within those data stores that need to be masked.
• CREATETABLE.sql - list of the tables that need to be masked; a generic CREATE TABLE statement is provided for each table.
• CREATEINDEX.sql - list of all the indexes for the tables that need to be masked; a generic CREATE INDEX statement is provided for each index.
• ALTERTABLE_RI.sql - list of all the primary and foreign keys for the tables that need to be masked; a generic ALTER TABLE statement is provided for appropriate primary and foreign keys.