Pervasive allows us to take some of the 'world's ugliest data' and turn it into structured data that can be used in downstream processes. In New Jersey, we've taken legacy data, Excel files, and third-party data and made it useful. New Jersey is now on the leading edge in terms of first aid tracking and analysis."

Dave Herman
President & CEO
PeopleForce

Mike Hoskins on Pervasive Data Profiler

Get valuable metrics on any dataset, all rows, all columns at screaming fast speeds.



Data Quality

Pervasive Data Profiler™ Helps Cleanse Your Dirty Data

Bad data will cost you business, and maybe your reputation. Pervasive Data Profiler™ improves IT productivity, avoids costly rework and speeds ROI with the fastest profiling engine on the market. Forget time-consuming, error-prone manual checking for transactional data assurance.

There's a lot riding on your data. Make sure it's accurate.

Pervasive Data Profiler enables you to quickly and easily:

  • Isolate irregularities
  • Quantify business rules violations
  • Identify null sets or values
  • Ensure data compliance with 100% testing of data, not just sampling

Product Features

  • Lightning fast parallel execution with automatic scaling across multiple CPUs
  • Actionable, at-a-glance charts backed by detailed drill-down analysis
  • Detailed views of Pass and Fail for files and equal range binning
  • Reports that can be easily interfaced with other applications via XML
  • Simple 3-step process
  • In-place source data browsing
  • Ability to copy, paste metrics from one field to another field

Easily Find Dirty Data

Save money on integration projects, get accurate time estimates, and improve productivity for data analysts.

  • Reduce costly rework
  • Improve efficiency in issue detection
  • Eliminate SQL queries and manual inspection processes
  • Extend the reach of data quality projects with extensive connectivity
  • Reduce training costs and learning curves with easy-to-use graphical user interface

Universal CONNECT! Platform Included

Pervasive Data Profiler has the entire Pervasive Data Integrator library of connectors, and can use the same schemas, providing the same unrivaled connectivity to nearly everything.

  • Flexible connectivity to almost any data source
  • NO Per Connector Fees!
  • Joins between different heterogeneous sources
  • Integration support for legacy and new systems
  • Connectivity to semi-structured exchange formats
  • Unstructured data
  • Connectivity to SaaS and on-premise sources even across firewalls
  • Fully extensible connectivity

Improve Automation or Data Steward Efficiency

  • Statistical results file
  • XML format — can export using XSLT and other templates
  • Percentage of success rate as well as counts
  • Detailed drilldown views as well as graphs
  • Optional 'clean' (rows passed) and 'dirty' (rows failed) files

World-Record Performance Automation

Pervasive Data Profiler combines the flexibility and power of user-defined metrics, with the convenience of one-step automatic generation of some standard metrics. Pervasive DataRush underneath means you can do multiple metrics on multiple columns simultaneously!

  • Compliance Testing – Blank, Null, Compare to Constant, Compare to Field, ...
  • Conversion Testing – Converts to Double, Converts to Date, ...
  • Statistics Collection – Avg, Min, Max, Sum, Unique Value, Ranges, ...

For more information, see the Data Profiling & Remediation scenario