ldap query to oracle virtual directory

• RJ-476420

  SSCarpal Tunnel

  Points: 4806

  More actions

  March 15, 2016 at 10:18 am

  #399865

  I have been given ldap credentials to query Oracle Virtual Directory (OVD) to download/get user lists.

  I want to integrate this into SQL Server 2008 R2/2012 as linked server and/or use it in SSIS package to get a user dump on a schedule.

  1. What is the quick way to confirm the ldap credentials work?

  2. How can I create a linked server from sql server to OVD directory services?

  3. Should I use powershell from ssis package to read the OVD directory services? If possible any sample scripts available?

  Given ldap credentials:

  ==============

  I confirmed my server can talk to source OVD server using the telnet command: "telnet stage.name.com 636"

  Host name: stage.name.com

  Port : 636

  Base DN : DC=abcxyz,DC=name,DC=com

  Username : cn=xyzUser,ou=People,dc=asc1,dc=com

  Pwd: Password1$

  Thanks.