1 About the Connector

Oracle Identity Manager automates access rights management, security, and provisioning of IT resources. Oracle Identity Manager connectors are used to integrate Oracle Identity Manager with third-party applications. This guide discusses the procedure to deploy the connector that is used to integrate Oracle Identity Manager with Oracle Retail Warehouse Management System.

This chapter contains the following sections:

• Certified Components

• Certified Languages

• Reconciliation Module

• Provisioning Module

• Supported Functionality

• Certified Languages

• Files and Directories That Comprise the Connector

• Determining the Release Number of the Connector

Note:

In this guide, the term Oracle Identity Manager server refers to the computer on which Oracle Identity Manager is installed.

At some places in this guide, Oracle Retail Warehouse Management System has been referred to as the target system.

1.1 Certified Components

The following table lists the deployment requirements for the connector.

Item	Requirement
Oracle Identity Manager	You can use one of the following releases of Oracle Identity Manager: Oracle Identity Manager release 9.0.1 through release 9.0.3.x Oracle Identity Manager release 9.1.0.1 or later Note: In this guide, Oracle Identity Manager release 9.1.0.x has been used to denote Oracle Identity Manager release 9.1.0.1 and future releases in the 9.1.0.x series that the connector will support. Oracle Identity Manager 11g release 1 (11.1.1) Note: In this guide, Oracle Identity Manager release 11.1.1 has been used to denote Oracle Identity Manager 11g release 1 (11.1.1). The connector does not support Oracle Identity Manager running on Oracle Application Server. For detailed information about certified components of Oracle Identity Manager, see the certification matrix on Oracle Technology Network at http://www.oracle.com/technetwork/documentation/oim1014-097544.html
Target systems	Oracle Retail Warehouse Management System release 12.0
Target system user account	An Oracle Database user account that has been granted the CONNECT and RESOURCE privileges to the Oracle Retail Warehouse Management System database by the system administrator . See the "Additional Privileges" section for information about additional privileges to be granted to the preceding user account.
JDK	The JDK version can be one of the following: For Oracle Identity Manager release 9.0.1 through 9.0.3.x, use JDK 1.4.2 or a later release in the 1.4.2 series. For Oracle Identity Manager release 9.1.0.x, use JDK 1.5 or a later release in the 1.5 series. For Oracle Identity Manager release 11.1.1, use JDK 1.6 update 18 or later, or JRockit JDK 1.6 update 17 or later.

Additional Privileges

The following table specifies the privileges that the user must have on some of the Oracle Retail Warehouse Management System tables:

Table Name	Select	Insert	Delete	Update
DMS_USER	Yes	Yes	Yes	Yes
FACILITY	Yes	No	No	No
SUPPORTED_LANGUAGE	Yes	No	No	No
DC_DEPARTMENT	Yes	No	No	No
USER_CLASS	Yes	No	No	No

1.2 Certified Languages

The connector supports the following languages:

• Chinese Simplified

• Chinese Traditional

• Danish

• English

• French

• German

• Italian

• Japanese

• Korean

• Portuguese (Brazilian)

• Spanish

See Also:

One of the following guides for information about supported special characters:

• For Oracle Identity Manager release 9.0.1 through 9.0.3.x and release 9.1.0.x:

  Oracle Identity Manager Globalization Guide

• For Oracle Identity Manager release 11.1.1:

  Oracle Fusion Middleware Developer's Guide for Oracle Identity Manager

1.3 Reconciliation Module

Reconciliation involves duplicating in Oracle Identity Manager the creation of and modifications to user accounts on the target system. It is an automated process initiated by a scheduled task that you configure.

The reconciliation module handles the reconciliation of new, updated, and deleted user profiles in Oracle Identity Manager. A reconciliation event is created for each user profile to be reconciled.

See Also:

One of the following guides for conceptual information about reconciliation configurations:

• For Oracle Identity Manager release 9.0.1 through 9.0.3.x and release 9.1.0.x: Oracle Identity Manager Connector Concepts Guide

• For Oracle Identity Manager release 11.1.1: Oracle Fusion Middleware User's Guide for Oracle Identity Manager

Based on the type of data reconciled from the target system, reconciliation can be divided into the following types:

• Lookup Fields Reconciliation

• User Reconciliation

1.3.1 Lookup Fields Reconciliation

Lookup fields reconciliation involves reconciling the following lookup fields:

• FacilityID

• LanguageCode

• Department

• UserClass

1.3.2 User Reconciliation

User reconciliation involves reconciling the following fields:

• FacilityID

• UserID

• Department

• UserName

• User Privilege

• User LogDate

• Language Code

• Picking Percent QA

• Packing Percent QA

• DCDept

• User Class

• Equipment

1.4 Provisioning Module

Provisioning involves creating or modifying a user's account on the target system through Oracle Identity Manager. You use the Oracle Identity Manager Administrative and User Console to perform provisioning operations.

See Also:

One of the following guides for conceptual information about provisioning:

• For Oracle Identity Manager release 9.0.1 through 9.0.3.x and release 9.1.0.x: Oracle Identity Manager Connector Concepts Guide

• For Oracle Identity Manager release 11.1.1: Oracle Fusion Middleware User's Guide for Oracle Identity Manager

