The WebSphere® Information
Analyzer user interface presents an intuitive set of controls that are designed
for integration development workflow.
The WebSphere Information
Analyzer user interface aids you in organizing data analysis work into projects.
The top-level view is called a Dashboard because it reports a summary of your
key project and data metrics, both in a graphical format and in a status grid
format.
The high-level status view in Figure 1 summarizes
the data sources, including their tables and columns, that were analyzed and
reviewed so that managers and analysts can quickly determine the status of
work. The project view of the GlobalCo project shows a high-level summary
of column analysis, an aggregated summary of anomalies found, and the Getting
Started pane.
Figure 1. WebSphere Information Analyzer project
view
While many data analysis tools are designed to run in a strict sequence
and generate one-time static views of the data, WebSphere Information Analyzer enables
you to perform select integration tasks as required or combine them into a
larger integration flow. These tasks fall into three categories:
- Profiling and analysis
- Provides complete analysis of source systems and target systems, and assesses
the structure, content, and quality of data, whether at the column level,
the cross-column level, the table or file level, the cross-table level, or
the cross-source level. This task reports on various aspects of data including
classification, attributes, formatting, frequency values, distributions, completeness,
and validity.
- Data monitoring and trending
- Helps you assess data completeness and validity, data formats, and valid-value
combinations. This task also evaluates new results against established benchmarks.
By using the WebSphere AuditStage
component, business users develop additional data rules to assess and measure
content and quality over time. Rules can be simple column measures that incorporate
knowledge from data profiling or complex conditions that test multiple fields.
Validation rules assist in creating business metrics that you can run and
track over time.
- Facilitating integration
- Provides shared analytical information, validation and mapping table generation,
and testing of data transformations by using cross-comparison of domains before
and after processing.