9.14. Create a Relational Source Model from LDAP Data

Procedure 9.3. Create a Relational Source Model from LDAP Data

1. Go into the Model Explorer.
2. Choose the File - Import action in the toolbar.
   Alternatively, you can select a project, folder or model in the Tree and choose Import...
3. Select the import option by clicking Teiid Designer - LDAP Service - Source Model and then click Next.
4. Select an existing or previous LDAP connection profile from the drop-down selector.
   Alternatively, click the New... button to launch the New Connection Profile dialog or Edit... to modify or change an existing connection profile prior to selection.

   Note

   You must supply the following information when you create a new connection:

   • A connection Username and password - this is an administrator account to browse the ldap tree, eg. cn=Manager,dc=birds-of-prey,dc=org
   • A connection URL, for example ldap://falcon:389
   • Principal Distinguished Name (DN) Suffix - this is the root DN of the ldap tree
   • An LDAP Connection Factory implementation class, for example com.sun.jndi.ldap.LdapCtxFactory
   When you select the connection profile, it automatically populates the LDAP Service URL and DN Suffix fields. The remaining requirements for the wizard page is the choosing of a suitable model file as the destination of the imported tables. If the selection is an existing model then the wizard will merge the new tables with the model's current content.
5. After selecting a Connection Profile, click Next.
6. On the Select LDAP Entries to be modeled as tables page, select the LDAP entries from the tree to be created as tables in the source model. (Select entries by ticking their respective checkboxes in the tree.)
   If you highlight an entry, the following information about it is displayed:
   • Table Name - this is the table's label and can be modified to a more readable value
   • Table Source Name - the fully qualified entry name. This is not editable in the wizard and should remain unchanged in the subsequently created source model
   • Table Source Name Suffix - an additional suffix can be added that further limits the scope of the table's search criteria. The suffix is in the format of ?search_scope?objectClass_name where search_scope is one of OBJECT_SCOPE (first and only one entry returned), ONELEVEL_SCOPE (only entries directly below the selected entry are returned) or SUBTREE_SCOPE (recursively return all entries below the selected entry) and objectClass_name is the name of a specific type of objectClass in the LDAP tree, eg. return only the 'inetOrgPerson' entries. Both criteria are optional (but the '?'s are not) so it is possible to have a suffix such as ? ? inetOrgPerson.
7. Click Next.
8. The Select the LDAP Attributes to be modeled as columns page displays the previously selected LDAP entries and the attributes of their child entries. The purpose of a selected attribute is to be created as a column in the relevant source model table. Select attributes by ticking their respective checkboxes in the tree.
   If you highlight an entry, the following information about it is displayed:
   • Column Name - this is the column's label and can be modified to a more readable value
   • Column Source Name - the real LDAP attribute name. This is not editable in the wizard and should remain unchanged in the subsequently created source model
   • Column Distinct Value Count - The number of distinct values assigned to the specific attribute in the LDAP service. This value is useful in optimising queries using the source model. This is not editable in the wizard and should remain unchanged in the subsequently created source model.
   • Column Null Value Count - The number of entries where the specific attribute has no value assigned in the LDAP service. This value is useful in optimising queries using the source model. This is not editable in the wizard and should remain unchanged in the subsequently created source model.
   • Column Length - The maximum length of existing values assigned to the attribute in the LDAP service. This value is assigned as the maximum length of the column. This is not editable in the wizard but can be edited in the source model later should this be required.
9. Click Finish.