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 | Y | Y | Y | N |
Couchbase 6.5 | Y | Y | Y | N |
Couchbase 6.6 | Y | Y | Y | N |
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
Community Edition XDCR only | Enterprise Edition | |
---|---|---|
Couchbase 6.0 | Y | Y |
Couchbase 6.5 | Y | Y |
Couchbase 6.6 | Y | Y |
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-14.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
MySQL Linux
Connector/Delphix engine compatibility
Delphix Engine Version | Connector Version | ||||
---|---|---|---|---|---|
1.0.0 | 2.0.26 | 2.1.0 | 3.0.0 | 4.0.0 | |
6.0.4.0 | Y | Y | N | N | N |
6.0.5.0 | Y | Y | N | N | N |
6.0.6.0 | Y | Y | N | N | N |
6.0.7.0 to 6.0.16.0 | N | N | Y | N | N |
6.0.16.0 and above | N | N | Y | Y | Y |
Supported DBMS version
Supported DBMS Version | Connector version | ||||
---|---|---|---|---|---|
1.0.0 | 2.0.26 | 2.1.0 | 3.0.0 | 4.0.0 | |
MySQL Community 5.7.x | Y | Y | Y | Y | Y |
Percona Server 5.7.x | N | N | N | Y | Y |
MySQL Community 8.0.x | N | N | N | N | Y |
Percona Server 8.0.x | N | N | N | N | Y |
Supported operating system
Supported OS Version | Connector version | ||||
---|---|---|---|---|---|
1.0.0 | 2.0.26 | 2.1.0 | 3.0.0 | 4.0.0 | |
RHEL 6.9 / 7.x | Y | Y | Y | Y | Y |
Size in TB / sizing
No known limitations.
Frequency of refreshes
No known limitations.
Source backup policy
Here note any possible issues of the plugin conflicting with or relying on Source Backup Policy.
Ex: This EDSI uses backup ingestion, and relies on the production backup schedule to determine it's snapsync granularity.
Ex: This EDSI uses backup ingestion, but for RDS integration we use a hook and create our own backups.
Use case (PIT Provisioning, Dev/Test)
Here note any possible issues with certain use cases
Ex: Does not support Point-in-Time Provisioning.
Ex: Only useful for migration to the cloud, not appropriate for Dev/Test, Compliance, or AI/ML training.
Delphix option (SDD, API Calls, GUI Icons, GUI PIT Prov)
Here note any Delphix Options which don't work, or which do work but not be readily apparent.
Ex: Supports SDD, API Calls. Does not Support Fancy GUI Icons or GUI PIT Provisioning.
Timestamp on snapshot metadata (Affects other products too (HANA, but not Oracle/SQLServer)
Here note issues/workarounds relating to Timestamps of Snapshot.
Ex: 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
Clustering (Active/Active vs Active/Passive, different Vendors)
Plugin has not been tested & certified with clustered configurations.
Sharding
Partial
Un-Sharded VDB | Sharded VDB | |
---|---|---|
Un-Sharded Source | Y | N |
Sharded Source | N | N |
Authentication type (LDAP, Kerberos,)
LDAP and Kerberos are not supported at this time, but please contact Ranzo Taylor if you have a customer who requires this.
Ingestion type
mysqldump works, RAW/mysqlbackup does not
Manual Backup Ingestion
Simple Tablespace Backup
Replication
Backup vendor (Commvault, Native, Replication)
Supports Native Backups & Replication
Encryption (At Rest, TLS/SSL, Encrypted Backups)
Encryption at Rest has not been tested.
Encrypted Backups have not been tested.
Link to documentation
MySQL environments and data sources
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/NOT TESTED
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 command
BASHSHOW CHANGEFEED JOBS; PAUSE JOBS (WITH x AS (SHOW CHANGEFEED JOBS) SELECT * FROM x WHERE status = ('running'));
Copy
Resume CDC job once CockroachDB masking is completed.
BASHRESUME 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/
Salesforce
JDBC masking
Feature | Availability | |
---|---|---|
In-Place Masking Mode | Multi-Tenant | Available |
Streams/Threads | Available | |
Batch Update | Available | |
Drop Indexes | Unavailable | |
Disable Trigger | Unavailable | |
Disable Constraint | Unavailable | |
Identity Column Support | Available | |
On-The-Fly Masking Mode | Unavailable | |
Profiling | Multi-Tenant | Available |
Streams | Available |
Delphix compliance accelerator
Platform \ dxac | dxac v2.0.0 | dxac v2.1.0 |
---|---|---|
Delphix Continuous Compliance Engine | 6.0.10 - 6.0.17 | 7.0.0+ (OEM enabled) |
Continuous Compliance API | 5.1.9 | 5.1.9 |
Salesforce API | v51+ | v51+ |
MacOS | 11.6.0+ | 11.6.0+ |
Windows | 10 | 10 |
RHEL | 7.9, 8.x | 7.9, 8.x |
CDATA Salesforce Driver Version | 21.0.8137, 21.0.8201.0 | 22.0.8301 |
Delphix rehearsal tool
Platform \ dxrt | dxrt v3.2.0 |
---|---|
Salesforce API | v56+ |
MacOS | 11.6.0+ |
Windows | 10 |
RHEL | 8.x |
Salesforce package manager
Platform \ Package Manager | Package Manager v1.0.0 |
---|---|
Delphix Continuous Compliance Engine | 6.0.10+ |
Continuous Compliance API | 5.1.9 |
Salesforce API | v51+ |
CDATA Salesforce Driver Version | 21.0.8201.0 |
Data protect & version
Platform \ Data Protect & Version | v3.0.0 |
---|---|
Delphix Engine | 6.0.15+ |
Salesforce Platform | Spring ‘23 (v.57), Winter ‘23 (v.56) |
Salesforce API | 53 |
Staging Host | RHEL 7.9, 8.2 |
Link to documentation
Select Connector for Salesforce Documentation
SAP
JDBC masking
Feature | Oracle | HANA | |
---|---|---|---|
In-Place Masking Mode | Multi-Tenant | Available | Available |
Streams/Threads | Available | Available | |
Batch Update | Available | Available | |
Drop Indexes | Available | Unavailable | |
Disable Trigger | Available | Unavailable | |
Disable Constraint | Available | Unavailable | |
Identity Column Support | Available | Unavailable | |
On-The-Fly Masking Mode | Available | Available | |
Profiling | Multi-Tenant | Available | Available |
Streams | Available | Available |
Delphix compliance accelerator
Platform \ dxac | dxac v2.1.0 |
---|---|
Delphix Continuous Compliance Engine | 6.0.15+ |
Continuous Compliance API | 5.1.9 |
MacOS | 11.6+ |
Windows | 10 |
RHEL | 7.9, 8.x |
SAP source version
Applications | Database | Driver |
---|---|---|
SAP S/4 HANA 1909 | HANA 2.0 SP04, SP05, and SP06 | SAP NDBC Driver 2.12.7 |
SAP S/4 HANA 2020 | HANA 2.0 SP04, SP05, and SP06 | SAP NDBC Driver 2.12.7 |
SAP ECC | Oracle | Delphix Compliance Engine Native Connector |
Link to documentation
SAP Compliance Accelerator Documentation
Cassandra
Delphix engine compatibility
Engine Version | Cassandra v1.0.0 | Cassandra v1.1.0 |
---|---|---|
6.0.16.0 | Y | Y |
6.0.17.0 | Y | Y |
7.0.0.0 | Y | Y |
10.0.0.0 | Y | Y |
Supported Database / OS
Supported DBMS Version | DataStax Cassandra v5.1.16 | DataStax Cassandra v6.8.25 - 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/