Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: tendomentis on 08 Nov 2011 08:42:27 AM

Title: Build a framework to report off corporate Active Directory structure
Post by: tendomentis on 08 Nov 2011 08:42:27 AM
Hopefully, this is an easy request. I need to report off our internal Active Directory for various reasons, and thought it would be convenient if I was able to do so through Cognos.

Is it even possible to create a framework that uses Active Directory as a data source?
Title: Re: Build a framework to report off corporate Active Directory structure
Post by: blom0344 on 09 Nov 2011 01:49:50 PM
The NTDS.DIT file which effectively stores AD data is based on the Extensible Storage Engine (ESE) data storage format. This is a B-tree structured database (not unlike the datastructure that supports B-tree indexes)

see: http://en.wikipedia.org/wiki/Extensible_Storage_Engine

Actually I doubt that FM can import the structure, perhaps by generic ODBC?
Title: Re: Build a framework to report off corporate Active Directory structure
Post by: bdbits on 14 Nov 2011 01:21:35 PM
If you have Virtual View Manager, you can set it up to point at Active Directory as a data source.
Text only | Text with Images