Skip Headers
Oracle® Identity Manager Connector Guide for Oracle Retail Warehouse Management System
Release 9.0.4

E10454-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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:

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:

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:

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

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:

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

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.