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.
What other applications can you sync with 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.
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.
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
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.
Active Directory Data Integration
is available in the
SSIS Integration Toolkit for Directory Services
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.
- User - Create, update, or delete active directory users.
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 2022
- Microsoft SQL Server 2019
- Microsoft SQL Server 2017
- Microsoft SQL Server 2016
- Microsoft SQL Server 2014
- Microsoft SQL Server 2012
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.
More 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: