| Author | Messages | |
travis.abrams@xxxx.yyy
 | | 09/14/2005 2:01 AM |
| Does anyone have any recommendations on products or information on synchronizing data from a SQL database to AD. For example, we want to synch data from the HR database to the users account.
Thanks in advance
Travis Abrams | | | |
| aricbernard
Posts:2
| | 09/14/2005 1:51 AM |
| HP also offers a product called LDSU (lightweight
directory synchronization utility) which, although relatively unknown, is very
mature and is used in many fortune 500 IT shops. http://h20219.www2.hp.com/services/cache/11215-0-0-225-121.html
From: ActiveDir-owner@xxxxxxxxxxxxxxxxxx
[mailto:ActiveDir-owner@xxxxxxxxxxxxxxxxxx] On
Behalf Of Matt
Sent: Tuesday, September 13, 2005
7:13 PM
To: ActiveDir@xxxxxxxxxxxxxxxxxx
Subject: Re: [ActiveDir]
Synchronizing AD
You could use MIIS (http://www.microsoft.com/windowsserversystem/miis2003/default.mspx) which
is a fully functional meta-directory solution from Microsoft or there is
another tool called SimpleSync (http://www.cps-systems.com/simplesync/) which
I believe will provide you simpler but similiar
functionality. I prefer to use MIIS however it is costly, and
perhaps overly complex for your particular situation.
On 9/13/05, travis.abrams@xxxxxxxxx
wrote:
Does
anyone have any recommendations on products or information on synchronizing
data from a SQL database to AD. For example, we want to synch data from the HR
database to the users account.
Thanks
in advance
Travis Abrams
--
Tnx,
Matt | | | |
| AD00000307
Posts:0
| | 09/14/2005 2:07 AM |
| Northrop-Grumman
HR: PeopleSoft/Oracle 90K+
employees
Synced to Active Directory to create new, Disabled Users,
with a mail store and approximately 50 attributes.
Updated with Adds, Modifications, deletions (actually
Disabled and cleaned up to be deleted later).
Cost for software: $10K
Time to install: Less than a week
Also synchronized this AD with several other AD's for $1K
each.
Product: SimpleSync
For more information and to download an evaluation
copy of SimpleSync, please visit www.cps-systems.com . If you would
like to see SimpleSync 'live', please contact me at sales@xxxxxxxxxxxxxxx for a web demo
using Glance.
Thank you for your time,
Jerry Welch
CPS Systems
US/Canada: 1 888 666
0277
International: +1 703 827 0919 (-5 GMT)
Skype: Jerry_Welch
Jerry Welch
CPS Systems
US/Canada: 888-666-0277
International: +1 703 827 0919 (-4
GMT)
IP Phone (Skype): Jerry_Welch ( www.skype.net )
From: ActiveDir-owner@xxxxxxxxxxxxxxxxxx
[mailto:ActiveDir-owner@xxxxxxxxxxxxxxxxxx] On Behalf Of
travis.abrams@xxxxxxxxxSent: Tuesday, September 13, 2005 10:00
PMTo: ActiveDir@xxxxxxxxxxxxxxxxxxSubject: [ActiveDir]
Synchronizing AD
Does anyone have any recommendations on products or
information on synchronizing data from a SQL database to AD. For example, we
want to synch data from the HR database to the users account.
Thanks in advance
Travis Abrams | | | |
| misnerm
Posts:0
| | 09/14/2005 2:13 AM |
| On 9/13/05, travis.abrams@xxxxxxxxx wrote:
Does anyone have any recommendations on products or information on synchronizing data from a SQL database to AD. For example, we want to synch data from the HR database to the users account.
Thanks in advance
Travis Abrams -- Tnx, Matt | | | |
| bdesmond
Posts:416
| | 09/14/2005 2:53 AM |
| We were looking at MIIS for a while. In the end I just sat down and wrote
some .net code custom for the environment. Took me a few days, works great.
Does sync from HR and Sun LDAP to AD right now, going to add legacy student
information and some other systems once I find someone to give me access.
Thanks,
Brian Desmond
brian@xxxxxxxxxxxxxxxx
c -
312.731.3132
From:
ActiveDir-owner@xxxxxxxxxxxxxxxxxx [mailto:ActiveDir-owner@xxxxxxxxxxxxxxxxxx] On Behalf Of travis.abrams@xxxxxxxxx
Sent: Tuesday, September 13, 2005
10:00 PM
To: ActiveDir@xxxxxxxxxxxxxxxxxx
Subject: [ActiveDir] Synchronizing
AD
Does
anyone have any recommendations on products or information on synchronizing
data from a SQL database to AD. For example, we want to synch data from the HR
database to the users account.
Thanks
in advance
Travis Abrams | | | |
| AD00000333
Posts:0
| | 09/14/2005 3:17 AM |
| I have some perl code that reads user information from some
Oracle tables, and updates the corresponding user objects in AD (phone numbers,
address, etc). It does not create new users (although I do have some other code
for that), not does it sync changes made in AD back to the Oracle
tables.
It's yours if you want it.
From: ActiveDir-owner@xxxxxxxxxxxxxxxxxx
[mailto:ActiveDir-owner@xxxxxxxxxxxxxxxxxx] On Behalf Of
travis.abrams@xxxxxxxxxSent: Tuesday, September 13, 2005 9:00
PMTo: ActiveDir@xxxxxxxxxxxxxxxxxxSubject: [ActiveDir]
Synchronizing AD
Does anyone have any recommendations on products or
information on synchronizing data from a SQL database to AD. For example, we
want to synch data from the HR database to the users account.
Thanks in advance
Travis Abrams | | | |
| travis.abrams@xxxx.yyy
| | 09/14/2005 5:15 AM |
| Thanks to everyone for the information. I have several routes to
look at now.
Thanks again.
Travis Abrams | | | |
| prenouf
Posts:1
| | 09/14/2005 6:06 AM |
| Phil
On 9/13/05, Matt wrote:
You could use MIIS (
http://www.microsoft.com/windowsserversystem/miis2003/default.mspx) which is a fully functional meta-directory solution from Microsoft or there is another tool called SimpleSync (
http://www.cps-systems.com/simplesync/) which I believe will provide you simpler but similiar functionality. I prefer to use MIIS however it is costly, and perhaps overly complex for your particular situation.
On 9/13/05, travis.abrams@xxxxxxxxx wrote:
Does anyone have any recommendations on products or information on synchronizing data from a SQL database to AD. For example, we want to synch data from the HR database to the users account.
Thanks in advance
Travis Abrams -- Tnx, Matt | | | |
| Yann Tiroa
Posts:0
| | 09/14/2005 8:22 AM |
| Hello,
Endeed, MIIS 2003 is great to sync multiple databases with each others,
but see what you REALLY need in your sync, because MIIS costs 12 000$/processor
!! We are about to buy it 'cause we have to sync lots databases with AD, and we
need complex codes in our environnement: miis works with vb.net and c#
code.
If you tend to use MIIS *ONLY* to sync MSSQL -> AD, with light codes,
i think it is better to use other scripts that can connect to SQL,
dump the users, and create/update them in AD.
Regards,
Yann
De : ActiveDir-owner@xxxxxxxxxxxxxxxxxx
[mailto:ActiveDir-owner@xxxxxxxxxxxxxxxxxx] De la part de
MattEnvoyé : mercredi 14 septembre 2005 04:13À :
ActiveDir@xxxxxxxxxxxxxxxxxxObjet : Re: [ActiveDir]
Synchronizing AD
You could use MIIS (http://www.microsoft.com/windowsserversystem/miis2003/default.mspx) which is a fully functional
meta-directory solution from Microsoft or there is another tool called
SimpleSync (http://www.cps-systems.com/simplesync/) which
I believe will provide you simpler but similiar
functionality. I prefer to use MIIS however it is costly, and
perhaps overly complex for your particular situation.
On 9/13/05, travis.abrams@xxxxxxxxx travis.abrams@xxxxxxxxx> wrote:
Does anyone have any recommendations on products or
information on synchronizing data from a SQL database to AD. For example, we
want to synch data from the HR database to the users account.
Thanks in advance
Travis Abrams --
Tnx, Matt | | | |
|
|