[THIN] Re: OT-AD import from SQL
- From: "Mack, Rick" <RMack@xxxxxxxxxxxxxx>
- To: <thin@xxxxxxxxxxxxx>
- Date: Wed, 30 Jun 2004 07:52:42 +1000
Hi Pavlo,
Scripting account creation is easy enough. If you've got that info, why
not just rename all the existing accounts and save a bit of work as
well.
What do you need to get started?
Regards,
Rick
Ulrich Mack
Volante Systems Ltd
18 Heussler Terrace, Milton 4064
Queensland Australia.
Ph: +61 7 3246 7704
email: rmack@xxxxxxxxxxxxxx
web: www.volante.com.au
-----Original Message-----
From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx] On
Behalf Of Pavlo Ignatusha
Sent: Tuesday, 29 June 2004 6:02 AM
To: thin@xxxxxxxxxxxxx
Subject: [THIN] Re: OT-AD import from SQL
Well,
I just looked on MIIS and it costs 25K... This is way over the price I
expected for this kind of product.
Getting back to my layout I have badge ID, full name and Department to
take from HR database. These will go to AD fields: username, display
name (possible fist and last names as well) and Department.
you commenta are very appreciated,
Pavlo Ignatusha
Systems and Network Coordinator
Pembroke General Hospital
Tel. (613) 732-3675 ext.6150
Fax. (613) 732-9986
www.pemgenhos.org
"All that matters is love and work" - Sigmund Freud.
-----Original Message-----
From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx]On
Behalf Of Braebaum, Neil
Sent: Monday, June 28, 2004 10:59 AM
To: thin@xxxxxxxxxxxxx
Subject: [THIN] Re: OT-AD import from SQL
Then you appear to have a number of options:-
1. Export from your SQL database, doctor the file, either manually, or
scripted, then import it (using LDFIDE or CSVDE) into AD. 2. Write
something to do it sorta dynamically (ie read from SQL, then create in
AD) on demand.
The other thing to consider is that LDIFDE and CSVDE allow you to kinda
change some details as you use them.
What "schema" differences are there between what you have in SQL, and
what you want in AD?
Neil
> -----Original Message-----
> From: thin-bounce@xxxxxxxxxxxxx
> [mailto:thin-bounce@xxxxxxxxxxxxx] On Behalf Of Pavlo Ignatusha
> Sent: 28 June 2004 15:40
> To: thin@xxxxxxxxxxxxx
> Subject: [THIN] Re: OT-AD import from SQL
>
>
> Neil,
>
> Yes, I'm looking into possible exporting things into file
> (like csv) and the process it to create AD accounts.
>
> The idea is to have logon name to be the badge number which
> means field names in SQL and and AD won't match.
>
> ADMT seems to work only with NT SAM database (on the first
> glance). MIIS suggested by Mark is a bit too big as it needs
> W3K and SQL Enterprise. We are W2K domain and SQL Standard Edition.
>
> -----Original Message-----
> From: thin-bounce@xxxxxxxxxxxxx
> [mailto:thin-bounce@xxxxxxxxxxxxx]On Behalf Of Braebaum, Neil
> Sent: Monday, June 28, 2004 10:13 AM
> To: thin@xxxxxxxxxxxxx
> Subject: [THIN] Re: OT-AD import from SQL
>
> I know you have very general kind of requirements at the
> moment, but are you talking about something extracting the
> relevant from SQL, then doing the necessary in AD?
>
> Or something working from an export from SQL, then creating
> records in AD?
>
> There's LDIF for dealing with export / imports to AD, but
> then you'd expect some kinda conformity with fields.
>
> Otherwise, you're perhaps looking at either working from
> export details
> - in which case the native export might be usable - or maybe
> you'd have to tinker with that first.
>
> It would be possible to script this - you can certainly
> interface with SQL, then you could script something to do the
> necessarily in AD.
>
> The only automated creation of stuff I've done in AD (in
> terms of bespoke, written things myself) is for computer
> objects - which actually is very similar, because you have to
> do much the same thing - create accounts.
>
> I think you need to firm up how you want it to work, first.
>
> On the other hand, there may well be commercial products that
> fit the bill - as well as perhaps ADMT.
>
> Neil
>
> > -----Original Message-----
> > From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx]
> > On Behalf Of Pavlo Ignatusha
> > Sent: 28 June 2004 15:03
> > To: Org Thin (E-mail)
> > Subject: [THIN] OT-AD import from SQL
> >
> > Hi group,
> >
> > Sorry for off-topic post.
> >
> > We are thinking to change user logons to their badge ID numbers. The
> > badge number, full name and Department is generated by payroll SQL
> > database. We would like to get a regular export from this SQL
> > database into Active Directory so new user accounts will be created
> > as soon as the payroll db is updated. So far we are not looking for
> > complete automated solution. It will be enough if the user account
> > in AD will be generated and user object be dropped into a certain
> > OU.
> >
> > If somebody can recommend a program to do this it would be awesome.
> > I'm not too good with scripting but if someone supply a link to a
> > sample script I'll probably make my way through it as well.
> >
> > Your help is very appreciated.
***********************************************
This e-mail and its attachments are confidential
and are intended for the above named recipient
only. If this has come to you in error, please
notify the sender immediately and delete this
e-mail from your system.
You must take no action based on this, nor must
you copy or disclose it or any part of its contents
to any person or organisation.
Statements and opinions contained in this email may
not necessarily represent those of Littlewoods.
Please note that e-mail communications may be monitored.
The registered office of Littlewoods Limited and its subsidiaries is 100
Old Hall Street, Liverpool, L70 1AB. Registered number of Littlewoods
Limited is 262152.
************************************************
********************************************************
This weeks sponsor Emergent Online Thinssentials Utilities Using the
latest software, hardware, networking technologies, proven technical
expertise, proprietary software and best practices, EOL provides
custom-tailored solutions for each clients mission and specific goals.
http://www.go-eol.com
**********************************************************
Useful Thin Client Computing Links are available at:
http://thin.net/links.cfm
***********************************************************
For Archives, to Unsubscribe, Subscribe or
set Digest or Vacation mode use the below link:
http://thin.net/citrixlist.cfm
#####################################################################################
This e-mail, including all attachments, may be confidential or privileged.
Confidentiality or privilege is not waived or lost because this email has been
sent to you in error. If you are not the intended recipient any use,
disclosure or copying of this email is prohibited. If you have received it in
error please notify the sender immediately by reply email and destroy all
copies of this email and any attachments. All liability for direct and
indirect loss arising from this email and any attachments is hereby disclaimed
to the extent permitted by law.
#####################################################################################
********************************************************
This weeks sponsor Emergent Online Thinssentials Utilities
Using the latest software, hardware, networking technologies, proven technical
expertise, proprietary software and best practices, EOL provides
custom-tailored solutions for each client?s mission and specific goals.
http://www.go-eol.com
**********************************************************
Useful Thin Client Computing Links are available at:
http://thin.net/links.cfm
***********************************************************
For Archives, to Unsubscribe, Subscribe or
set Digest or Vacation mode use the below link:
http://thin.net/citrixlist.cfm
Other related posts:
