MSGraphDBSynchronizer v2025.06.06.1203

New in v2025.06.06.1203

** SQLite WAL Mode & Timestamp Improvements**

• ** SQLite WAL Mode**: Enhanced concurrent access support for Metabase and other BI tools
• ** Improved Timestamp Handling**: Proper timestamp column types across all databases for perfect sortability
• ** Smart Field Detection**: Automatic timestamp field detection by name patterns and content
• ** Performance Optimizations**: Enhanced WAL configuration with optimized cache settings
• ** Enhanced Logging**: Better visibility into column type assignments and database operations

Database Compatibility & BI Tools

SQLite WAL Mode enables concurrent access for business intelligence tools:

• Metabase: Connect directly to SQLite database while service is running
• Grafana: Real-time dashboards with SQLite data source
• Power BI: Import data without service interruption
• Tableau: Live connections supported

Timestamp Handling ensures proper sorting across all databases:

• SQLite: \DATETIME\ columns with ISO 8601 format
• PostgreSQL: \TIMESTAMPTZ\ columns with timezone support
• MSSQL: \DATETIME2\ columns with high precision

Installation

1. Download the appropriate binary for your platform
2. Extract the archive
3. Configure \config.json\ with your settings
4. Run the binary

What's Changed

• Enhanced SQLite WAL mode configuration with performance optimizations
• Improved timestamp column type detection and normalization
• Smart field name detection for automatic timestamp handling
• Better concurrent access support for BI tools
• Enhanced logging for database operations

Full Changelog: https://github.com/gracesolutions/MSGraphDBSynchronizer/compare/v2.0.0...v2025.06.06.1203

MSGraphDBSynchronizer v2025.06.06.0204

MSGraphDBSynchronizer v2025.06.06.0204

🆕 New Features

Dynamic Endpoint Support

• 🎯 Configurable Object Counts: Individual mockObjectCount settings for each endpoint
• 📊 Per-Endpoint Data: Realistic mock data generation tailored to each endpoint type
• 🔧 Automatic Schema Evolution: Dynamic table creation and column mapping based on endpoint data
• 📱 Serial Number Device Names: Real-world device naming using manufacturer-specific serial numbers
• ⏰ Timestamp Versioning: Proper yyyy.MM.dd.HHmm format for build tracking

Enhanced Mock Data Quality

• 👥 Users: Realistic names, departments, job titles, and email addresses
• 🏢 Groups: Security, Distribution, Microsoft 365, and Dynamic groups with proper settings
• 💻 Devices: Enterprise-grade device data with proper serial number formats
• 🔗 Relationships: Proper data relationships between endpoints

✅ Core Features

• 🔄 Microsoft Graph Integration: Sync any Graph API endpoint with OAuth2 authentication
• 🌐 Multi-Endpoint Support: Sync devices, users, groups, compliance policies, and custom endpoints
• 🎛️ Advanced OS Filtering: Wildcard support with case-insensitive substring matching
• 💾 Multi-Database Support: SQLite, PostgreSQL, and MSSQL backends with automatic schema creation
• 📊 Prometheus Metrics: Comprehensive monitoring and observability
• 🖥️ Cross-Platform: Native binaries for Windows, Linux, and macOS
• 🛠️ Service Management: Windows service, systemd, and launchd support
• ⚙️ Flexible Configuration: JSON config with environment variable overrides
• 🚦 Rate Limiting: Intelligent API rate limiting with exponential backoff retry logic
• 🧪 Mock API: Complete Graph API simulation for testing and development

📦 Installation

1. Download the release package for your platform
2. Extract the ZIP file
3. Edit config.json with your Azure app credentials
4. Run: MSGraphDBSynchronizer.exe run

🚀 Quick Start

{
  "clientId": "your-azure-client-id",
  "clientSecret": "your-azure-client-secret", 
  "tenantId": "your-azure-tenant-id",
  "endpoints": {
    "endpoints": [
      {
        "name": "Devices",
        "enabled": true,
        "mockObjectCount": 30000
      },
      {
        "name": "Users", 
        "enabled": true,
        "mockObjectCount": 5000
      },
      {
        "name": "Groups",
        "enabled": true,
        "mockObjectCount": 1000
      }
    ]
  },
  "mockGraphApi": {
    "enabled": true
  }
}

📊 Performance

• 32,000+ objects processed efficiently across multiple endpoints
• Enterprise-scale mock data generation
• Real-time sync with rate limiting and retry logic
• Automatic schema creation and evolution

🔧 Service Management

# Install Windows service
MSGraphDBSynchronizer.exe install

# Start service
MSGraphDBSynchronizer.exe start

# Check status
MSGraphDBSynchronizer.exe status

📈 Monitoring

Access Prometheus metrics at: http://localhost:9898/metrics

📚 Documentation

• Repository: https://github.com/Grace-Solutions/MSGraphDBSynchronizer
• License: GPL-3.0
• Support: GitHub Issues

---

Full Changelog: v2025.06.02.2230...v2025.06.06.0204