For this procedure, in Management Agent Designer, on the
Connect to Database page, you connect to an IBM DB2
Universal Database and provide information about the database to be
synchronized. You must also provide a user account and password to
log on to the IBM DB2 Universal Database. The user account that you
specify must have at least Read rights for the database. Each time
that the management agent is run, it uses this information to log
on to the IBM DB2 Universal Database to read or write to the table
or view that you specify. To complete this procedure, you must be logged on as a member of the MIISAdmins security group.
This procedure applies to management agents for the following
Microsoft Identity Integration Server 2003 with Service Pack 1
(SP1) editions:
Enterprise Edition
Identity Integration Feature Pack for Active Directory
IBM DB2 Universal Database
N\A
To connect to an IBM DB2 Universal
Database
In Management Agent Designer, on the Connect to
Database page, in Database, type the database name.
If this management agent will perform a full import of data
from a table or view, in Table/View, type the table or view
name.
If this management agent will perform a delta import of data
from a specially configured delta view, in Delta View, type
the name of the view.
If this management agent will perform import and export of
multi-value attributes from a specially configured table, in
Multivalue table, type the name of the table.
Under Authentication, type a user name and
password.
Notes
You are not required to install Microsoft Identity Integration Server 2003 on the server that is running the IBM DB2
Universal Database. However, for IBM DB2 Universal Database version
7, Connect 7 FP1 must be installed on the Microsoft Identity Integration Server 2003 with SP1. For IBM DB2 Universal Database
version 8.1, Connect 8.1 FP3 must be installed on the server
running Microsoft Identity Integration Server 2003 with SP1.
Configuring a management agent for import from a delta view has
special requirements. For more information, see Related
Topics.
Configuring a management agent for import and export from a
multi-value table has special requirements. For more information,
see Related Topics.
For import mode, the user account that is provided must have
Read access rights to the database table or view that you want to
synchronize. For export mode, the user account that is provided
must have Write access (that is, Insert, Delete, and Update) rights
to the database table or view that you want to synchronize.
You can select only one table or view per management
agent.
