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

    LDAP/Active Directory

    adam williams Newbie

      Hi,

       

      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.    

      <resource-adapter>

                  <archive>teiid-connector-ldap.rar</archive>

                  <transaction-support>NoTransaction</transaction-support>

                  <connection-definitions>

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

                              jndi-name="java:/ldapDS"

                              enabled="true"

                              use-java-context="true"

                              pool-name="ldap-ds">

                             

                         <!-- 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>

           

                      </connection-definition>

                  </connection-definitions>

              </resource-adapter>

       

      Here is my Virtual Databse:

       

      <model name="ldapAD">

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

       

          </model>

       

      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.