Ok. So how do I go about connecting into it then?

Is that true, the LDAP adapter is free ?

I was under the impression that it was the authorisation part of the reporting server that you could point to LDAP for free.

FYI

Dev Studio can do it, as it has all adapters.

Waz is correct. Based on the information we were provided at our local IBI office, LDAP can only be used from WebFOCUS for the purpose of Authentication.Authorization at no additional charge. If you require to access an LDAP repository for reporting purposes then you'll have to license the appropriate iWay adapter.

We had a similar need a while back and decided to use a slightly different approach, where we use a VB script to connect to Active Directory, extract user/group information to a CSV file and load its content into a couple of tables in our data warehouse on a daily basis. We can then use WebFOCUS metadata to query those tables using our regular iWay Oracle adapter and build the reports we needed. This approach works for us because user information is relatively stable so live connections to Active Directory are not necessary for our reports.

This message has been edited. Last edited by: njsden,

Thanks,

I am actually thinking njsden that we may end up using that approach if I have no direct way to go about it.

There is also a build in function that will get a list of GROUPS that a user is part of from AD, if the Reporting Server is configured for LDAP Authentication.

-SET &LIST = GRPLIST(32000, 'A32000');

The maximum length that I could get it to work with is 32000 characters.

Not sure when this function was introduced but it there in WebFOCUS 8x

Scott