Features and benefits
IBM InfoSphere Information Analyzer provides these unique capabilities:
Complete Source System Profiling and Analysis via a revolutionary user interface enables users to easily understand data, find anomalies, validate data values, validate column/table relationships and drill down to exception rows for further analysis. Data profiling functions include column, primary key, foreign key, cross-table and baseline analysis.
Improve time to value of data integration projects - leveraging the Information Server architecture, analysts can easily initiate processing for one process while continuing to analyze other data, and then deliver the resulting information to others. Core profiling utilizes the strength of the underlying parallel engine to stream data and process multiple requests without requiring technical expertise.
Ensure data projects contain trusted information and lower the risk of propagating bad data - Uncover data quality issues and anomalies early in a data integration project and improve success rates.
Comprehensive, Easy-to-use Reports are configurable and the visual representation of analysis/trends/metrics and incorporation of user generated notes help you understand results quickly and efficiently.
Rules Analysis - adds another dimension to data profiling by creating and executing data rules to perform trending, pattern analysis and establish baselines.
Scheduling analysis activities - Information Analyzer utilizes the Information Server scheduling service, allowing both adhoc and scheduled execution of profiling, rules, and metrics, as well as scheduling via external CLI calls (e.g. by DataStage, Tivoli, script, etc)
User Annotations support comprehensive descriptive information enabling users to add their own business names, descriptions, business terms and other attributes to tables and columns.
Common Metadata across all IBM InfoSphere Information Server and IBM InfoSphere Information Server for System z product modules enables the sharing of profiling results/information with other data integration processes. For example, a IBM InfoSphere DataStage designer would immediately be able to see that a column has been profiled and anything noted by the profiler (ie. column ABC needs to be cleansed before the ETL process).
The Security Framework in IBM InfoSphere Information Analyzer utilizes project-, role- and user-based approaches to control and limit access to sensitive analytical information.Scalability through native parallel execution enables high performance profiling against massive volumes of data.
Flexibility through IBM InfoSphere Information Analyzer for Linux on System z to perform these functions directly on the mainframe so that you can:
- Leverage existing mainframe resources to maximize the value of your IT investments
- Take advantage of the scalability, security, manageability and reliability of the mainframe
- Add mainframe information integration work load without added z/OS operational costs
