34 Patterns: Information Aggregation and Data Integration with DB2 Information Integrator
Table 2-4 Excel write operations limitations
The power of DB2 II is in its ability to:
Join data from local tables and remote data sources, as if all the data is
stored locally in the federated database.
Update data in relational data sources, as if the data is stored in the federated
Replicate data to and from relational data sources.
Take advantage of the data source processing strengths, by sending
distributed requests to the data sources for processing.
Compensate for SQL limitations at the data source by processing parts of a
distributed request at the federated server.
2.4.2 DB2 II components
DB2 II contains the following components, as shown in Figure 2-6 on page 38:
DB2 UDB Enterprise Server Edition (ESE) for Linux, UNIX and Windows.
relational wrappers are used for non-IBM relational databases. In DB2
UDB Enterprise Server Edition (ESE) V8 for Linux, UNIX, and Windows,
relational wrappers are required if you want to access data that is stored in
Oracle, Sybase, Microsoft SQL Server, ODBC, and Teradata data sources.
Type Read Insert Update Delete
Ye s N o N o N o
Note: A wrapper development kit is included in DB2 II that allows you to
develop your own wrapper modules for non-relational data sources. The
wrapper module is a shared library with specific entry points that provide
access to a class of data sources. DB2 UDB loads it dynamically. The wrapper
module is what you will be developing using the specific classes supplied with
DB2—it will contain specific building blocks that allow it to act as a translator
between your data source and the federated system.