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.