Data Subset Extraction

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

To export a method from Data Subset Extraction, you need to provide the following input:

• Your workspace (machine ID, company)
• Your method (group, method)
• 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 schema, 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 Subset Extraction, the following files are created in your output directory:

• method.rc - Encoded connection criteria for each data store referenced.
• method.txt - Information identifying the method.
• filter.txt - Information about the filters used in the method.
• elab.txt - Information about the elaborations in the method.
• cbfld.txt - Information about combined data elements used in the method.
• 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.