LDAP User and Group Information in a BO Webi report

[Former Member]

Hi Team ,

We have a requirement wherein we want to have User Info and there corresponding groups in LDAP directory to be displayed  on a webi report.

This Information is not stored in any of the databases.

Requesting expert views on this If this is achievable in  BO?

Environment Info.

BOXI 3.1  SP 5 Clustered On Tomcat.

Enterprise Authentication.

Regards.

Kultar Pathania 

[former_member185603]

You can achieve by running security query in CMC.

And also you can run query builder query , but you need to use couple of queries to achieve you want.

[Former Member]

Hi Jawahar.

Let me explain again we  want to retrieve information of LDAP Users and  groups. this information will not reside in any of the  BO Metadata tables.

LDAP is Like Windows AD authentication where users and there roles are maintained at LDAP level only

Through query builder and security query we can retrieve Info as to what is inside the BO metadata tables but not from outside.

So basically we are Looking for a out of Box thing which can help us.

Let us know your views If any.

Regards

Kultar

[former_member182521]

You may need to create a mechanism which exports the Users & Group information to a .csv file or an Excel file based on which you can create a WebI report.

This could help you for LDAP Export  Exporting Data to Excel from LDAP Server

Based on the export from Step 1 you can create a WebI report though the values in Excel varies time to time.

Creating a Webi doc off of an unmanaged Excel data source on a network share

Thanks

Mani

[DellSC]

I believe there is something like an ODBC connector that is available to connect to an LDAP database. Or, if you have a SQL Server, you can create a "Linked Server" to query LDAP.  Once you have that, you could build a universe that will get you to that information.

You might find some useful information at these links:

LDAP Queries

LDAP in SQL Server 2012 - Database Administrators Stack Exchange

-Dell

[Former Member]

Thanks Dell and Mani,

Our thought process is also in sync of writing a script\ code that will fetch this Information to a Flat file and then we can go ahead and pull that in BO.