Use SSIS Integration Toolkit for Directory Services to manage your LDAP User, Group, and Group Membership 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 need. With this toolkit businesses can effectively automate their Active Directory processes.

Active Directory Data Integration

  • High performing data integration for LDAP, Active Directory, Azure Active Directory and Google Directory services using SSIS.
  • Support of various Graph API service endpoints in facilitating 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 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 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

  • fill

    Codeless Integration

    You do not have to write a single line of code
    to make data integration happen; your development
    can be done in a matter of minutes, which would
    otherwise take weeks or even months

    Unparalleled Performance

    Our software offers many specifically designed
    features that help you achieve the best possible
    data integration performance, while rescuing your
    IT budget

    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 a simplified licensing model, our solution
    offers the best value for your investment

  • fill

    KingswaySoft continues to offer us excellent service
    and support for our AD/HRIS integration system.
    Their knowledge and customer service is top notch.

    Jason Hillier Manager of Information Technology, Avon Maitland District School Board
  • fill

    Upsert Support

    Creates a new record or updates an existing record if it already exists

Unique Features

  • A much simplified connection manager makes it easy to communicate with your favorite directory services.
  • Read user, group, computer record data with support of 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.

Active Directory SSIS Components

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

Case Study

Avon Maitland District School Board - logo