Active Directory Data Integration with Microsoft Dynamics 365, WordPress, Microsoft SharePoint, Amazon Web Services, and, virtually any other application or data source that you may need to work with

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

What other applications can you integrate with data from Active Directory? Click here for more solutions.

Your Active Directory is the front line for your business and it is imperative that the system has the most up-to-date data at all times and interacts properly with your other applications to keep the entire organization running smoothly.

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

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. 

Automate Business Processes

Replicate Data

Data Archival

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

Data Analytics

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

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 REST components of our SSIS Integration Toolkit for Directory Services, a large collection of premium and unique ETL tools to enable greater development productivity. We also offer several additional connectivity solutions to easily integrate Active Directory with applications such as Microsoft Dynamics 365, HubSpot, and many more.

See our full product offerings for more information.

Other SSIS Directory Service Components

Our Directory Service 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: