Chapter 7. Defining virtual data sources to reduce complexity for business users 143
7.3 Creating a virtual data source that federates data from
multiple sources
Enterprise data stores typically evolve over time. New systems are added alongside existing
infrastructure to meet demand for new capabilities or to accommodate merges or corporate
restructures. Inevitably, this results in data scattered across a number of distinct databases.
For example, Spiffy Insurance stores its business and customer data primarily in DB2 for
z/OS. This data includes sales by insurance product, region, date, and customer. However, as
the result of an acquisition, Spiffy inherited a product administration system that is built within
an Oracle database. Recognizing ...