| IBM i change capture | Change Selector process on the IBM i, one per journal, running with the Listener in the CONNECTCDC (formerly MXSHARE) subsystem. Journals set to IMAGES(*BOTH). | Agent off the IBM i calling the native journal APIs (QjoRetrieveJournalEntries, RJNE0200 format) via JT400. No Gluesync job on the system. Journals set to IMAGES(*BOTH). Db2 for i 7.1 and later. |
| Capture on other sources | Log based on IBM i, Db2 for z/OS and Oracle; trigger and procedure based on other database servers. | Native mechanism per agent: Oracle LogMiner or XStream, SQL Server Change Tracking or transaction log, PostgreSQL WAL, MySQL and MariaDB binlog, Db2 LUW db2ReadLog, Informix change stream, SAP HANA shadow tables, MongoDB change streams, Couchbase DCP, DynamoDB Streams, Cosmos DB change feed. Trigger agents for Oracle, Db2 LUW and Sybase ASE where log access is not an option. |
| Sources | Db2 for i, Db2 for z/OS, Db2 LUW, IMS, VSAM, Oracle and Oracle RAC, SQL Server, Sybase. | 39+ source databases across IBM i, Db2 LUW, Oracle, SQL Server, PostgreSQL, MySQL, MariaDB, Informix, SAP HANA, Sybase ASE, YugabyteDB, MongoDB, Couchbase, ScyllaDB, DynamoDB and Cosmos DB. No mainframe (z/OS) sources. |
| Targets | Oracle, SQL Server, Azure SQL, Db2 (i, LUW, z/OS), PostgreSQL, MySQL, Teradata, Informix, Sybase, Apache Kafka (self-managed, MSK, Confluent Cloud), Snowflake through a staging area. | Every source platform above as a target, plus Snowflake, BigQuery, Redshift, ClickHouse, Vertica, SingleStore, CockroachDB, Cassandra, Redis, RavenDB, GridGain, Kafka, Google Pub/Sub, Solace PubSub+, AWS S3 and S3-compatible, Google Cloud Storage, Azure Data Lake Gen2 and the Universal File Store agent (Parquet, JSON, CSV over FTP, FTPS, SFTP, WebDAV, SMB and NFS). 71+ connectors in total. |
| Topologies | One-way, two-way, consolidated, distributed and cascade distributions. | One-way pipelines, fan-in and fan-out across pipelines, chains, and bidirectional sync as two pipelines with recursion protection. |
| Initial load | Copy replication started from MonCon. | Snapshot tasks with up to 8 parallel writers, logical partitioning for parallel reads, bulk mode through staging tables and native loaders, truncate or selective deletion ahead of snapshot, re-runnable per entity. |
| Transformations | Column expressions and predefined functions in Director; mappings stored in the Enterprise Data Movement Model. | Field mapping and filtering in the Control Plane, built-in field functions, user-defined functions in Java or Kotlin with snapshot and CDC awareness, denormalization of relational rows into nested documents, custom document keys, technical columns (transaction id, timestamp, user, operation). |
| Design and control interface | Director (Windows GUI) for the model; MonCon (Windows or UNIX GUI) and Console (command line) for monitoring and control. | Web Control Plane in any browser, including mobile; REST API for CI/CD; Python and Node.js SDKs; Bootstrapper YAML and Automator for bulk creation and configuration backup; Core Hub MCP server with 125 tools for AI clients. |
| Monitoring and alerting | Status and logs through MonCon and Console; audit trail of data access and change history. | Prometheus /metrics endpoint, official Grafana dashboard (throughput, snapshot progress, stalled entities, reader freshness, JVM), smart alerts with sensitivity and cooldown, notifications hub over SMTP and CloudEvents webhooks, 90-day query audit. |
| Scheduling and automation | Scheduled start and stop of replication requests. | Chronos scheduler for pipelines, snapshots, queries and Validator runs; event-driven chains and webhooks; platform events. |
| Data validation | No dedicated validation tool. | Validator compares a source entity with its target, lists missing and differing rows and schema drift, and reconciles from the Control Plane, the API or on a Chronos schedule. |
| Security | Kerberos authentication, SSL/TLS encryption, Kafka schema registry, audit trail. | TLS on Control Plane and agent traffic, optional AES-256 node-to-node encryption, OIDC single sign-on (Entra ID, Keycloak, Auth0 and others), role-based access control, PII discovery and masking, configuration export and import. |
| Query and AI surfaces | Not part of the product. | Query Studio SQL workbench, Query Forge federated JDBC gateway, AI Studio with customer-managed LLM providers (OpenAI, Anthropic, Azure OpenAI, Ollama) and Enterprise brain. |
| Deployment | Native installs on IBM i, Windows, Linux and UNIX hosts; Java kernel and Listener on every participating host. | Containers on Docker, Podman, Compose or Kubernetes; Linux and Windows Server; on premises, cloud, hybrid or air-gapped. Over-the-air updates from the Control Plane. |