Color | Supported? |
---|---|
Yes | |
| No |
Not Applicable |
Couchbase
Data Source Version and OS Version
RHEL 6.x | RHEL 7.0 | RHEL 8.0 | Windows | |
---|---|---|---|---|
Couchbase 6.0 | ||||
Couchbase 6.5 | ||||
Couchbase 6.6 |
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 | ||
Couchbase 6.5 | ||
Couchbase 6.6 |
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
RHEL 6.4 | RHEL 7.0 | Windows | |
---|---|---|---|
Mongo DB 3.6+ | |||
Mongo DB 4.0 | |||
Mongo DB 4.2 |
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 | ||
Sharded Source >= 4.2 |
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 | |
---|---|---|---|---|
SQLServer 2012 | ||||
SQLServer 2014 | ||||
SQLServer 2016 | ||||
SQLServer 2017 | ||||
SQLServer 2019 |
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
Data Source Version and OS Version
RHEL 6.4 | RHEL 7.x | Windows 2018 | |
---|---|---|---|
MySQL 5.7 | |||
MySQL 8.0 | |||
MariaDB |
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 | ||
Sharded Source |
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
https://delphix.github.io/mysqllinux/
Oracle Backup Ingestion
Data Source Version and OS Version
RHEL 6.x | RHEL 7.0 | Windows | |
---|---|---|---|
Oracle 9i/10g/11r1 | | | |
Oracle >= 11gR2 | |
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
Disk | Tape | PITR | Virtual CDB | TDE | Physical CDB | |
---|---|---|---|---|---|---|
Full | ||||||
Partial | ||||||
PDB | | |||||
Partial PDB | | |||||
Use Existing CDB | | | ||||
Seed | ?? |
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 | ||
RHEL 7.4 | ||
RHEL 7.9 | ||
Windows x.x | | |
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 | ||
Multiplex | | |
- 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 |
---|---|---|---|
RHEL 7.x | |||
RHEL 8.0 | |||
Windows | | |
Architecture Options
Architecture | Disk | Seed | AWS | GCP | Azure |
---|---|---|---|---|---|
Full | | | | ||
Incremental | |
| | |
Engine Compatibility Matrix
Engine Version | CRDB v1.0.0 |
---|---|
6.0.12.0 - 6.0.15.0 |
|
PostgreSQL JDBC Driver Matrix
PostgreSQL Driver Version | Supported |
---|---|
42.3.2 | |
42.3.6 | |
42.4.0 |
|
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:
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.
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
Data Protect & Version Support Matrix
Platform \ Data Protect & Version | v2.0.0 |
---|---|
Delphix Engine | 6.0.12+ |
Salesforce Platform | Winter ‘22, Spring ‘22 |
Salesforce API | 53 |
Staging Host | RHEL 7.9, 8.2 |
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 v1.0.0 |
---|---|
Delphix Masking Engine | 6.0.10+ |
Masking API | 5.1.9 |
Salesforce API | v51+ |
MacOS | 10.15.7 + |
Windows | 10 |
RHEL | 7.9, 8.x |
CDATA Salesforce Driver Version | 21.0.7928.0 |
Delphix Rehearsal Tool
Platform \ dxrt | dxrt v1.0.0 |
---|---|
Salesforce API | v51+ |
MacOS | 10.15.7+ |
Windows | 10 |
RHEL | 8.x |
Salesforce Package Manager
Platform \ Package Manager | Package Manager v1.0.0 |
---|---|
Delphix Masking Engine | 6.0.10+ |
Masking API | 5.1.9 |
Salesforce API | v51+ |
CDATA Salesforce Driver Version | 21.0.7928.0 |
Link to Documentation
https://application-solutions.delphix.com/Select_Connector_for_Salesforce/Introduction/
SAP
Continuous Compliance SAP
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.0.0 |
---|---|
Delphix Continuous Compliance Engine | 6.0.14+ |
Continuous Compliance API | 5.1.9 |
MacOS | 11.6 + |
Windows | 10 |
RHEL | 7.9, 8.x |
Link to Documentation
https://application-solutions.delphix.com/Select_Connector_for_SAP/Introduction/