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


Directory Services 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

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.

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.

Directory Services SSIS Components


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.