Using the LDAP Connection Manager
The LDAP Connection Manager is an SSIS connection manager component that can be used to establish connections with LDAP.
To add an LDAP connection to your SSIS package, right-click the Connection Manager area in your Visual Studio project and choose "New Connection..." from the context menu.
You will be prompted with the "Add SSIS Connection Manager" window. Select the "LDAP(KingswaySoft)" item to add the new LDAP connection manager.
The LDAP Connection Manager contains the following two pages to connect to your LDAP:
- General
- More Info
General Page
The General page on the LDAP Connection Manager allows you to specify the settings to build the connection with LDAP.
- LDAP Domain
-
- Server
-
The Server field lets you specify the name or address of the LDAP domain that you want to connect to.
- Port
-
The Port field lets you choose or specify the port with which you want to connect to your LDAP. The default port number is 389 which can be modified.
- Authentication
-
- Authentication Type
-
There are 10 types of authentication modes that are supported.
- Anonymous
- Basic
- Negotiate
- Ntlm
- Digest
- Sicily
- Dpa
- Man
- External
- Kerberos
- User Name (All authentication modes except Anonymous)
-
The User Name field allows you to specify the user account that you want to use to connect to your LDAP. Depending on how you want to manipulate your data, the user account needs to have proper privileges to do so.
- Password (All authentication modes except Anonymous)
-
The Password field allows you to specify the password for the above user account in order to authenticate with LDAP.
- Sessions Options
-
The Sessions Options can be chosen from the three options: Sealing, Signing, SSL.
- Certificate Validation
-
The Certificate Validation field allows you to specify the validation mechanism.
- Certificate Thumbprint
-
Allows you to specify the thumbprint of the client certificate from the Certificate Store. Click the ellipses button to browse and select a certificate for the user's store. This option is available when you choose Store as Certificate Location.
- Certificate Chooser (...)
-
Click on the ellipsis button to open the certificate choose window.
More Info Page
The More Info page shows some basic information about the toolkit. On this page, you can find the version information of the toolkit.