Patterns: Information Aggregation and Data Integration with DB2 Information Integrator

Appendix B. Configuring data sources in DB2 Information Integrator 183

Create the XML wrapper

The XML wrapper can be used in the following cases:

򐂰 The user wants to join XML data with other nicknames or other relational

data.

򐂰 The user wants to keep the original XML intact (to avoid replicating data or

data that may change often or is composed on the fly).

The XML document used in a nickname may come from any of the following

sources:

򐂰 A text file, for example, c:\myfiles\mydata.xml

򐂰 A directory of text files, for example, c:\myfiles

򐂰 An XML document stored in a column of a table in a database

򐂰 From a URI, for example, http://www.mysite.com/mydata.xml

The XML wrapper supports the following data types: INTEGER, SMALLINT,

FLOAT, REAL, DECIMAL, CHAR, VARCHAR, and DATE.

Ensure that the following prerequisites are in place before deciding to use the

XML wrapper:

򐂰 Flat files (table structured files), XML, and Microsoft Excel files

must be

located on a local or network mapped drive of the Windows server where DB2

II is installed.

򐂰 Since it is DB2 that needs to access the files on the local or network drive,

you need to ensure that the

userid under which DB2 is running (default is

db2admin) is authorized to the domain containing the network drives. In our

case, the userid is ‘NALUR1’.

To determine the userid of DB2, navigate to the Services screen as follows:

Start → Settings → Control Panel → Administrative Tools → Services.

This displays Figure B-15 on page 184. The Log On As field identifies the

DB2 userid (db2admin in Figure B-15 on page 184).

Note: The XML wrapper does not support the INSERT, UPDATE, and

DELETE functions.

184 Patterns: Information Aggregation and Data Integration with DB2 Information Integrator

Figure B-15 Determining userid of DB2 II

Navigate to the PATTERN federated database that was created during the DB2

II install, right-click Federated Database Objects, and click Create Wrapper, as

shown in Figure B-1 on page 168, to display Figure B-16.

Figure B-16 XML - Create Wrapper