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 the "Add SSIS Connection Manager" window. Select the "LDAP(KingswaySoft)" item to add the new LDAP connection manager.

New Connection

LDAP Add connection manager

The LDAP Connection Manager contains the following two pages to connect to your LDAP.

  • General
  • More Info  

General

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
  • Esternal
  • 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.

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