Select connectors matrix
Color | Supported? |
---|---|
Y | Yes |
N | No |
NA | Not Applicable |
Couchbase
Data source version and OS version
RHEL 6.x | RHEL 7.0 | RHEL 8.0 | Windows | |
---|---|---|---|---|
Couchbase 6.0.x | Y | Y | Y | N |
Couchbase 6.5.x | Y | Y | Y | N |
Couchbase 6.6.x | Y | Y | Y | N |
Couchbase 7.1.x | Y | Y | Y | N |
Database/Plugin support matrix
Plugin version 1.2.1 | Plugin version 1.2.2 | Plugin version 1.3.0 | |
---|---|---|---|
Couchbase 6.0.x | Y | Y | Y |
Couchbase 6.5.x | Y | Y | Y |
Couchbase 6.6.x | Y | Y | Y |
Couchbase 7.1.x | N | Y | Y |
Couchbase Edition Compatibility Matrix
Community Edition XDCR only | Enterprise Edition | |
---|---|---|
Couchbase 6.0.x | Y | Y |
Couchbase 6.5.x | Y | Y |
Couchbase 6.6.x | Y | Y |
Couchbase 7.1.x | Y | Y |
Size in TB / sizing
No known restrictions.
Memory, Network, IOPS metrics from Couchbase GUI
Frequency of refreshes
No specific limitations
Source backup policy
Supports backups using Couchbase Backup Manager (cbbkpmgr)
Supports Couchbase XDCR technology
Use case (PIT Provisioning, Dev/Test)
Does not support Point-in-Time Provisioning.
Not appropriate for high throughput performance requirement.
Delphix option (SDD, API Calls, GUI Icons, GUI PIT Prov)
V2P is not supported.
Timestamp on snapshot metadata
This plugin ingests Backups at any time, so the time flow may not go in linear order. Time of Backup is not readily available.
Architecture options
Only 1 VDB per host is supported (couchbase restriction of 1 instance per Node)
Dedicated 1 Staging host is needed for each dSource created using XDCR technology
Authentication type (LDAP, Kerberos,)
Kerberos is not supported.
LDAP not tested.
Ingestion type (Backup, Dump, Replication, Snapshot)
Couchbase Backup Manager (cbbkpmgr)
XDCR
Link to documentation
https://delphix.github.io/couchbase-plugin
Mongo
Data Source version and OS version
Supported Mongo Version | mongoDB 4.2.x | mongoDB 4.4.x | mongoDB 5.0.x | mongoDB 6.0.x |
---|---|---|---|---|
RHEL 6.x | Y | Y | Y | Y |
RHEL 7.x | Y | Y | Y | Y |
RHEL 8.x | Y | Y | Y | Y |
CentOS 6.x | Y | Y | Y | Y |
CentOS 7.x | Y | Y | Y | Y |
CentOS 8.x | Y | Y | Y | Y |
Windows | N | N | N | N |
Engine Compatibility Matrix
MongoDB Version | Mongopy 1.0.0 | Mongopy 1.0.1 | Mongopy 1.0.2 | Mongopy 1.1.0 | Mongopy 1.2.0 | Mongopy 1.2.1 | Mongopy 1.3.0 |
---|---|---|---|---|---|---|---|
6.0.7.x-6.0.11.x | Y | Y | N | N | N | N | N |
6.0.12.x-6.0.15.x | Y | Y | Y | Y | N | N | N |
7.x-18.x | N | N | N | N | Y | Y | Y |
Mongo/Plugin Version Compatibility Matrix
MongoDB Version | Mongopy 1.0.0 | Mongopy 1.0.1 | Mongopy 1.0.2 | Mongopy 1.1.0 | Mongopy 1.2.0 | Mongopy 1.2.1 | Mongopy 1.3.0 |
---|---|---|---|---|---|---|---|
4.x-5.x | Y | Y | Y | Y | Y | Y | Y |
6.x | N | N | N | N | Y | Y | Y |
Size in TB / sizing
Not tested with large datasets.
Memory, Network, IOPS metrics from Mongo OPS Manager
Frequency of refreshes
No specific limitations
Source backup policy
Sharded Mongo always ingest full. Non-Sharded mongo ingestion may be full or incremental based on the mechanism used for ingestion.
Sharded : Full
Non-Sharded (Using Backups ) - Full
Non-sharded (Using replicaset member) - incremental
Mongodump - Full or incremental based on type of source and type of ingestion
Use case (PIT Provisioning, Dev/Test)
Does not support Point-in-Time Provisioning.
Not appropriate for high throughput performance requirement.
Delphix option (SDD, API Calls, GUI Icons, GUI PIT Prov)
V2P is not supported.
Timestamp on snapshot metadata
This plugin ingests Backups at any time, so the time flow may not go in linear order. Time of Backup is not readily available.
Architecture options
Sharding
Supported
Unsharded VDB | Sharded VDB | |
---|---|---|
Unsharded Source >= 3.6 | Y | N |
Sharded Source >= 4.2 | N | Y |
Example: Sharded sources are supported, but require backup vendor MongoOPS Manager to create backup.
Authentication type (LDAP, Kerberos,)
LDAP and SCRAM supported
Kerberos not supported
Ingestion type (Backup, Dump, Replication, Snapshot)
MongoOPS Manager Backup Files
Mongodump
Replicaset
Encryption (At Rest, TLS/SSL, Encrypted backups)
Supported
Link to documentation
https://delphix.github.io/mongo-plugin/
Microsoft SQL backup ingestion
Data source version and OS version
Windows 2012 | Windows 2012 R2 | Windows 2016 | Windows 2019 | Windows 2022 | |
---|---|---|---|---|---|
SQLServer 2012 | Y | Y | Y | N | N |
SQLServer 2014 | Y | Y | Y | N | N |
SQLServer 2016 | Y | Y | Y | Y | N |
SQLServer 2017 | Y | Y | Y | Y | Y |
SQLServer 2019 | N | N | Y | Y | Y |
SQLServer 2022 | N | N | Y | Y | Y |
Size in TB / sizing
No sizing limitation
Frequency of refreshes
No limitation
Source backup policy
dSource sync is managed by customers and can apply backup on staging whenever required.
Use case (PIT provisioning, Dev/Test)
Does not support Point-in-Time Provisioning.
Delphix option (SDD, API Calls, GUI Icons, GUI PIT Prov)
V2P is not supported
Timestamp on snapshot metadata (Affects other products too (HANA, but not Oracle/SQLServer)
This plugin ingests Backups at any time, so the time flow may not go in linear order.
Architecture options
Failover clusters and availability groups
Does not support Windows Failover Clusters or Availability Groups for Windows Staging and Target environments.
Authentication Type (LDAP, Kerberos,)
Ex: LDAP and Kerberos are not supported at this time, but please contact Ranzo Taylor if you have a customer who requires this.
Ingestion type (Backup, Dump, Replication, Snapshot)
Full backups, Differential backups, Log Shipping, Transaction replication
Backup vendor (Commvault, Native, Replication)
All backup vendors are supported
Encryption (At Rest, TLS/SSL, Encrypted Backups)
Encryption at Rest should work, but has not been tested.
Encrypted Backups should work, and has not been tested.
Link to documentation
https://delphix.github.io/mssql_plugin_doc
Oracle backup ingestion
Data source version and OS version
RHEL 6.x | RHEL 7.0 | Windows | |
---|---|---|---|
Oracle 9i/10g/11r1 | N | N | N |
Oracle >= 11gR2 | Y | Y | N |
Size in TB / sizing
No Restrictions.
Frequency of refreshes
No specific limitations
Source backup policy
No limitations for disk.
For Tape Backup - Autobackup should be enabled.
Use case (PIT Provisioning, Dev/Test)
Disk - Archivelog need to be made available on target host for Point-in-Time Provisioning.
Tape - Tape library installed on target and authorized to access tape from target host.
Support using timestamp.
Delphix option (SDD, API Calls, GUI Icons, GUI PIT Prov)
V2P is not supported.
Timestamp on snapshot metadata
This plugin ingests Backups at any time, so the time flow may not go in linear order. Time of Backup is not readily available.
Architecture Options
Full | Y | Y | Y | Y | Y | NA |
Partial | Y | Y | Y | Y | Y | NA |
PDB | Y | Y | Y | Y | Y | N |
Partial PDB | Y | Y | Y | Y | Y | N |
Use Existing CDB | NA | NA | NA | N | NA | N |
Seed | NA | NA | NA | NA | N | NA |
RAC
Manual Addition, Selection of nodes and Checks needed to create successful RAC VDBs.
Ingestion type (Backup, Dump, Replication, Snapshot)
RMAN database backup
Backup vendor (Oracle RMAN, ZDLRA, DDBOOST, NETBACKUP, Generic Tape Drivers)
Oracle RMAN
ZDLRA
DDBOOST
NETBACKUP
Other Tape Vendors not listed above not tested but most probably will work
Link to documentation
https://delphix.github.io/obi-plugin/
SAPIQ
Data source version and OS version
Supported OS Version | SAPIQ 16.0 | SAPIQ 16.1 |
---|---|---|
RHEL 7.0 | Y | Y |
RHEL 7.4 | Y | Y |
RHEL 7.9 | Y | Y |
Windows x.x | N | N |
Size in TB / sizing
Tested at the customer with 600-800GB ingestion size.
Frequency of refreshes
No limitation
Source backup policy
Customers will manage backup located on the staging host required to create dSource.
Use case (PIT Provisioning, Dev/Test)
Does not support Point-in-Time Provisioning.
Delphix option (SDD, API Calls, GUI Icons, GUI PIT Prov)
V2P is not supported.
Password Vault is not supported.
SDD is not supported.
Timestamp on snapshot metadata
This plugin ingests backups at any time, so the time flow may not go in linear order. Time of Backup is not readily available.
Architecture options
Supports SAPIQ Simplex Architecture for VDBs.
Architecture | SAPIQ 16.0 | SAPIQ 16.1 |
---|---|---|
Simplex | Y | Y |
Multiplex | N | N |
IQ Plugin converts multiplex architecture to simplex during VDB provision.
Ingest SAPIQ source databases which are backed up using SAPIQ built-in backup mechanism.
Data Ingestion to Delphix Engine will always start with a full DB backup.
As best practices, it is recommended to keep a similar SAPIQ version in all environments (source, staging and target).
Authentication type (LDAP, Kerberos)KE
Kerberos not supported.
LDAP not tested.
Ingestion type (Backup, Dump, Replication, Snapshot)
Full backups for Simplex Architecture Tested.
Backup Vendor
Tested with manual SAPIQ backups.
Encryption (At Rest, TLS/SSL, Encrypted Backups)
Encryption at Rest has not been tested.
Encrypted Backups have not been tested.
Link to documentation
https://delphix.github.io/SAPIQ/
Cockroach
Data source version and OS version
Supported OS Version | CRDB v21.1.x | CRDB v21.2.x | CRDB v22.1.x | CRDB v22.2.x |
---|---|---|---|---|
RHEL 7.x | Y | Y | Y | Y |
RHEL 8.x | Y | Y | Y | Y |
Windows | N | N | N | N |
Architecture options
Architecture | Disk | Seed | AWS | GCP | Azure |
---|---|---|---|---|---|
Full | Y | Y | Y | N | N |
Incremental | Y | Y | Y | N | N |
Engine compatibility matrix
Engine Version | CRDB v1.0.0 | CRDB v1.1.0 | CRDB v1.1.1 | CRDB v1.1.2 |
---|---|---|---|---|
6.0.12.0 - 6.0.17.x | Y | Y | Y | Y |
7.0.0.0 - 13.0.0.0 | Y | Y | Y | Y |
PostgreSQL JDBC driver matrix
PostgreSQL Driver Version | Supported |
---|---|
42.3.2 | Y |
42.3.6 | Y |
42.4.0 | Y |
JDBC masking support matrix
Masking Mode | Feature | Availability |
---|---|---|
In-Place Masking | Multi-Tenant | Available |
Streams/Threads | Available | |
Batch Update | Available | |
Drop Indexes | Unavailable | |
Disable Constraint | Unavailable | |
Disable Trigger | Unavailable NA for CockroachDB | |
Identity Column Support | Available | |
On-The-Fly Masking | Unavailable | |
Profiling | Multi-Tenant | Available |
Streams | Available |
Drop Indexes and Disable Constraint are not supported natively while masking CockroachDB. Use pre/post scripts if you want to use these features.
CockroachDB supports rowid natively for tables with no primary key defined. It will automatically create a primary key over a hidden, INT-typed column named rowid.
To create a successful JDBC connection to CockroachDB cluster running in secure mode, please enable the password authentication without TLS using flag
--accept-sql-without-tls
with cockroach start command.To mask the CockroachDB data source where CDC (change data capture) feature is enabled, disable all the running change-feed jobs using the below commandCockroachDB supports rowid natively for tables with no primary key defined. It will automatically create a primary key over a hidden, INT-typed column named rowid.
- BASH
SHOW CHANGEFEED JOBS; PAUSE JOBS (WITH x AS (SHOW CHANGEFEED JOBS) SELECT * FROM x WHERE status = ('running'));
Resume CDC job once CockroachDB masking is completed.
- CODE
RESUME JOBS (WITH x AS (SHOW CHANGEFEED JOBS) SELECT * FROM x WHERE status = ('paused'));
Ingestion type
AWS S3 Backup Ingestion
Seed Ingestion
Limitations
CockroachDB Ingestion from Azure, GCP, and Disk is not supported.
CockroachDB Point-in-time restore is not supported.
Delphix V2P is not supported.
Delphix Password Vault is not supported.
Link to documentation
https://delphix.github.io/crdb/
Cassandra
Delphix engine compatibility
Engine Version | Cassandra v1.0.0 | Cassandra v1.1.0 | Cassandra v1.1.1 | Cassandra v1.2.0 |
---|---|---|---|---|
6.0.16.0 - 22.x | Y | Y | Y | Y |
Supported Database / OS
Supported DBMS Version | DataStax Cassandra v5.1.16 | DataStax Cassandra v6.8.9 - v6.8.33 | Apache Cassandra v4.0.7 - v4.1.1 |
---|---|---|---|
RHEL 7.4 | Y | Y | Y |
RHEL 7.9 | Y | Y | Y |
RHEL 8.0 | Y | Y | Y |
Windows | N | N | N |
Supported Ingestion
Cassandra Distribution | Staging Push | Disk | AWS |
---|---|---|---|
DataStax Enterprise | Y | N | N |
Open-Source Apache | Y | N | N |
Link to documentation
https://delphix.github.io/cassandra/