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

Pervasive Data Profiler delivers:

• Parallel execution with automatic scaling across multiple CPUs making it lightning fast (based on cutting-edge Pervasive DataRush™ technology)
• Actionable, at-a-glance charts backed by drill-down analysis with percentages of success rate and specific counts
• Detailed views of Pass and Fail for files and equal range binning
• Statistical metrics such as mode, median, standard deviation and variance presented in a report that can be easily manipulated by other applications via XML

Pervasive Data Profiler™ was selected as Product of the Year for Data Quality in SearchDataManagement.com’s 2008 Product of the Year program.

See also Data Quality Assessment and Governance.

Benefits of using Pervasive Data Profiler for high-speed data assessment:

• Takes costs out of integration with up-front analysis that reduces costly rework and improves efficiency in issue detection
• Improves productivity for data analysis by eliminating SQL queries and manual inspection processes
• Extends the reach of data quality projects with extensive out-of-the-box connectivity to thousands of different applications and data sources including unstructured, legacy and complex industry standard types
• Reduces training costs and learning curves with an easy-to-use graphical user interface (GUI) and an easy 3-step process that ensures fast implementation
• Works with Pervasive and other vendors’ integration products making it a perfect fit for ETL and other data integration projects

See More Presentations and Demos >

Actionable Reporting

• Statistical results file
• XML format — can export using XSLT and other templates
• Percentage of success rate as well as counts
• Drilldown of detail view and graphs
• Optional "clean" (rows passed) and "dirty" (rows failed) files
• Use files for further downstream ETL processing

See More Presentations and Demos >

Speed Through Efficient Design and High Performance

Delivers a fast ROI and accelerated speed-to-value with better data and application performance that provides results in minutes or hours, not days .  The easy-to-use graphical interface means:

• Simple 3-step process
• In-place source data browsing
• Ability to copy and paste field metrics for a given field to another field

Data Profiler is built on the Pervasive DataRush™ technology that allows fast analysis of every field and every record by automatically taking advantage of modern multi-CPU hardware. This allows parallel execution of profile designs and automatic near-linear scaling per CPU for unique values and complex processing.

See More Interviews and FAQ Answers >

Comprehensive Source Connectivity

Pervasive Data Profiler has unparalleled out-of-the-box connectivity to thousands of different applications and data sources, since it includes all of the data connectors available in Data Integrator. It also connects to the Join Designer to enable heterogeneous joins of files, databases or other disparate sources. In addition, it can parse data or import schemas created in the various Data Integrator schema designers for profiling nonstructured, flat, binary or industry-standard data.

Read More Case Studies >

Business Rules and Analysis

• Standard set of metrics
• Compliance Testing – Blank, Null, Compare to Constant, Compare to Field
• Conversion Testing – Converts to Double, Converts to Date, etc.
• Statistics Collection – Avg, Min, Max, Sum, Unique Value, Ranges
• AutoGen feature for one-step automatic generation of some standard metrics
• Flexibility and power of user-defined metrics
• Metrics on multiple columns simultaneously

See More Interviews and FAQ Answers >

Data Profiler for the Cloud

Pervasive Data Profiler™ for the Cloud enables you to quickly and easily accomplish all the same metrics calculations, and automated profiling tasks that it does on-premises.  It's 100 times cheaper to filter problem data out before it gets into your system than to fix it when it impacts a customer. Data Profiler's real-time data validation capabilities ensure that bad data won't get in to throw a wrench in your hosted integration process.  Pervasive Data Profiler works with both Pervasive and other vendors' integration products to deliver fast ROI for hosted integrations and data services.

See also Cloud Integration and Cloud Integration Products.