LDAP/Active Directory
awilliams84 Apr 18, 2013 12:04 PMHi,
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.