Database Reference
In-Depth Information
CHAPTER 6
DB2 Source Patterns
In a previous chapter you learned about patterns related to SQL Server sources. In this
chapter, we will move on to patterns that relate to sourcing data from the IBM DB2
database. DB2 describes a variety of databases, so it is essential to learn about the differ-
ent databases we will discuss, as well as how to use each database as an Integration Ser-
vices source.
As we described in
Chapter 4
, setting up a source entails four different objects:
Connection Manager
,
Provider
,
Source Component
, and a
Source
Component Query
. While this remains true for the DB2 database, you need to take
the additional first step of determining what type of database you own. DB2 has a num-
ber of types, providers, and ways to query data. As we look at the different patterns as-
sociated with each of these components, picture how they will work with other sources
as well. Combining these steps will put you on the right path to pulling data from your
DB2 database.
This chapter highlights patterns that you may find useful while connecting to a DB2
database, but it does not cover every possible scenario that you may run into in your en-
vironment.
DB2 Database Family
There are several different types of DB2 databases available on the market today. How
you connect to the database depends on the DB2 version. DB2 separates its products in-
to three groups:
Search WWH ::
Custom Search