I need to pull ("Connect Live") data from LDAP and Active Directory to get some dinmensions and measures, thus I need to connect to them for analytics NOT authentication/authorization. Since there isn't really a ODBC connection, I need to use something else like OLE DB (ADO) I have been told.
Any links / posts / suggestions is appreciated.
I highly doubt you can use Tableau to query LDAP. LDAP does not use SQL.
I've successfully used Pentaho Data Integration's "LDAP Input" step in the past. You could output it to Excel or a database.