DBSync

Database to IAM Synchronization Platform

Java 21 Spring Boot 4.0.1 React 18.2.0 TypeScript Multi-Database

Business Value Proposition

⚡ 90% Faster Onboarding

Eliminate manual user provisioning with automated identity synchronization

💰 Cost Savings

Replace expensive ETL tools with lightweight, purpose-built solution

🔒 Security Compliance

Ensure IAM systems reflect real-time database state for access control

📊 Audit Readiness

Complete execution history and metrics for compliance reporting

Automate identity management with 219 tests (100% passing) and production-ready reliability

Problem: HR database changes don't sync to IAM systems, causing security gaps and manual provisioning delays

Solution: Enterprise synchronization platform connecting PostgreSQL, MySQL, Oracle, SQL Server to IAM systems via REST APIs with scheduled jobs and full audit trails

Use Cases & Target Markets

🏢 Enterprise IT & Security

Problem: HR database changes don't sync to IAM systems, causing security gaps

Solution: Scheduled sync jobs automatically provision/deprovision users in real-time

ROI: Reduce security incidents by 60%, eliminate orphaned accounts

☁️ SaaS Platforms

Problem: Customer data in PostgreSQL needs to sync to Okta/Azure AD for SSO

Solution: Multi-database support with granular create/update/delete controls

ROI: Automate customer onboarding, reduce support tickets by 40%

🏥 Healthcare Systems

Problem: Patient management systems need to sync with access control systems

Solution: HIPAA-compliant sync with audit trails and execution monitoring

ROI: Ensure only authorized staff access patient records

🏦 Financial Services

Problem: Employee database changes must reflect in IAM within minutes for compliance

Solution: Cron-based scheduling with connection testing and validation

ROI: Meet regulatory requirements, reduce manual IAM administration by 80%

🌐 Multi-Cloud Enterprises

Problem: Synchronize user data across Oracle, SQL Server, MySQL to multiple IAM targets

Solution: Multi-database, multi-IAM support with REST API automation

ROI: Unified identity management across hybrid cloud environments

Technical Architecture

Core Components

🗄️ Database Connectivity Layer

  • Multi-Database Support: PostgreSQL, MySQL, Oracle, SQL Server
  • Connection Pooling: HikariCP for high-performance
  • Connection Testing: Validate before saving configurations
  • JDBC Abstraction: Unified interface for all database types

⏰ Scheduling Engine

  • Cron Scheduling: Standard cron expressions
  • Fixed-Delay Scheduling: Interval-based execution
  • Job Execution Monitoring: Track status, timing, metrics
  • Execution History: Complete audit trail of all job runs

🔐 IAM Integration Layer

  • REST API Integration: Connect to any IAM system
  • API Key Authentication: Secure authentication
  • Behavior Configuration: Granular create/update/delete control
  • Connection Testing: Validate IAM connectivity

⚙️ Configuration Management

  • YAML Configuration: File-based with hot-reload
  • Web UI: React TypeScript frontend
  • REST API: Comprehensive CRUD operations
  • Real-time Validation: Instant feedback on errors

📊 Monitoring & Observability

  • Job Execution Dashboard: Monitor job runs
  • System Health Monitoring: Track connectivity
  • Swagger/OpenAPI: Interactive API documentation
  • Execution Metrics: Success/failure rates, duration

Technology Stack

Backend: Spring Boot 4.0.1, Java 21
Frontend: React 18.2.0, TypeScript 4.9.5
UI Library: Material-UI (MUI) 5.15.0
Database: H2 (embedded metadata storage)
Migrations: Flyway
Documentation: SpringDoc OpenAPI 2.3.0
Testing: 219 tests (174 backend + 45 E2E)

System Requirements

Key Features

Core Functionality

✅ Multi-Database Support - PostgreSQL, MySQL, Oracle, SQL Server
✅ Scheduled Sync Jobs - Cron and fixed-delay scheduling
✅ IAM Integration - REST API integration with multiple IAM targets
✅ YAML Configuration - File-based configuration with hot-reload
✅ Connection Testing - Test database and IAM connectivity before saving
✅ Behavior Configuration - Granular control over create/update/delete operations
✅ Job Execution Monitoring - Track job status, metrics, and execution history

User Interface

✅ React TypeScript Frontend - Modern Material-UI components
✅ Configuration Management - Web-based UI for databases, IAM, and jobs
✅ Job Execution Dashboard - Monitor job runs with status, timing, and metrics
✅ Real-time Validation - Instant feedback on configuration errors
✅ Responsive Design - Works on desktop, tablet, and mobile

API & Documentation

✅ REST API - Comprehensive CRUD operations for all resources
✅ Swagger/OpenAPI - Interactive API documentation at /swagger-ui.html
✅ API Contract Tests - Automated testing of API specifications

Testing & Quality

✅ 219 Total Tests - 100% passing (174 backend + 45 E2E)
✅ SonarCloud Integration - Automated code quality scanning on every PR
✅ Quality Gate - Enforced code quality standards
✅ Coverage Tracking - JaCoCo (backend) + LCOV (frontend)

Performance Metrics

219
Tests (100% Passing)
90%
Faster Onboarding
80%
Reduced Manual Work
4
Database Types Supported

Test Coverage Breakdown

Metric Value
Total Tests 219 tests (100% passing)
Backend Unit Tests 117 tests ✅
Backend Integration Tests 57 tests ✅
Frontend E2E Tests 45 tests ✅
Code Quality SonarCloud monitored
CI/CD GitHub Actions automated

Explore DBSync

Enterprise database to IAM synchronization platform

Contact for Access View Documentation

🔒 Private repository - Contact Developers Coffee for enterprise access