pfDataViewer with Data Masking
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 random data generator interface for masking output data with randomized values.
Key Features
- 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.
- Microsoft databases:
- 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 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/province, metropolitan area.
- Supports restricting names to following countries:
United States, Canada, Mexico.
- Supports restricting names to following countries:
- 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.
- Randomize selected fields.
- 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 definitions can be easily printed out for documentation purposes from the user interface.
Screen Shots
- Main Form
- Query Builder Tool
- Exporting Results to Text File
- Exporting Results to SQL Database
- Randomizing Results Data
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
-
pfDataViewer 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. 195 MB.
-
-
pfDataViewer Help File Download (.CHM File Format)
-
Download size = approx. 4 MB.
-
Pricing
- pfDataViewer is freeware.
How to Purchase
- No purchase needed for this product.
pfDataViewer on the Web
Softpedia CNET Tucows Freeware Files Soft32 DownloadPipe UpdateStar