Our organization uses Sun Java System Directory 6.3. I'm trying to import several user attributes from this Sun Directory to our data warehouse (SQL Server 2012) on a nightly basis however I'm running into some issues, I can never successfully connect to this LDAP via the SQL Server Management Studio or via Visual Studio while trying to build a SSIS package. I know that its something I'm overlooking, because I can successfully connect to this LDAP using Apache Directory Studio using both Anonymous and Simple authentication using a service account our identity management group setup I'm just not having any luck connecting to it via T-SQL or via an SSIS package. I know it is specific to using Sun Java System Directory as a source because if I try all four of the below mentioned methods against a sandbox Windows Active Directory they all work as great. So far I have tried:
- Using a linked server from within SSMS and querying LDAP with T-SQL - http://www.pawlowski.cz/2011/04/querying-active-directory-sql-server-t-sql/
- Using the LDAP SSIS Source Component - http://adssis.codeplex.com/
- Using a VB.NET script as a source - http://stackoverflow.com/questions/14927161/how-to-populate-an-sql-server-table-with-users-information-from-active-directory
- Setting up an OLE DB connection manager using the Native OLE DB/OLE DB Provider for Microsoft Directory Services - http://social.technet.microsoft.com/wiki/contents/articles/1293.processing-active-directory-information-in-ssis.aspx
Any thoughts on how I can successfully use this Sun Java System Directory as a source?
- Edited by RJ454ME Saturday, August 03, 2013 11:47 PM
Basically you need driver to sit between SSIS (or for that matter you can consider SQL As well) and Java based AD because SSIS can not understand what is sored and how is stored in AD.
If they provide driver you can try creating odbc connection or test connection using UDL (create text file and rename it from .txt to .udl) if connection works from there then it should work from anywhere if you provide right set of values.