Use the SSIS Integration Toolkit for Directory Services to manage your Active Directory, Azure Active Directory, LDAP, and Google Directory data.

The toolkit is a high-performance, easy-to-use, cost-effective data integration solution utilizing Microsoft SQL Server Integration Services (SSIS) capabilities for various integration needs. With this toolkit, businesses can effectively automate their directory services processes.

Directory Services Data Integration

  • High-performing data integration for LDAP, Active Directory, and Google Directory services using SSIS.
  • Support of various Graph API service endpoints in facilitating the reading or writing of Azure Active Directory data.
  • Immersive development productivity thanks to the easy learning curve and familiar development experience using Microsoft Visual Studio.
  • Easily manage a massive number of Users and Groups in your directory services.
  • Maintain User's Group memberships effortlessly.
  • Read and write to various Directory attributes including custom and array attributes from Users and Groups.
  • Disable or enable a massive number of User accounts instantly.
  • Built-in search function so developers can quickly find the fields required.
  • Powered by modern cryptography and authentication technologies for secure connections, such as TLS 1.2, OAuth2, SHA-256, etc.
  • Synchronize user account information with virtually any external data source that SSIS can read/write to including Microsoft Dynamics, SharePoint, and any other components available in KingswaySoft's Ultimate Edition.
Data Integration for Active Directory

Unique Features


  • A much-simplified connection manager makes it easy to communicate with your preferred directory services.
  • Read user, group, and computer record data with support for custom fields.
  • Support of using Search Criteria to filter data in LDAP filtering format.
  • Capability to specify container path to narrow your search scope.
  • Active Directory Destination Component supports 5 different write actions: Create, Update, Upsert, Move, and Delete.
  • Active Directory Destination Component supports massive data manipulation of the following objects.
    • User - Create, update, or delete active directory users.
    • Group - Create, update, or delete active directory groups.
    • GroupMembership - Add users to, or remove users from active directory groups.

Technical Requirements


  • Any of the following directory services
    • Microsoft Active Directory, either Active Directory (On-Premises), or, Azure Active Directory (on the cloud).
    • Any LDAP-compatible directory services
    • Google Directory
  • SQL Server Integration Services, either:
    • Azure-SSIS Integration Runtime,
    • Microsoft SQL Server 2022,
    • Microsoft SQL Server 2019,
    • Microsoft SQL Server 2017,
    • Microsoft SQL Server 2016,
    • Microsoft SQL Server 2014,
    • Microsoft SQL Server 2012,
    • Microsoft SQL Server 2008 R2, or,
    • Microsoft SQL Server 2008.

Active Directory SSIS Components

Active Directory SSIS Components

  • The Active Directory Connection Manager facilitates connection to Active Directory and Azure Active Directory
  • The Active Directory Source Component allows you to read data from Microsoft Active Directory.
  • The Active Directory Destination Component facilitates writing data to Microsoft Active Directory.
  •  See this component's documentation.

Google Directory SSIS Components

  • The Google Directory Connection Manager facilitates connection to Google Directory.
  • The Google Directory Source Component allows you to read data from Google Directory.
  • The Google Directory Destination Component facilitates writing data to Google Directory.
  •  See this component's documentation.

Google Directory SSIS Components

LDAP SSIS Components

LDAP SSIS Components

  • The LDAP Connection Manager facilitates establishing connections with LDAP servers.
  • The LDAP Source Component allows you to read data from LDAP directories, seamlessly integrating with other SSIS tasks and data flows.
  • The LDAP Destination Component facilitates writing data to LDAP directories.
  •  See this component's documentation.

Case Study


The Avon Maitland District School Board implemented an automated system to update their Active Directory. This system promptly reflects any student or employee changes within the board, eliminating the need for manual notifications. As a result, staff and students experience reduced delays, and the overall efficiency of operations was significantly increased.

 Read the case study

Avon Maitland District School Board - logo

Codeless
Integration

You don't have to write a single line of code to make data integration happen so your development can be done in a matter of minutes.

Flexible and
Easy-to-use

We make the most flexible integration solution on the market. Our software offers intuitive user interfaces that are flexible and easy to use.

Cost
Effective

With a streamlined development experience and an extremely simple licensing model, our solution offers the best value for your investment.

Unparalleled
Performance

Our software offers many specifically designed features that help you achieve the best possible performance without having to hijack your budget.