pfDataExtractor

pfDataExtractor with Data Masking

This application provides an interactive user interface for creating and running data extracts that can be based on a wide variety of data platforms.

The application also provides an intuitive random data generator interface for masking output data with realistic looking randomized values.

Key Features

Easy to use data export & extract capabilities.
Easy to define query restrictions and resultset filters.
Built-in Data Preview capabilities for verifying extract definitions.
Ideal for masking data with realistic random values for test, training and development database tables.
- Randomize selected fields.
  - Random person names or business names or a combination of both.
  - Random city names, state/province names, street names, zip/postal codes.
  - Random numeric values plus options for sequences, offsets or ranges of numbers.
  - Random words, strings, syllables, date/times, telephone numbers, national ids.
- Restrict name and address random values by country, region, state, city, metropolitan area.
  - Supports restricting names to following countries:
    United States, Canada, Mexico.
- Generate test tables with realistic random data from database table schemas.
- Generate test order transaction and data warehouse order tables based on user specified date ranges and row counts.
  - New tables are created filled with realistic random data.
Interactive interface for creating, previewing and saving random data definitions.
Ships with interactive user tool that simplifies process of defining, verifying and saving database connection strings.
All definition files are stored in XML format for easy troubleshooting.
All definitions can be easily printed out for documentation purposes from the user interface.
Application supports following data platforms as data sources:
- Microsoft databases:
  - SQL Server, MS Access, SQLCE 3.5 & 4.0.
  - via .NET Providers.
- ODBC Drivers:
  - via .NET System.Data.Odbc.
- OLEDB Providers:
  - via .NET System.Data.OleDb.
- .NET Providers:
  - Oracle, MySQL, DB2, Informix, Sybase, SQLAnywhere, SQLAnywhere UltraLite.
- XML Formatted Files (with or without XSD included in input).
  - Using .NET DataSet ReadXml capabilities.
- Excel Data Files (.XLSX and XLS formats).
- Text Data Files (Delimited and Fixed Width).
Application supports following external data formats for export destinations:
- Excel File (.XLSX and XLS formats).
- Text File (Delimited and Fixed Width).
- Access File (.ACCDB and .MDB formats).
- Relational Database via .NET providers.
  - Microsoft SQL Server
  - SQL Server Compact Edition 3.5 & 4.0.
- Relational Databases using ODBC drivers.
  - via .NET System.Data.Odbc.
- External Data Stores using OLEDB providers.
  - via .NET System.Data.OleDb.
- XML File (with or without XSD included in output).
  - Using .NET DataTable Writexml capabilities.

Screen Shots

Supported Operating Systems

Windows XP SP3 or later, Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Requirements

.NET Framework 4.0 (Full)
SQL Server CE 3.5 SP2
Microsoft Access Database Engine (ACE OLEDB 12.0)
Microsoft Data Access Components (MDAC) 2.8
Jet 4.0 SP3 for XP

*NOTE: You will be prompted to install any missing software at install time. This application’s installation will either download from the web or use its own included files to install any missing software.

Download

pfDataExtractor Setup Program (Zip File Format)
- Above installation package will install, if necessary, the .NET 4 Full runtime via a web installation package.
- Download size = approx. 200 MB.
pfDataExtractor Help File Download (.CHM File Format)
- Download size = approx. 7 MB.
pfDataExtractor Online Help

Pricing

pfDataExtractor is freeware.

How to Purchase

No purchase needed for this product.

pfDataExtractor on the Web

Softpedia CNET Tucows Freeware Files Soft32 DownloadPipe UpdateStar

ProFast Computing

Software Development and Consulting Services