Forum Search:
Forum.Brain-Cluster.com: Brain Cluster Technical Forum
Ultimate forum for Technical Discussions

Home » Microsoft » Windows Server » Active Directory » AD <-> SQL Hirearchies \ Nodes
AD <-> SQL Hirearchies \ Nodes [message #383216] Wed, 03 February 2010 04:22 Go to next message
CPiO  is currently offline CPiO
Messages: 8
Registered: September 2009
Junior Member
Hello All...

As part of our migration to Active Directory Win 2003, we are considering
‘interfacing’ our Active directory user \ group schema with our business
intelligence (SQL) location hierarchy.

The UK location hierarchy is has +- 3000 leaf level nodes and is 6 levels
deep. There are many other international location hierarchies.

When a user logs into any of our reporting web applications, the web session
will be able to obtain real time information only on the locations that
he\she has rights to see.

Other considerations,
• On the lowest level, we want to map an AD user to a unit
• We need to be able to map users to multi-hierarchies
• We need to be able to map users to multi-members
• We want to keep this centrally managed.

In the perfect world, we would like a special AD explorer tool that allows
us to browse the AD users and groups, right click a user or group and select
a number of nodes out of our SQL hierarchies.

Appreciate any direction. Are there any AD tools out there that may help us
achieve this? Are there any related case studies?

Many Thanks
James
Re: AD <-> SQL Hirearchies \ Nodes [message #383535 is a reply to message #383216] Wed, 03 February 2010 12:04 Go to previous message
Revenger  is currently offline Revenger  Croatia
Messages: 34
Registered: January 2010
Member
On Wed, 3 Feb 2010 03:22:03 -0800, CPiO wrote:

> In the perfect world, we would like a special AD explorer tool that allows
> us to browse the AD users and groups, right click a user or group and select
> a number of nodes out of our SQL hierarchies.
>
> Appreciate any direction. Are there any AD tools out there that may help us
> achieve this? Are there any related case studies?

I think I saw some SSIS components that can query AD, have a look at this
link:

http://ssisctc.codeplex.com/

You could use CSVDE to extract the data from AD and then use .csv files and
import them to your DW/BI solution.

Alternative would be to create a script task in SSIS and develop some
custom code to retrieve the information from AD, and/or to implement some
custom logic into your DW/BI solution ...

For other approaches see these:

http://www.zenatti.net/post/2009/03/04/Get-data-from-Active- Directory-using-SSIS.aspx
http://agilebi.com/cs/blogs/jwelch/archive/2007/04/07/retrie ving-information-from-active-directory-with-ssis.aspx
http://blogs.mssqltips.com/forums/t/1078.aspx
http://www.mssqltips.com/tip.asp?tip=1657
Previous Topic:How to monitor group policy changes in real time?
Next Topic:How to auto generate username and password
Goto Forum:
  


Current Time: Wed Jan 17 04:11:36 MST 2018

Total time taken to generate the page: 0.03343 seconds
.:: Contact :: Home ::Sitemap::.

Powered by: FUDforum 3.0.0RC2.
Copyright ©2001-2009 FUDforum Bulletin Board Software