DMS Data Migration Studio

Agentic Data Migration & Replication Platform — 163 Connectors, 16 AI Agents, 8 Skills, 25B+ Row Scale, AU & NZ Market Compliance
163
Connectors
16
AI Agents
8
Skills
5
CDC Methods
25B+
Row Capacity
99.32%
Data Fidelity
Validated across 74,420 accounts and $6.43B — 99.32% exact dollar match between source and target systems (Genesis BCT, Jul 2026). Per-account cutoff methodology.
768+
Tests
AU+NZ
Markets
Full AU market compliance: NMI/MIRN validation, MSATS lookup, AEMO gas rules, payment method migration. NZ: Genesis R2 (Mercury, Globug).
4
Environments
#441
Build
DEV verified. Cutover Engine, Inflight Tracker, Manual Register, AU Market all deployed. DynamoDB persistence active.
SOURCE SYSTEMS (Any Database)
DMS ENGINE (AI-Powered)
AI LAYER (16 Agents · GAC)
TARGETS (G2 + Others)
CUTOVER & OPERATIONS NEW
❄️
Snowflake
Native Streams CDC · <30s
  • Snowflake Streams (native CDC)
  • Watermark polling (incremental)
  • Keyset pagination (full load)
  • Proven: Mercury 125M, Pulse 2.34B
▼
🐘
PostgreSQL
WAL Logical Replication · <1s
  • WAL logical replication slot
  • asyncpg (high performance)
  • Docker tested: 217K rows E2E
  • Supports PG 12, 13, 14, 15, 16
▼
🔴
Oracle
GoldenGate + Watermark
  • GoldenGate trail file reader
  • python-oracledb (thin mode)
  • Oracle 12c+, RDS, Autonomous
  • Keyset + watermark incremental
▼
🔷
SQL Server
Native CDC Tables · <1s
  • MS CDC change table polling
  • pymssql driver
  • MSSQL 2016+, Azure SQL, RDS
  • BCP bulk load support
▼
🔌
+159 More Sources
MySQL · SAP · MongoDB · SaaS · Files
  • MySQL, MariaDB, SAP HANA
  • MongoDB, CosmosDB, DynamoDB
  • Salesforce, HubSpot, Xero, ServiceNow
  • Kafka, REST APIs, CSV, Parquet, JSON
  • Banking (SWIFT, ISO20022), BI tools
▼ 163 total
⚡
Extraction Engine
Keyset Pagination · Polars · Fargate
  • Keyset pagination: O(1) per page
  • Polars LazyFrames (constant memory)
  • Auto-scale: 3-50 Fargate workers
  • $0 idle cost (cold-start only)
  • DynamoDB checkpoints (resumable)
  • >5K rows auto-triggers Fargate
▼
🔄
CDC Replication Engine
5 CDC Methods · Replaces Qlik
  • Snowflake Streams (<30s)
  • PostgreSQL WAL (<1s)
  • SQL Server CDC (<1s)
  • GoldenGate trail reader
  • Watermark polling (any DB)
  • Schema evolution (auto-add columns)
  • Exactly-once delivery guarantee
  • 💰 Saves $500K-$1.5M/yr per customer
▼ LIVE
🔀
Transform Pipeline
Profile → Transform → Validate → Load
  • Statistical profiling (AI-scored)
  • CDM mapping (41 entities)
  • VEE validation rules
  • Source vs target reconciliation
  • PII auto-masking in-flight
  • Bulk load: S3 Parquet → COPY INTO
  • BCT proven: 99.32% on $6.43B
▼
🛡️
Operations & Reliability
HA · DORA · Auto-Heal · Alerting
  • Always-on ECS daemon (heartbeat)
  • Auto-healing (9 failure categories)
  • DORA metrics (deploy freq, lead time, MTTR, CFR)
  • SLA monitoring + L1→L2→L3 escalation
  • SNS + Slack + PagerDuty + Teams
  • Schema drift detection
  • OpenTelemetry tracing
