My Oracle Support Banner

OVD 11g: How To Join On Attribute Values That Do Not Exactly Match? How To Join A Multivalued Attribute With A Single Value Attribute, Where One Has An Additional Prefix String In The Value? (Doc ID 1483591.1)

Last updated on APRIL 19, 2021

Applies to:

Oracle Virtual Directory - Version and later
Information in this document applies to any platform.


Oracle Virtual Directory (OVD) 11g, e.g.,

How to create a join between MS SQL 2008 Database (DB) Server and Active Directory (AD) 2008 ldap adapters, where SQL uses the Email attribute and the AD adapter uses a multivalued attribute called proxyAddresses, but their values differ / are not an exact match?

The proxyAddresses attribute is a multi value attribute which contains data in the following format, eg, "smtp:firstname.lastname@<COMPANY_NAME>.<DOMAIN>".  Because it includes the "smtp:" string / prefix before the email address, this is causing the simple join not to work.

Scenario details:
In AD, a user account has a multivalued attribute called proxyaddress that has multiple values all in the format of smtp:<email address>.

In the SQL DB, the corresponding account has an attribute called mail, which has just the email address for value.

Need to create a join based on these attributes values, but the smtp: prefix is causing the join not to work.

Unable to use the AD regular mail attribute for the join because it is never up to date. whereas the proxyaddress attribute is always updated; i.e., when someone changes email or gets married, only the proxyaddress value is updated in AD.


How to match the two fields of difference values, i.e., how to edit to exclude or remove the smtp: string from the destination adapter?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.