In provisioning, you can specify values for the following fields:

• FacilityID

• UserID

• UserName

• User Privilege

• Language Code

• Picking Percent QA

• Packing Percent QA

• DCDept

• User Class

• Equipment

• User Password

Provisioning of a user in Oracle Retail Warehouse Management System depends on the FacilityID value. During provisioning, depending on the value that you select from the FacilityID lookup field, you must select corresponding values from the DCDept and UserClass lookup fields.

For example:

Suppose you select AY as the FacilityID value. The description of this FacilityID value is ANUSRINI Customer Support LR=Y. Based on this description, you must select the following values in the DCDept and UserClass lookup fields:

DCDept:

ACCOUNTING (ANUSRINI Customer Support LR=Y)

UserClass:

DEFAULT (ANUSRINI Customer Support LR=Y)

Caution:

If you do not select corresponding values from the DCDept and UserClass lookup fields, then the provisioning operation would fail. However, Oracle Identity Manager does not display an error message if you do not select the correct DCDept and UserClass values.

This point is also mentioned in the "Known Issues" chapter.

1.5 Supported Functionality

The following table lists the functions that are available with this connector.

Function	Type
Create User	Provisioning
Reset User's Password	Provisioning
Update User's Name	Provisioning
Update User's Privilege	Provisioning
Update User's Department	Provisioning
Update User's Language Code	Provisioning
Update User's Picking Percent QA	Provisioning
Update User's Packing Percent QA	Provisioning
Update User's User Class	Provisioning
Update User's Equipment	Provisioning
Delete User	Provisioning
Create User (Account Discovery)	Reconciliation
Update User's Name	Reconciliation
Update User's Department	Reconciliation
Update User's Language Code	Reconciliation
Update User's Picking Percent QA	Reconciliation
Update User's Packing Percent QA	Reconciliation
Update User's User Class	Reconciliation
Update User's Equipment	Reconciliation

1.6 Files and Directories That Comprise the Connector

The files and directories that comprise this connector are listed in Table 1-1.

Table 1-1 Files and Directories on the Installation Media

File in the Installation Media Directory	Description
config/attributemapping_prov.properties	This file contains the parameters required for provisioning.
config/attributemapping_recon.properties	This file contains the parameters required for reconciliation.
lib/rwmsadapter.jar	This JAR file contains the class files that are used to implement provisioning and reconciliation. During connector installation, this file is copied to the following location: For an Oracle Identity Manager release from 9.0.1 through 9.0.3.x and release 9.1.0.x, this file is copied to the following directories: OIM_HOME/xellerate/JavaTasks OIM_HOME/xellerate/ScheduleTask For Oracle Identity Manager release 11.1.1: Oracle Identity Manager database
Files in the dataset directory	These XML files specify the information to be submitted by the requester during a request-based provisioning operation.
File in the resources directory	Each of these resource bundles contains language-specific information that is used by the connector. During connector installation, these resource bundles are copied to the following location: For Oracle Identity Manager release 9.0.1 through release 9.0.3.x and release 9.1.0.x: OIM_HOME/xellerate/connectorResources For Oracle Identity Manager release 11.1.1: Oracle Identity Manager database Note: A resource bundle is a file containing localized versions of the text strings that are displayed on the Administrative and User Console. These text strings include GUI element labels and messages.
scripts/DB Schema XML/xdb_app_map.xsd	This XML file contains information about the validation rules to which the RWMS.xml file conforms.
scripts/RWMS.xml	This XML file contains the configuration information of Oracle Retail Warehouse Management System users.
scripts/RWMSTrigger/TriggerRWMS.sql	This file contains the SQL code for creating a temporary table and the trigger that is used to implement the reconciliation of user account deletion on the target system.
test/config/config.properties	This file is used to specify the parameters and settings required to connect to the target system by using the testing utility.
test/config/log.properties	This file is used for storing log information.
test/scripts/rwms.bat test/scripts/rwms.sh	This file is used to run the test utility.
xml/xlRWMSNonTrusted.xml	This file contains definitions for the following components of the connector: IT resource type IT resource Resource object Process form Process definition Process tasks Adapters
xml/xlRWMSTrusted.xml	This XML file contains the configuration for the Xellerate User. You must import this file only if you plan to use the connector for trusted source reconciliation.

Note:

The files in the test directory are used only to run tests on the connector.

The "Copying the Connector Files and External Code Files" section provides instructions to copy these files into the required directories.

1.7 Determining the Release Number of the Connector

Note:

If you are using Oracle Identity Manager release 9.0.1 through release 9.0.3.x and release 9.1.0.x, then the procedure described in this section is optional.

If you are using Oracle Identity Manager release 11.1.1, then skip this section.

You can use the following method to determine the release number of the connector:

1. Extract the contents of the rwmsadapter.jar file. This file is in the following directory on the installation media:

   Enterprise Applications/Oracle Retail Applications/Oracle Retail Warehouse Mgmt
   

2. Open the manifest.mf file in a text editor. The manifest.mf file is one of the files bundled inside the rwmsadapter.jar file.

   In the manifest.mf file, the release number of the connector is displayed as the value of the Version property.