Skip to main content


developerWorks  >  Architecture | Rational | Information Management  >

Rational Data Architect skills series, Part 1: Access and integrate enterprise metadata with Rational Data Architect

Creating a unified view across heterogeneous data sources

developerWorks

Level: Intermediate

Farnaz Erfan (erfan@us.ibm.com), Staff Software Engineer, IBM
Mary Roth (torkroth@us.ibm.com), Solutions Architect, IBM

25 Jul 2006

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

Data integration in an enterprise of data sources is one of the most common requirements of any database shop. Users need on demand integrated access to a variety of diverse data sources, such as traditional data assets like Excel spreadsheets and legacy data, to new and emerging technologies such as XML data stores. IBM® WebSphere® Information Integrator provides a single interface that allows end users and database administrators to virtually and transparently access a wide variety of these data sources. IBM Rational® Data Architect (Data Architect) works with WebSphere Information Integrator to give data architects and application developers the ability to discover, model, visualize, relate, and develop data assets across distributed and diverse data sources. In this tutorial, you follow a simple scenario to learn how Rational Data Architect can be used to provide a modeling and design tool to create a unified, virtual view across heterogeneous data sources.

Objectives

After taking this tutorial, you'll understand how Rational Data Architect capabilities can enhance the federation capabilities of WebSphere Information Integrator. You get step-by-step instructions that give you hands-on experience using this modeling tool.

Prerequisites

The scenario in this tutorial uses IBM DB2 and Oracle relational database management systems. You should have general familiarity with relational databases and data modeling concepts.


System requirements

Download the sample code files, included within the tutorial.



Duration

1 to 2 hours





Formats

html, pdf


Share this....

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


Back to top


Document options

Document options requiring JavaScript are not displayed

Discuss


More in this series:
Rational Data Architect skills series