Use IBM WebSphere AuditStage in a federated database environment

Level: Introductory

Harald Smith (smithha@us.ibm.com), Product Manager, IBM
Ian Schmidt (ischmidt@us.ibm.com), Product Manager, IBM

05 Jul 2007

	Register now or sign in using your IBM ID and password.

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

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.

Share this.... Digg this story del.icio.us Slashdot it!

Back to top