| Author | Messages | |
thecoffeeguy
Posts:2
 | | 04/25/2008 7:07 PM |
| Hello everyone.
Not sure if this is possible or not, but my company is looking into the
possibility to see if we can basically pull/query information from our active
directory environment, get a list of our employees and put them into a Oracle
database table?
I've been digging around a bit and have not been able to find anything really
helpful.
Is it possible to do this with Oracle?
I would assume I would need to use specific LDAP type queries within my select
statement?
Then there are questions about how to properly connect to active directory from
a Oracle database.
Appreciate the help.
Jason
List info : http://www.activedir.org/List.aspx
List FAQ : http://www.activedir.org/ListFAQ.aspx
List archive: http://www.activedir.org/ma/default.aspx
| | | |
| bdesmond
Posts:291
| | 04/25/2008 7:22 PM |
| I'm not going to ask why, but, chances are your best bet is to schedule a
job to export a flatfile and have Oracle pick it up. The opposite works too
- write some code to do the inserts directly into oracle.
SQL supports linked servers and connecting them to AD although it is clunky.
--brian
On Fri, Apr 25, 2008 at 7:06 PM, Jason Williams <jason.williams@cox.net>
wrote:
> Hello everyone.
>
> Not sure if this is possible or not, but my company is looking into the
> possibility to see if we can basically pull/query information from our
> active
> directory environment, get a list of our employees and put them into a
> Oracle
> database table?
>
> I've been digging around a bit and have not been able to find anything
> really
> helpful.
>
> Is it possible to do this with Oracle?
> I would assume I would need to use specific LDAP type queries within my
> select
> statement?
>
> Then there are questions about how to properly connect to active directory
> from
> a Oracle database.
>
> Appreciate the help.
>
> Jason
> List info : http://www.activedir.org/List.aspx
> List FAQ : http://www.activedir.org/ListFAQ.aspx
> List archive: http://www.activedir.org/ma/default.aspx
>
--
Thanks,
Brian Desmond
brian@briandesmond.com
c - 312.731.3132
| | | |
| thecoffeeguy
Posts:2
| | 04/28/2008 11:27 AM |
| Ya, I kinda had a feeling that might be how we would need to do it.
Any suggestions or recommendations on how to go about doing that? That is, exporting the users from active directory into a file, which I can then import into a specific table in our Oracle DB?
Cheers
Jas
---- Brian Desmond <brian@briandesmond.com> wrote:
> I'm not going to ask why, but, chances are your best bet is to schedule a
> job to export a flatfile and have Oracle pick it up. The opposite works too
> - write some code to do the inserts directly into oracle.
>
> SQL supports linked servers and connecting them to AD although it is clunky.
>
> --brian
>
> On Fri, Apr 25, 2008 at 7:06 PM, Jason Williams <jason.williams@cox.net>
> wrote:
>
> > Hello everyone.
> >
> > Not sure if this is possible or not, but my company is looking into the
> > possibility to see if we can basically pull/query information from our
> > active
> > directory environment, get a list of our employees and put them into a
> > Oracle
> > database table?
> >
> > I've been digging around a bit and have not been able to find anything
> > really
> > helpful.
> >
> > Is it possible to do this with Oracle?
> > I would assume I would need to use specific LDAP type queries within my
> > select
> > statement?
> >
> > Then there are questions about how to properly connect to active directory
> > from
> > a Oracle database.
> >
> > Appreciate the help.
> >
> > Jason
> > List info : http://www.activedir.org/List.aspx
> > List FAQ : http://www.activedir.org/ListFAQ.aspx
> > List archive: http://www.activedir.org/ma/default.aspx
> >
>
>
>
> --
> Thanks,
> Brian Desmond
> brian@briandesmond.com
>
> c - 312.731.3132
List info : http://www.activedir.org/List.aspx
List FAQ : http://www.activedir.org/ListFAQ.aspx
List archive: http://www.activedir.org/ma/default.aspx
| | | |
| ZJORZ
Posts:95
| | 07/16/2008 5:28 PM |
| How about using MIIS/ILM to do what you want?
Met vriendelijke groeten / Kind regards,
Ing. Jorge de Almeida Pinto
Senior Consultant
MVP Identity & Access - Directory Services
Oxford Computer Group Benelux | O: +31 (0)6 26.26.62.80 | :: +31 (0)33 454.69.50 | : +31 (0)33 454.66.66 | : Hardwareweg 4, 3821BM Amersfoort, The Netherlands
www.oxfordcomputergroup.com | Expertise in Identity & Access Management
________________________________________________________________
MVP Profile → https://mvp.support.microsoft.com/profile/jorge1
MVP Home Site → https://mvp.support.microsoft.com/
MVP Overview → https://mvp.support.microsoft.com/mvpexecsum
BLOG → http://blogs.dirteam.com/blogs/jorge/default.aspx
________________________________________________________________
-----Original Message-----
From: ActiveDir-owner@mail.activedir.org [mailto:ActiveDir-owner@mail.activedir.org] On Behalf Of Jason Williams
Sent: Saturday, April 26, 2008 01:06
To: ActiveDir@mail.activedir.org
Subject: [ActiveDir] Pull Active Directory data into a Database table
Hello everyone.
Not sure if this is possible or not, but my company is looking into the
possibility to see if we can basically pull/query information from our active
directory environment, get a list of our employees and put them into a Oracle
database table?
I've been digging around a bit and have not been able to find anything really
helpful.
Is it possible to do this with Oracle?
I would assume I would need to use specific LDAP type queries within my select
statement?
Then there are questions about how to properly connect to active directory from
a Oracle database.
Appreciate the help.
Jason
List info : http://www.activedir.org/List.aspx
List FAQ : http://www.activedir.org/ListFAQ.aspx
List archive: http://www.activedir.org/ma/default.aspx
.+-� 0�����j�q.+-� 0����ˊ�E��Kj�!i�b��b����ןj�m | | | |
| bsonposh
Posts:149
| | 07/16/2008 5:28 PM |
| | This would be pretty simple with Powershell as well as it can easily get the
info from AD and directly input it into your DB.
If you interested let me know and I will get you going.
On Wed, May 14, 2008 at 9:38 PM, Jorge de Almeida Pinto <
Jorge.deAlmeidaPinto@oxfordcomputergroup.com> wrote:
> How about using MIIS/ILM to do what you want?
>
> Met vriendelijke groeten / Kind regards,
>
> Ing. Jorge de Almeida Pinto
> Senior Consultant
> MVP Identity & Access - Directory Services
>
> Oxford Computer Group Benelux | O: +31 (0)6 26.26.62.80 | :: +31 (0)33
> 454.69.50 | : +31 (0)33 454.66.66 | : Hardwareweg 4, 3821BM Amersfoort,
> The Netherlands
> www.oxfordcomputergroup.com | Expertise in Identity & Access Management
> ________________________________________________________________
> MVP Profile → https://mvp.support.microsoft.com/profile/jorge1
> MVP Home Site → https://mvp.support.microsoft.com/
> MVP Overview → https://mvp.support.microsoft.com/mvpexecsum
> BLOG → http://blogs.dirteam.com/blogs/jorge/default.aspx
> ________________________________________________________________
>
> -----Original Message-----
> From: ActiveDir-owner@mail.activedir.org [mailto:
> ActiveDir-owner@mail.activedir.org] On Behalf Of Jason Williams
> Sent: Saturday, April 26, 2008 01:06
> To: ActiveDir@mail.activedir.org
> Subject: [ActiveDir] Pull Active Directory data into a Database table
>
> Hello everyone.
>
> Not sure if this is possible or not, but my company is looking into the
> possibility to see if we can basically pull/query information from our
> active
> directory environment, get a list of our employees and put them into a
> Oracle
> database table?
>
> I've been digging around a bit and have not been able to find anything
> really
> helpful.
>
> Is it possible to do this with Oracle?
> I would assume I would need to use specific LDAP type queries within my
> select
> statement?
>
> Then there are questions about how to properly connect to active directory
> from
> a Oracle database.
>
> Appreciate the help.
>
> Jason
> List info : http://www.activedir.org/List.aspx
> List FAQ : http://www.activedir.org/ListFAQ.aspx
> List archive: http://www.activedir.org/ma/default.aspx
>
| | | |
| michael1
Posts:148
| | 07/16/2008 5:30 PM |
| Here is a robust platform agnostic database layer in PowerShell:
http://theessentialexchange.com/blogs/michael/archive/2008/01/27/DML-with-PS_2C00_-Part-3.aspx
Regards,
Michael B. Smith
MCSE/Exchange MVP
http://TheEssentialExchange.com
From: ActiveDir-owner@mail.activedir.org [mailto:ActiveDir-owner@mail.activedir.org] On Behalf Of Brandon Shell
Sent: Wednesday, May 14, 2008 10:28 PM
To: ActiveDir@mail.activedir.org
Subject: Re: [ActiveDir] Pull Active Directory data into a Database table
This would be pretty simple with Powershell as well as it can easily get the info from AD and directly input it into your DB.
If you interested let me know and I will get you going.
On Wed, May 14, 2008 at 9:38 PM, Jorge de Almeida Pinto <Jorge.deAlmeidaPinto@oxfordcomputergroup.com> wrote:
How about using MIIS/ILM to do what you want?
Met vriendelijke groeten / Kind regards,
Ing. Jorge de Almeida Pinto
Senior Consultant
MVP Identity & Access - Directory Services
Oxford Computer Group Benelux | O: +31 (0)6 26.26.62.80 <http://26.26.62.80/> : +31 (0)33 454.66.667| :: +31 (0)33 454.69.50 | | : Hardwareweg 4, 3821BM Amersfoort, The Netherlands
www.oxfordcomputergroup.com <http://www.oxfordcomputergroup.com/> | Expertise in Identity & Access Management
________________________________________________________________
MVP Profile → https://mvp.support.microsoft.com/profile/jorge1
MVP Home Site → https://mvp.support.microsoft.com/
MVP Overview → https://mvp.support.microsoft.com/mvpexecsum
BLOG → http://blogs.dirteam.com/blogs/jorge/default.aspx
________________________________________________________________
-----Original Message-----
From: ActiveDir-owner@mail.activedir.org [mailto:ActiveDir-owner@mail.activedir.org] On Behalf Of Jason Williams
Sent: Saturday, April 26, 2008 01:06
To: ActiveDir@mail.activedir.org
Subject: [ActiveDir] Pull Active Directory data into a Database table
Hello everyone.
Not sure if this is possible or not, but my company is looking into the
possibility to see if we can basically pull/query information from our active
directory environment, get a list of our employees and put them into a Oracle
database table?
I've been digging around a bit and have not been able to find anything really
helpful.
Is it possible to do this with Oracle?
I would assume I would need to use specific LDAP type queries within my select
statement?
Then there are questions about how to properly connect to active directory from
a Oracle database.
Appreciate the help.
Jason
List info : http://www.activedir.org/List.aspx
List FAQ : http://www.activedir.org/ListFAQ.aspx
List archive: http://www.activedir.org/ma/default.aspx
| | | |
| lists1
Posts:4
| | 07/16/2008 5:40 PM |
| I've done this with SQL - AD as a linked server and create a view which exposes the attributes you need. I doubt Oracle will be able to do this, however if you also have a SQL-Server sitting somewhere you might be able to query Oracle against SQL against AD 
Gruesse - Sincerely,
Ulf B. Simon-Weidner
Profile & Publications: https://mvp.support.microsoft.com/profile/simon-weidner
Weblog: http://msmvps.org/UlfBSimonWeidner
Website: http://www.windowsserverfaq.org
> -----Original Message-----
> From: ActiveDir-owner@mail.activedir.org [mailto:ActiveDir-
> owner@mail.activedir.org] On Behalf Of Jason Williams
> Sent: Samstag, 26. April 2008 01:06
> To: ActiveDir@mail.activedir.org
> Subject: [ActiveDir] Pull Active Directory data into a Database table
>
> Hello everyone.
>
> Not sure if this is possible or not, but my company is looking into the
> possibility to see if we can basically pull/query information from our
> active
> directory environment, get a list of our employees and put them into a
> Oracle
> database table?
>
> I've been digging around a bit and have not been able to find anything
> really
> helpful.
>
> Is it possible to do this with Oracle?
> I would assume I would need to use specific LDAP type queries within my
> select
> statement?
>
> Then there are questions about how to properly connect to active
> directory from
> a Oracle database.
>
> Appreciate the help.
>
> Jason
> List info : http://www.activedir.org/List.aspx
> List FAQ : http://www.activedir.org/ListFAQ.aspx
> List archive: http://www.activedir.org/ma/default.aspx
List info : http://www.activedir.org/List.aspx
List FAQ : http://www.activedir.org/ListFAQ.aspx
List archive: http://www.activedir.org/ma/default.aspx
| | | |
|
|