What are the Oracle Identity Management APIs available for Application Integration?

1. Oracle Internet Directory provides LDAP APIs for C, Java, and PL/SQL.
2. Oracle Delegated Administration Services provides a number of services for building customized administration interfaces such as User LOV that manipulate directory data.
3. OracleAS Single Sign-On provides APIs for developing and deploying partner applications
4. JAZN is the Oracle implementation of the Java Authentication and Authorization Service (JAAS) Support standard. JAZN allows applications developed for the Web using the Oracle J2EE environment to use the identity management infrastructure for authentication and authorization.

What useful information can be extracted from ODS Schema?

I. Get user’s full name

You can get the information from ods.ds_attrstore. For example:

SELECT o.entryid,

UPPER(o.attrval) user_name,

(SELECT first.attrval FROM ODS.DS_ATTRSTORE first WHERE first.attrname = 'givenname' AND first.entryid

= o.entryid) first_name,

(SELECT last.attrval FROM ODS.DS_ATTRSTORE last WHERE last.attrname = 'sn' AND last.entryid = o.entryid)

last_name

FROM ODS.DS_ATTRSTORE o

WHERE o.attrname = 'uid'

II. How to Get other Attribute Values?

Attribute values are stored in ods.ct_ATTRIBUTE_NAME table

Oracle Identity Management-Basics

The Oracle Identity Management infrastructure includes the following components:

• Oracle Internet Directory- A general purpose directory service that enables fast retrieval and centralized management of information about users and network resources
  
• Oracle Directory Integration and Provisioning- This component enables synchronization between Oracle Internet Directory and other directories and user repositories
  
• Oracle Delegated Administration Services- This component provides trusted proxy-based administration of directory information by users and application administrators.
  
• Oracle Application Server Single Sign-On: This component provides single sign-on access to Oracle and third-party Web applications.
  
• Oracle Application Server Certificate Authority: This component generates and publishes X.509 V3 PKI certificates to support strong authentication methods.