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.

New Connection

You will be prompted with the "Add SSIS Connection Manager" window. Select the "LDAP(KingswaySoft)" item to add the new LDAP connection manager.

LDAP Add 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 Connection manager - General

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.

LDAP Connection manager - More Info