IBM WebSphere Information Integration

From Wikipedia, the free encyclopedia

WebSphere Information Integration is a suite of business software for data management tasks such as retrieving, profiling, cleansing, transformation and metadata management. The suite of tools has evolved over the last few years and was formerly known as DB2 Information Integrator. In 2005, IBM acquired the Ascential Software Corporation to expand the IBM Information Integration capabilities. The name of the suite has recently changed to IBM Information Integration Solutions.

In November of 2006, IBM announced that the new version of this suite would make up the IBM Information Server. The IBM Information Server is actually a combination of many of the products below.

This solution is an attempt to define a new type of strategic corporate asset, a data integration platform for Extract-Transform-Load (ETL), cleansing, profiling, federation and replication. The initial release features integration of the Information Integration products on a common metadata server. Subsequent releases will see support for the IBM Master Data Management platform and Rational tools. The products below enable information integration as part of IBM Information Server, but many are also stand-alone products.

[edit] Information Integration Suite

This product is now IBM Information Server. Version 7 of the suite is comprised of the following product:

  • DataStage is an Extract, Transform and Load tool.
  • QualityStage is a data quality cleansing tool.
  • ProfileStage is a data profiling tool.
  • MetaStage is a metadata hub tool.
  • DataStage TX is a tool for transforming complex transactions.
  • The DB2 Information Integrator was renamed WebSphere Data Integrator for this release.

[edit] Information Server

With the version 8 release IBM introduce the Information Server with a new look information integration suite of tools:

  • WebSphere DataStage for Extract, Transform and Load.
  • WebSphere QualityStage for data quality is moved onto the DataStage Designer.
  • WebSphere Metadata Server is a shared repository and metadata services layer for all Information Server products.
  • WebSphere Data Analyzer is a new profiling and monitoring product that replaces ProfileStage.
  • WebSphere Business Glossary replaces the glossary functions of the defunct MetaStage product.
  • WebSphere DataStage TX is a tool for transforming complex transactions.
  • WebSphere Federation Server is the data access product formerly known as WebSphere Information Integrator. This product allows access to many other data sources through a single DB2 installation.
  • WebSphere Replication Server is data replication tool for SQL-based replication and Queue-based (Q) replication.
  • WebSphere Data Event Publisher is a changed data capture tool that can publish changed data to data warehouses, web applications, or other business applications.

[edit] External links