Easy to use, versatile Pervasive Data Profiler offers powerful features that can benefit your organization by helping you take costs out of integration.
Features
Actionable Reporting
- Statistical results file
- XML format — can export using XSLT and other templates
- Percentage of success rate as well as counts
- Drill down of detail view and graphs
- Optional ‘Clean’ (rows passed) and ‘Dirty’ (rows failed) files
- Use files for further downstream ETL processing
Metrics: 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
- User-defined metrics
Easy To Use User Interface
- Simple 3-step process
- In place source data browsing
- Copy and paste metrics for a given field to another field
Source
- Connectivity to multiple sources
- Join Designer used for heterogonous joins
- Ability to parse data or import schemas for profiling non-structured data
- Profile entire file or sample set
Profiling Engine
- Parallel execution of profile designs
- Scales per CPU for Unique Values and complex processing
Benefits:
Takes Costs Out of Integration
- Upfront analysis reduces costly rework
- Improved efficiency in issue detection
Delivers a Fast Return on Investment
- Results in minutes or hours, not days
- Accelerated speed to value with better data and application performance
Improves Productivity for Data Analysis
- Includes native connectivity for over 150 data source types
- Quickly produces output results
- Eliminates SQL queries and manual inspection processes
Reduces Training Costs and Learning Curves
- Easy-to-use Graphical User Interface (GUI)
- Easy 3-step process ensures fast implementation
Works with Pervasive and other vendors’ integration products
- Perfect fit for ETL and other data integration products
