pfDataExtractor

Provides intuitive interface for data extraction and data masking. Ideal for masking data with realistic random values for test, training and development database tables. Easy to use visual interfaces allow you to define data masks for random names, locations, numbers, strings, and dates. You can easily define query restrictions via a visual query builder interface. You can also define and apply filters on your results using a visual filter builder. Application has built-in Data Preview capabilities for verifying extract definitions.
Data sources include relational databases, MS Access files, SQLCE databases, Excel workbooks, Text files and XML files. Application allows you to export your data to a wide variety of output formats: Server and desktop relational databases, MS SQL Server CE, MS Access, Text files, Excel files and XML formatted files. Building connection strings for your data sources and data destinations is simplified via custom visual connection string builders for all the supported databases and file types.
The application also provides tools for generating realistic random test data tables based on your production data table schemas. You can define the test data tables to contain a user-defined number of random data rows.