 | Level: Introductory Harald Smith (smithha@us.ibm.com), Product Manager,
IBM
Ian Schmidt (ischmidt@us.ibm.com), Product Manager,
IBM
05 Jul 2007 IBM® WebSphere® Information Analyzer includes the IBM WebSphere AuditStage product, providing users with the capability to create, deploy, and monitor data validation rules over time. The reach of WebSphere AuditStage can be extended by leveraging the IBM WebSphere Federation Server. In this tutorial, you'll learn how to configure a federated database environment for effective use with WebSphere AuditStage in managing data quality. In this tutorial
- Review key concepts of the WebSphere Federation Server
- Steps to set up WebSphere Federation Server: creating the wrapper, the server, user mappings, and nicknames
- Steps to set up WebSphere AuditStage
Objectives - Learn about the architectural framework for using WebSphere AuditStage with WebSphere Federation Server.
- Learn how WebSphere AuditStage processing works with a federated view.
- Integrate your results with WebSphere Information Analyzer.
Prerequisites
This tutorial is written for Linux® or UNIX® programmers whose skills and
experience are at a beginner to intermediate level. You should have a general
familiarity with using a UNIX command-line shell, and a working knowledge of the
C language.
System requirements
This tutorial assumes that you already have WebSphere AuditStage and WebSphere Federation Server installed.
Duration
1 hour
Formats html, pdf
Tutorial overview
IBM WebSphere AuditStage evaluates data quality under a comprehensive, systematic methodology. It allows you to audit, monitor, and report on a wide range of data defects using defined data filters or rules. WebSphere Federation Server allows you to reach out, through the federated view, to multiple external data sources (such as DB2®, Oracle, SQL Server, and text files). Using these two products together, you can execute data quality rules across multiple data sources as though they were part of a single database.
This tutorial describes the process needed to lay out and architect the federated environment, to configure both WebSphere Federation Server and WebSphere AuditStage to work together, to build and establish example rules in WebSphere AuditStage that leverage the environment, and to integrate the results from WebSphere AuditStage with the profiling and analysis in WebSphere Information Analyzer.
| | | |
