Welcome

Congratulations on selecting pfDataExtractor by ProFast Computing. This application provides an interactive user interface for creating and running data extracts and exports that can be based on a wide variety of database platforms.

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

  • Easy to use data export & extract capabilities.
  • Easy to define query restrictions and result set filters.
  • Built-in Data Preview capabilities for verifying extract definitions.
  • Ideal for creating random data for test, training and development database tables.
    • Randomize selected fields with realistic looking data.
      • 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 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 definition files 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.
  • 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.
      • Oracle, MySQL, DB2, Informix.
      • Sybase, SQLAnywhere, SQLAnywhere UltraLite
    • 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.