How to Use The OVD Dynamic Entry Tree Plugin (Doc ID 428777.1)

Last updated on NOVEMBER 27, 2019

Applies to:

Goal

How to use and configure the Oracle Virtual Directory (OVD) Dynamic Entry Tree plugin


According to the Oracle Virtual Directory Product Manual 10g (10.1.4.3), Appendix B: Bundled Plug-ins, a Dynamic Entry Tree is defined as follows:

The Dynamic Entry Tree is a general purpose plug-in that can be used to generate virtual directory tree hierarchy by using attributes found in entry leaf nodes. Example, if an adapter has a root of o=<COMPANY>.com and users are present as uid=<UID1>,ou=<OU1>,o=<COMPANY>.com, this plug-in can insert new hierarchy using data present in the user's entry. For example, uid=<UID1>,ou=<OU2>,ou=<OU1>,o=<COMPANY>.com.

The Solution below is based on the following assumptions:

• A database adapter will be used in OVD with Adapter Suffix/Namespace set to "dc=<COMPANY>,dc=com"
• A "Dynamic Entry Tree" plugin will be used
• Database entries should be viewed in OVD like this:

  uid=<UID1>,ou=<OU111>,ou=<OU11>,ou=<OU1>,dc=<COMPANY>,dc=com
  uid=<UID2>,ou=<OU111>,ou=<OU11>,ou=<OU1>,dc=<COMPANY>,dc=com
  uid=<UID3>,ou=<OU112>,ou=<OU11>,ou=<OU1>,dc=<COMPANY>,dc=com
  uid=<UID4>,ou=<OU112>,ou=<OU11>,ou=<OU1>,dc=<COMPANY>,dc=com
  uid=<UID5>,ou=<OU113>,ou=<OU12>,ou=<OU1>,dc=<COMPANY>,dc=com
  uid=<UID6>,ou=<OU113>,ou=<OU12>,ou=<OU1>,dc=<COMPANY>,dc=com

• There are 3 tables in the database:

  SQL> select * from <TABLENAME3>;
  
  OU3    UID  EMPLOYEE  FIRST_NAME             EMAIL  PHONE_NU  DEPARTME  DEP_ID
  ---  ---  --------  ----------  ----------------  --------  --------  --------
  <OU111> <UID1> <NUMBER1> <USERNAME1> <USERNAME1>@<COMPANY>.com <PHONE_NU1> <DEPID1>
  <OU111> <UID2> <NUMBER2> <USERNAME2> <USERNAME2>@<COMPANY>.com <PHONE_NU1> <DEPID1>
  <OU112> <UID3> <NUMBER3> <USERNAME3> <USERNAME3>@<COMPANY>.com <PHONE_NU1> <DEPID1>
  <OU112> <UID4> <NUMBER4> <USERNAME4> <USERNAME4>@<COMPANY>.com <PHONE_NU1> <DEPID1>
  <OU113> <UID5> <NUMBER5> <USERNAME5> <USERNAME5>@<COMPANY>.com <PHONE_NU1> <DEPID1>
  <OU113> <UID6> <NUMBER6> <USERNAME6> <USERNAME6>@<COMPANY>.com <PHONE_NU1> <DEPID1>
  <OU113> <UID7> <NUMBER7> <USERNAME7> <USERNAME7>@<COMPANY>.com <PHONE_NU1> <DEPID1> 
  
  SQL> select * from <TABLENAME2>; 
  OU2     OU3 
  ---     ---
  <OU11> <OU111>
  <OU11> <OU112>
  <OU12> <OU113>
  <OU12> <OU114>
  
  SQL> select * from <TABLENAME1>;
  
  OU1   OU2 
  ---   ---
  <OU1> <OU11> 
  <OU1> <OU12> 
  

  
  Table descriptions
  
  • table<TABLENAME1 - stores level 1 hierarchy departments from organization "<OU1>", with departments "<OU11>" and "<OU12>"
  • table <TABLENAME2> - stores level 2 hierarchy departments from organizations "<OU11>" and "<OU12>", with departments "<OU111>", "<OU112>", "<OU113>", and "<OU114>"
  
  For this example, a small number of departments is used to simplify the procedure

Solution

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