Patterns: Information Aggregation and Data Integration with DB2 Information Integrator

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

Figure B-58 DB2 UDB for Multiplatforms - Create User Mapping settings

Choose db2loan for the REMOTE_AUTHID field, set the appropriate value for

REMOTE_PASSWORD, and let ACCOUNTING_STRING default as shown in

Figure B-58 to connect to the DB2 UDB for Multiplatforms data source to

complete the user mapping.

User mappings may be modified after creation time.

Example B-16 shows the command line version of creating the user mapping for

our DB2 UDB for Multiplatforms instance.

Example: B-16 DB2 UDB for Multiplatforms - Create user mapping statements

CONNECT TO PATTERN;

CREATE USER MAPPING FOR "NALUR1" SERVER "LOANS" OPTIONS ( ADD REMOTE_AUTHID

'db2loan', ADD REMOTE_PASSWORD '*****') ;

Create the DB2 UDB for Multiplatforms nickname

Once the DB2 wrapper, server definition, and user mapping is complete, you

needs to test the connection to the data source.

After successfully testing the connection to the data source (not shown here), we

can create the actual link to a table located on our remote database as a

nickname.

Appendix B. Configuring data sources in DB2 Information Integrator 225

You may choose to define data mappings and/or function mappings during the

creation of a nickname. Data mappings are described in “Data type mappings”

on page 43, while function mappings are described in “Function mappings” on

page 44.

When you create a nickname for a DB2 UDB for Multiplatforms table, catalog

data from the remote server is retrieved and stored in the federated global

catalog.

Select and expand LOANS, right-click Nicknames, and click Create, similar to

the actions taken for CHKSVG from Figure B-9 on page 178.

This action opens up the dialog window shown in Figure B-59, which shows two

options (Add and Discover) for adding a nickname.

Figure B-59 DB2 UDB for Multiplatforms - Nickname creation

Click Add to open up a dialog window, as shown in Figure B-60 on page 226, to

create a nickname.

Note: We did not define any data mappings or function mappings for our

nicknames.

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

Figure B-60 DB2 UDB for Multiplatforms - Add Nickname

Fill in the details as shown, and click OK to open up a dialog window, as shown

in Figure B-60.

Figure B-61 DB2 UDB for Multiplatforms - Create Nicknames

Select the L_BORROWER nickname and click OK to create the nickname with

the defaults. Clicking Show SQL displays the SQL used to create the nickname,

as shown in Figure B-62 on page 227.