Build a framework to report off corporate Active Directory structure

[tendomentis]

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?

[blom0344]

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?

[bdbits]

If you have Virtual View Manager, you can set it up to point at Active Directory as a data source.