+ Post New Thread
Results 1 to 15 of 15
Windows Thread, Tool to sync AD with MIS / external source in Technical; Hi, We're in the process of pruning and tidying the AD in preparation for SharePoint 2007. Our AD is out ...
  1. #1

    Join Date
    Feb 2007
    Location
    Monmouth, South Wales
    Posts
    54
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Tool to sync AD with MIS / external source

    Hi,
    We're in the process of pruning and tidying the AD in preparation for SharePoint 2007. Our AD is out of sync with our MIS (we use a system called PASS which runs on a SQL Server 2000 back-end).
    I'm after a tool to easily synchronise the Active Directory user accounts with accounts on the school MIS system.
    Does anybody know of such a tool?
    If not what suggestions might y'all have?

    cheers

    baronne

  2. #2

    plexer's Avatar
    Join Date
    Dec 2005
    Location
    Norfolk
    Posts
    13,272
    Thank Post
    613
    Thanked 1,567 Times in 1,407 Posts
    Rep Power
    412

    Re: Tool to sync AD with MIS / external source

    Do your usernames follow a format that is in your mis then?

    Ben

  3. #3


    Join Date
    Jan 2006
    Posts
    8,202
    Thank Post
    442
    Thanked 1,032 Times in 812 Posts
    Rep Power
    339

    Re: Tool to sync AD with MIS / external source

    We have such a tool, it was internally developed (not by me) for CMIS/AD integration -not sure if it's been updated much since then.
    I posted it here:
    http://www.edugeek.net/index.php?nam...ewtopic&t=3455

  4. #4

    Join Date
    Feb 2007
    Location
    Monmouth, South Wales
    Posts
    54
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: Tool to sync AD with MIS / external source

    Quote Originally Posted by plexer
    Do your usernames follow a format that is in your mis then?

    Ben
    unfortunately not... it's never been captured into the MIS.
    So I expect a manual process of entering their usernames into the database.

    ...hmmm

  5. #5

    Join Date
    Feb 2007
    Location
    Monmouth, South Wales
    Posts
    54
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: Tool to sync AD with MIS / external source

    Quote Originally Posted by CyberNerd
    We have such a tool, it was internally developed (not by me) for CMIS/AD integration -not sure if it's been updated much since then.
    I posted it here:
    http://www.edugeek.net/index.php?nam...ewtopic&t=3455
    cheers.. I'm not a developer, so that's a bit of a mouthful all that code, but I guess one could slowly but surely keep at it. However, fiddling about with the live system, I'm not sure I want to do...........

    baronne

  6. #6

    plexer's Avatar
    Join Date
    Dec 2005
    Location
    Norfolk
    Posts
    13,272
    Thank Post
    613
    Thanked 1,567 Times in 1,407 Posts
    Rep Power
    412

    Re: Tool to sync AD with MIS / external source

    I was just wondering how you track a user between your MIS and the AD I suppose you could add their UPN in the description of somewhere to tie those 2 together if there is no direct correlation.

    Ben

  7. #7

    Join Date
    Feb 2007
    Location
    Monmouth, South Wales
    Posts
    54
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: Tool to sync AD with MIS / external source

    nothing has ever been done to link the two together... this is the first instance of trying to get some unity between the systems and keep some sort of order among the (slight) chaos.

    I'm gonna go for a manual approach to tidy first and then once it is sorted, I can work on a way of tracking & sync'ing accounts

    baronne

  8. #8


    Join Date
    Jan 2006
    Posts
    8,202
    Thank Post
    442
    Thanked 1,032 Times in 812 Posts
    Rep Power
    339

    Re: Tool to sync AD with MIS / external source

    - As plexer suggests, our tracking uses the individual student UPN (the MIS one, NOT the userprinciplename) in CMIS. The MIS UPN is put into the EmployeeID field in Active Directory.

  9. #9

    Join Date
    Feb 2007
    Location
    Monmouth, South Wales
    Posts
    54
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: Tool to sync AD with MIS / external source

    When I look at my user objects in AD I don't see an EmployeeID... does one need to dig into ADSIEDIT or something? Also... is it possible then to have a custom field in Active Directory?

  10. #10

    Geoff's Avatar
    Join Date
    Jun 2005
    Location
    Fylde, Lancs, UK.
    Posts
    11,802
    Thank Post
    110
    Thanked 583 Times in 504 Posts
    Blog Entries
    1
    Rep Power
    224

    Re: Tool to sync AD with MIS / external source

    does one need to dig into ADSIEDIT or something?
    I'd suggest you look at it via LDAP instead. It's a lot clearer that way.

    Also... is it possible then to have a custom field in Active Directory?
    You'd have to extend the schema to do that.

  11. #11

    Join Date
    Feb 2007
    Location
    Monmouth, South Wales
    Posts
    54
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: Tool to sync AD with MIS / external source

    Quote Originally Posted by Geoff
    I'd suggest you look at it via LDAP instead. It's a lot clearer that way.
    I may sound like a newbie here, but how to you look at it via LDAP?

    cheers
    Baronne

  12. #12

    plexer's Avatar
    Join Date
    Dec 2005
    Location
    Norfolk
    Posts
    13,272
    Thank Post
    613
    Thanked 1,567 Times in 1,407 Posts
    Rep Power
    412

    Re: Tool to sync AD with MIS / external source

    In that case I'd suggest very carefully

    Ben

  13. #13

    Geoff's Avatar
    Join Date
    Jun 2005
    Location
    Fylde, Lancs, UK.
    Posts
    11,802
    Thank Post
    110
    Thanked 583 Times in 504 Posts
    Blog Entries
    1
    Rep Power
    224

    Re: Tool to sync AD with MIS / external source

    Download Softerra's LDAP Browser.

    http://www.ldapbrowser.com/download.htm

  14. #14

    Join Date
    Feb 2007
    Location
    Monmouth, South Wales
    Posts
    54
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: Tool to sync AD with MIS / external source

    Check out ManageEngine's ADManager Plus
    http://manageengine.adventnet.com/pr...elp/index.html

    I've had this tool on my machine for some time and it looks like this may make things a little easier for me. I've just never really looked at it properly. but it is handy for creating bulk users and it also has a bulk modify thingy, so I can export from our MIS to CSV and then use ADManager to do the business!

    cheers
    baronne

  15. #15

    Join Date
    Jan 2006
    Location
    Surburbia
    Posts
    2,178
    Thank Post
    74
    Thanked 307 Times in 243 Posts
    Rep Power
    115

    Re: Tool to sync AD with MIS / external source

    Download Softerra's LDAP Browser.
    That has a home in my penstick toolbox.. routine trawls through normal ADs are fine, but the schema won't expand fully without fiddling with the DS search limit.

    I've only wanted that for obscure reasons on a couple of occasions and I'm not sure how advisable this is on serious production boxes, but increasing the search limit with ntdsutil from 1000=>1500 works for me.

SHARE:
+ Post New Thread

Similar Threads

  1. Sync Files Online
    By sqdge in forum Web Development
    Replies: 3
    Last Post: 23rd December 2007, 08:49 AM
  2. Problems with My Docs Sync on laptop.
    By wadeeuk in forum How do you do....it?
    Replies: 6
    Last Post: 13th November 2007, 11:00 PM
  3. disable sync errors
    By CyberNerd in forum Windows
    Replies: 3
    Last Post: 2nd November 2006, 11:18 AM
  4. Sync copies with my briefcase
    By timbo343 in forum Windows
    Replies: 2
    Last Post: 4th October 2006, 09:34 AM
  5. Why wont this PDA sync with exchange?
    By woody in forum Windows
    Replies: 16
    Last Post: 13th April 2006, 08:31 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •