For this procedure, in Management Agent Designer, on the
Connect to Database page, you connect to an Oracle8i
Database or Oracle9i Database and provide information about the
database to be synchronized. You must also provide a user account,
password, and logon domain to logon to the Oracle database. The
user account can use Oracle Database authentication or Windows
integrated authentication. The user account that you specify must
have at least read rights for the database. Each time the
management agent is run, it uses this information to log on to the
database to read or write to the table or view 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 editions:
Enterprise Edition
Identity Integration Feature Pack for Active Directory
Oracle Database
N\A
To connect to an Oracle database
In Management Agent Designer, on the Connect to
Database page, in Data source, type the name of the
Oracle data source connection (TNS Service Name).
If this management agent performs a full import of data from a
table or view, in Table/View, type the table or view
name.
If this management agent performs a delta import of data from a
specially configured view, in Delta View, type the name of
the table or view.
If this management agent will perform import and export of
multi-value attributes from a specially configured table, in
Multi-value table, type the name of the table.
In Authentication mode, select Database
authentication or Windows integrated authentication, and
then type a user account, password, and logon domain.
Important
To create a management agent for Oracle8i or Oracle9i Database,
the Microsoft Identity Integration Server service account must have
Full Control permissions to the root Oracle folder, for
example C:\Oracle, and its subfolders. Use the folder properties to
grant the Microsoft Identity Integration Server service account
Full Control permission to the folder and its subfolders and
files. Restart the Microsoft Identity Integration Server service in
order for the new permissions to take effect.
Notes
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.
You must have an Oracle client and an Oracle OLEDB provider
installed on the Microsoft Identity Integration Server 2003. For
more information about Oracle client and TNS Service Names, see
Oracle documentation.
For import mode, the user account provided must have read
access rights to the database table/view that you want to
synchronize. For export mode, the user account 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.
