Active Directory
Data Integration

via SSIS Integration Toolkit for Directory Services

Integrate Active Directory data with any other application or data source including Microsoft Dynamics 365, QuickBooks, HubSpot, and Salesforce, to name just a few.

  Download   Purchase 

kingswaysoft data integration made easy

What other applications can you sync with Active Directory?
Click here for more solutions.

Synchronize Data

Easily pull data from Active Directory to your ERP, CRM or any other application so information is always up-to-date. Capture data across applications so your business operates with the latest information on hand.

kingswaysoft data integration made easy
kingswaysoft data integration made easy

Automate Business Processes

Streamline business processes by eliminating the need for repetitive work. When successful numbers roll in from an ad campaign, automatically send the necessary information to appropriate applications and allow those applications to communicate directly with other systems without the need for manual processing.

Replicate Data

kingswaysoft data integration made easy

Data Archival

Easily replicate data from Active Directory for data archival and warehousing requirements.

kingswaysoft data integration made easy

Data Analytics

Easily retrieve data from Active Directory so it is available for your choice BI and Analytics platform.

Active Directory Data Integration
is available in the
SSIS Integration Toolkit for Directory Services

DownloadPurchaseData Sheet

Unique Features

  • 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.
  • Retrieve data from Active Directory with several advanced filtering capabilities for further data retrieval refinement.
  • 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.
  • 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.
  • 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.
    • Group Membership - Add users to, or remove users from active directory groups.

Technical Requirements

  • Microsoft Active Directory, either:
    • Active Directory (On-Premise), or,
    • Azure Active Directory (Cloud).
  • 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

Active Directory Data Integration Made Easy

Our solution is easy to use, offering code-less integration between Active Directory and virtually any other application or database system. Our solution is built utilizing Microsoft SQL Server Integration Services (SSIS), a performant and flexible ETL platform, allowing your team to take advantage of the technologies and skills they already have. The drag-and-drop user interface makes it easy to set up powerful integration within a matter of minutes.

Our Active Directory integration solution is available within the SSIS Integration Toolkit for Directory Services and the SSIS Integration Toolkit Ultimate Edition, our largest collection of premium and unique ETL tools that allows you to download the SSIS Productivity Pack and any of our 14 SSIS Integration Toolkit, such as Microsoft Dynamics 365, Salesforce, NetSuite, and many more.

See our full product offerings for more information.


Other SSIS Directory Services Components

Our Directory Services components make it easy to integrate with different services within the ETL process. Each service available has specific components that have been developed to work with all the intricacies of that particular Directory Service solution. In addition to Active Directory, we support the following Directory Services:

Google Directory
LDAP Directory

Get In Touch

If you would like to know more specific details about our solutions, or if you have any suggestions about our product offerings, we are always here to listen and help!

Contact Us