▼ DORA
🧠
AI Orchestration (GAC)
16 Agents · Bedrock Claude
  • MasterAgent: Think→Swarm→Review
  • Discovery, Profiling, Cleansing
  • Transform, Validation, Reconcile
  • Anomaly Detection (Welford)
  • Auto-Healing + AI Diagnostics
  • NL Pipeline Creation
  • Jira Army (ticket refinement)
  • Human approval gates (always)
  • Gentrack Agent Core (shared)
▼ 16 agents
✨
Intelligence Layer
Our Unique IP · MCP Server
  • AI Mapping Discovery
  • Statistical Profiling + Scoring
  • Anomaly Detection (streaming)
  • CDM Enforcement (41 entities)
  • PII Auto-Masking (modulo)
  • MCP Server (tool access for AI)
  • Guardrails (SQL safety, schema grounding)
  • 🏆 NO competitor has this
▼
🎯
Skills System
8 Composable Skills
  • Migration Planner
  • CDM Mapper
  • BCT Comparator
  • Extraction Strategist
  • CDC Pipeline Builder
  • Schema Comparator
  • Reconciliation Engine
  • Go-Live Checker
▼ 8 skills
⚡
Gentrack G2
Primary Target Platform
  • UtilOps — Billing, Metering, CRM
  • Salesforce — Customer Engagement
  • CustOps — Field Service
  • CDM 41-entity canonical model
  • MERGE/UPSERT + reconciliation
  • Proven: Mercury, Genesis, Pulse, NBE
▼ PRIMARY
❄️
Snowflake / Data Lake
GLDM · Analytics · Reporting
  • GLDM warehouse (14B rows)
  • MERGE INTO (auto-dedup)
  • S3 Parquet → COPY INTO
  • BI semantic layer (charts, exports)
▼
🔶
DynamoDB
State · Jobs · Cutover
  • Single-table design (PK/SK + GSIs)
  • Job state persistence
  • Cutover run tracking
  • Inflight transaction store
  • API key management
  • Multi-tenant partition keys
▼ NEW
📡
Kafka / Kinesis
Real-time Streaming
  • Produce change events (JSON/Avro)
  • Real-time downstream consumers
  • Event-driven architecture
▼
🎯
+6 More Targets
MSSQL · Oracle · Iceberg · Teams
  • PostgreSQL (UPSERT + COPY)
  • SQL Server (MERGE + BCP)
  • Oracle (MERGE INTO)
  • Iceberg / Delta Lake
  • REST API webhooks
  • Reverse ETL (warehouse → SaaS)
  • Microsoft Teams Bot
▼
🚀
Cutover Engine
25 Steps · Go/No-Go Gates
  • 25-step cutover orchestration
  • Go/No-Go checkpoint enforcement
  • Timing metrics per step
  • 4 cohorts (R1, R2-RESI, R2-SME, R3)
  • Execution reports (PDF/Excel)
  • DynamoDB persistence
▼ NEW
🔄
Inflight Tracker
27 Transaction Types · Freeze Guard
  • 27 inflight transaction types
  • Cutover freeze monitoring
  • Completion status per item
  • Owner assignment + escalation
  • Genesis R2 register (pre-seeded)
  • Real-time dashboard
▼ NEW
📋
Manual Migration Register
34 Items · Business Prep
  • 34 manual migration items
  • Business prep tracking
  • Owner + due date assignment
  • Evidence/attachment upload
  • Status workflow (Not Started→Done)
  • DynamoDB single-table design
▼ NEW
🇦🇺
AU Market Compliance
NMI · MIRN · MSATS · AEMO
  • NMI check digit (modified Luhn)
  • NMI range registry (all distributors)
  • MIRN gas meter validation
  • MSATS standing data lookup
  • AEMO gas market rules
  • Payment method migration (DD/CC/BPAY)
  • State-based rule enforcement
▼ NEW