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:
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.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.