Select connectors matrix

Couchbase

Data source version and OS version

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

Engine Compatibility Matrix

Mongo/Plugin Version Compatibility Matrix

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

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 

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

Supported DBMS version

Supported operating system

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

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 

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

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 

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.

• 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 

Architecture options

Engine compatibility matrix

PostgreSQL JDBC driver matrix

JDBC masking support matrix

• 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

  BASH

  SHOW 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.

  BASH

  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/

Salesforce

JDBC masking

Delphix compliance accelerator

Delphix rehearsal tool

Salesforce package manager

Data protect & version

Link to documentation

Select Connector for Salesforce Documentation

SAP

JDBC masking

Delphix compliance accelerator

SAP source version

Link to documentation

SAP Compliance Accelerator Documentation

Cassandra

Delphix engine compatibility

 Supported Database / OS

Supported Ingestion

Link to documentation

https://delphix.github.io/cassandra/