Connect to an Oracle Database

  • Article

For this procedure, in Management Agent Designer, on the Connect to Database page, you connect to an Oracle10g 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 FIMSyncAdmins security group.

To connect to an Oracle database

  1. 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).

  2. If this management agent performs a full import of data from a table or view, in Table/View, type the table or view name.

  3. 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.

  4. 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.

  5. 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 Oracle Database, the Forefront Identity Manager 2010 R2 Synchronization 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 Forefront Identity Manager 2010 R2 Synchronization Service account Full Control permission to the folder and its subfolders and files. Restart the Forefront Identity Manager 2010 R2 Synchronization Service in order for the new permissions to take effect.

Note

Configuring a management agent for import from a delta view has special requirements. For more information, see See Also.

Note

Configuring a management agent for import and export from a multi-value table has special requirements. For more information, see See Also.

Note

You must have an Oracle client and an Oracle OLEDB provider installed on the FIM. For more information about the Oracle client and TNS Service Names, see your Oracle documentation.

Note

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.

Note

You can select only one table or view per management agent.

See Also

Concepts

Using the Management Agent for Oracle Database
Delta Views for Database Management Agents
Multi-Value Tables for Database Management Agents