Distributed Exporter Utility

The Distributed Exporter utility that creates and provides necessary information to the Extension Technology that enables the generation of a distributed data store.

This utility generates the following files after you have successfully exported from the Data Generation module:

method.rc

Coded content of source and target databases information.

method.txt

Information for the environment and the method in it which are about to be masked.

filter.txt

All created filters in the test environment.

elab.txt

Information about tables involved in Data Generation process.

Dir.txt

Information about the directives to be used

cbfld.txt

Information about combined fields used in the method.

CREATETABLE.sql

A list of the tables that need to be masked; a generic CREATE TABLE statement is provided for each table.

CREATEINDEX.sql

A 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

A 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.

There are two areas of interest when it comes to using the Distributed Exporter with distributed data stores.

• If you use ODBC-enabled data stores, you can subset across all your data stores with one invocation of the ODBC Extension. This feature is not available with the Oracle Extension.

• You also have the ability to subset within one distributed data store, as long as a distinct target schema name is provided.

If you use the Distributed Exporter utility on one machine, and do your generation on another, make sure that the target ODBC DSN matches the ODBC DSN used for the actual data generation.