Welcome

Congratulations on selecting pfDataViewer by ProFast Computing. This application provides easy to use interactive interface for creating and running data queries against a wide variety of database platforms.

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

 

  • Supports a wide range of 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.
  • Easy to use data export to the following external data formats:
    • Excel File (.XLSX and XLS formats).
    • Text File (Delimited and Fixed Width).
    • Access File (.ACCDB and .MDB formats).
    • Relational Database Table 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 (XSD schema included in output).  
      • Using .NET DataTable WriteXml capabilities.
    • Word File (.DOCX, .DOC, .RTF formats)
    • PDF File.
  • 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.
  • Query definitions can be saved for later reuse.
  • 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.