https://store-images.s-microsoft.com/image/apps.60301.edb35cee-b774-486d-8855-a0c7d5d1ab64.21090e1b-2f87-4025-90d8-c3722d58a73f.6f02e46b-2fbd-4fab-9abb-0bfcb5fc9a29

IBM iSeries DB2 (AS/400) Sync with AD, Entra ID (IBM i on Power Systems)

by Aquera, Inc

Real-Time, Bidirectional, Automated Provisioning: IBM i DB2 AS/400 with Active Directory (AD), Entra

Microsoft Recognizes Aquera as Strategic Alliance Partner:
Microsoft features Aquera as strategic partner for HR-driven identity integration with Active Directory (AD) and Entra ID, and sync with 900+ non-Gallery business apps.
Microsoft Entra with Aquera: Identity Lifecycle Management at Scale:
Microsoft recognizes Aquera for HR-driven identity sync between Entra ID (Azure AD) and HCM, embedding identity context throughout the employee lifecycle to reduce risk.
Gartner Designates Aquera "Cool Vendor" (2022) in Identity-First Security; and Specialists (2024) in “Identity data integration" and "SCIM gateway".
Bi-directional Automated Sync: Cloud, On-Prem, Hybrid:
The Aquera IBM iSeries AS/400 DB2 (DB2) Sync Bridge to AD and Entra ID synchronizes user accounts bidirectionally in DB2 to Active Directory (AD) on-prem, AD/Entra ID hybrid, and pure Entra ID cloud. When only AD is used, the Aquera Sync Bridge syncs users directly from HR systems or from AD directories into DB2. Additionally, for Entra ID Identity Governance and Administration (IGA), the Aquera Sync Bridge retrieves user entitlements from DB2 and imports to Entra ID when supported in Entra.
Trusted by 1,000+ Customers:
Over 1,000 market-leading innovators have deployed Aquera. For other apps, Aquera SCIM Gateway for Entra ID synchronizes user data for consistent and unified identity throughout your HR and other IT systems.
✅ See IBM DB2.
✅ See also Microsoft API-driven Inbound Provisioning and HR-to-Target App provisioning.
Key Benefits:

Centralized Identity Management: Enables AD/Entra ID to serve as the single source of truth for identities, ensuring consistent user access across modern and mainframe environments.
Provision and De-Provision Users in Real-Time: Automates the creation, removal, and update of DB2 accounts when users are added, removed, or updated from AD or Entra ID groups.
Improved Security and Compliance: Centralizes security policy enforcement, including password complexity and multi-factor authentication (MFA), across systems. Mitigates the risk of orphaned accounts in DB2, ensuring regulatory compliance.
Enhanced Operational Efficiency: Avoids manual account synchronization between AD/Entra ID and DB2. Reduces administrative overhead by automating identity lifecycle management.
Configure Data Syncs, Custom Fields: Configure granular user data sync between DB2 and AD, Entra ID, including custom fields.
Auto-Correlate Records: Cleaned mismatches.

Key Features:
Hybrid; Separate Sync: Cloud-only users to Entra ID; others to On-Prem AD only, or both.
Bi-directional Sync: DB2 user sync with AD/Entra ID.
Unique Matching: Name conflict resolution to distinctly identify and consolidate user identity.
Critical Attributes: Sync Principal Name (UPN), Distinguished Name (DN), SAM Account Name.
Custom Attributes: Sync any extended attributes for your business process.
Attribute Import from any application.
Groups: Sync DB2 users, roles and privileges with Microsoft Security Groups, 365 Groups, Distribution Groups (email distribution lists) to control access in AD/Entra ID.
Multi-directory, Multi-region user sync for local, regional, and global regulatory compliance.
Access Rights: Direct, Group, Rule-based, and External authority assignment.
Global Address List to enhance collaboration.
Password Delivery efficiency, SSPR.
Hierarchy Generation: Auto-generation of management hierarchy in AD/Entra ID.

At a glance

https://store-images.s-microsoft.com/image/apps.24033.edb35cee-b774-486d-8855-a0c7d5d1ab64.feceb146-3b47-4d2f-9dfa-ed669746d5bf.b176ebe7-db62-436a-865f-d0b6c85790b3
/staticstorage/linux/20250201.1/assets/videoOverlay_7299e00c2e43a32cf9fa.png
https://store-images.s-microsoft.com/image/apps.44421.edb35cee-b774-486d-8855-a0c7d5d1ab64.21090e1b-2f87-4025-90d8-c3722d58a73f.4074fb1c-80a7-4d6b-86bd-13bc35bb3507
https://store-images.s-microsoft.com/image/apps.60127.edb35cee-b774-486d-8855-a0c7d5d1ab64.21090e1b-2f87-4025-90d8-c3722d58a73f.98fdd551-f331-4c76-bdfc-c2bb7251a069
https://store-images.s-microsoft.com/image/apps.49808.edb35cee-b774-486d-8855-a0c7d5d1ab64.21090e1b-2f87-4025-90d8-c3722d58a73f.aeb4aa5f-8987-40fa-830a-4820ec43346f
https://store-images.s-microsoft.com/image/apps.498.edb35cee-b774-486d-8855-a0c7d5d1ab64.21090e1b-2f87-4025-90d8-c3722d58a73f.de26a4b9-e24a-495b-8221-4bc740efda31
https://store-images.s-microsoft.com/image/apps.24599.edb35cee-b774-486d-8855-a0c7d5d1ab64.21090e1b-2f87-4025-90d8-c3722d58a73f.9bfdc1a7-0dd4-495f-a730-f0cb127d0e6b