3 Replies Latest reply on Apr 19, 2013 9:32 AM by Ramesh Reddy

    LDAP/Active Directory

    adam williams Newbie



      I have been stuck trying to integrate an Active Directory source into my Virtual Database for a couple days and was wondering if anyone here had any advice?


      I am able to connect with my resource adapter, but when I try to bring into my Virtual Database I receive this error:


      11:37:25,275 WARN  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 1)  TEIID31070 Empty model;There are no tables, procedures or functions defined in this model ldapAD


      Here is my resource adapter - I modfied the server ip where I have Active Directory and my DN.  I am able to connect.    





                      <connection-definition class-name="org.teiid.resource.adapter.ldap.LDAPManagedConnectionFactory"






                         <!-- LDAP Directroy URL (required)-->

                        <config-property name="LdapUrl">ldap://<server-ip>:389</config-property>


                        <!-- Ldap Admin User DN (required)-->

                        <config-property name="LdapAdminUserDN">CN=Administrator,CN=Users,DC=test,DC=company,DC=com</config-property>


                        <!-- Ldap Admin Password (required)-->

                        <config-property name="LdapAdminUserPassword">pwd1</config-property>


                        <!-- Ldap Transaction Timeout (ms) -1 = no time out (optional) -->

                        <config-property name="LdapTxnTimeoutInMillis">-1</config-property>






      Here is my Virtual Databse:


      <model name="ldapAD">

              <source name="ldapAD-connector" connection-jndi-name="java:/ldapDS" translator-name="ldap"/>




      Is it possible that i must create some kind of virtual table first?  Since active directory is just a tree structure, does Teiid bring it into table form?


      I appreciate your time.