Skip to main content

PartnerWorld > Products > Systems, servers, and storage > Technical >

Heterogenous data access for IBM i applications

by Kent Milligan and Colin Hendricks

Last updated: 2008-02-06

PDF iconDownload the white paper (2200 KB)
Links to external URLGet Adobe® Reader®

 
Rate this article
  Feedback

© Copyright IBM Corporation, 2008. All Rights Reserved.
All trademarks or registered trademarks mentioned herein are the property of their respective holders.

Abstract
Many IBM clients have business data scattered across disparate data sources. Applications need to be able to access and consolidate the data in different databases. This white paper makes you aware of the options available for IBM i5/OS applications to access heterogeneous data. It features IBM WebSphere Federation Server, which helps solve the heterogeneous data-access problem for i5/OS applications by providing a seamless SQL interface for accessing data that is not stored in an IBM DB2 table.
Introduction
What are the chances that all of the data that your company needs for its day-to-day operations is stored on the IBM® System i™ platform in its IBM DB2® for i5/OS® database? In today’s IT world, the answer to this question is most likely slim or none. Disparate data sources appear in many situations. For example, another organization in your company might have hired some PC programmers to create a departmental solution and a couple of your existing System i applications now need to access the data that resides in the database on the PC server. Or your company might have merged with another business that does not use i5/OS systems, yet you need to share data.

Obviously, it is important to know the available methods for i5/OS programs to access data that is not stored in DB2 (such as Oracle and SQL Server). This paper makes you aware of the options for i5/OS applications to access heterogeneous data.