Use SSIS Integration Toolkit for Directory Services to manage your LDAP Users and Groups. The toolkit is a cost-effective, easy-to-use and high-performance data integration solution utilizing Microsoft SQL Server Integration Services (SSIS) capabilities for the integration job. With this toolkit businesses can effectively automate their Active Directory processes.

The SSIS Integration Toolkit for Directory Services

  • High performing data integration for Active Directory using SSIS.
  • Immersive development productivity thanks to the easy learning curve and familiar development experience using Microsoft Visual Studio.
  • Easily manage massive number of Active Directory Users and Groups.
  • 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.
  • 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.

Active Directory SSIS Data Integration

  • 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 Active Directory
  • Read data from Active Directory user, group, computer records with support of any 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

  • Microsoft Active Directory
  • SQL Server
    • Microsoft SQL Server 2016
    • Microsoft SQL Server 2014
    • Microsoft SQL Server 2012
    • Microsoft SQL Server 2008 R2
    • Microsoft SQL Server 2008
    • Microsoft SQL Server 2005

Case Study

Avon Maitland District School Board - logo