Legend
Color | Meaning |
---|---|
Supported | |
Not Supported | |
Not Applicable |
Delphix Features with Data Platforms
This section describes the Delphix features we support for each data platform.
Delphix Feature | Oracle | SQL Server | SAP ASE | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10g | 11g | 12c | 18c | 19c | PDB | 2008 | 2012 | 2016 | 2017 | 2019 | 15.0.3 | 15.5 | 15.7 | 16 | |||||
Environment Management | Manual environment discovery | ||||||||||||||||||
Automated environment discovery | |||||||||||||||||||
Hostchecker | |||||||||||||||||||
Environment monitor | |||||||||||||||||||
Linking/ Syncing | Load from existing backup | ||||||||||||||||||
Incremental snapshots | |||||||||||||||||||
Resumable syncs for initial load | |||||||||||||||||||
dSource LogSync | |||||||||||||||||||
Linking clustered source databases | |||||||||||||||||||
Validated Sync on snapshot | |||||||||||||||||||
Validated Sync, continuous | |||||||||||||||||||
Load from alternate sources | |||||||||||||||||||
VDB LogSync | |||||||||||||||||||
Source Continuity | |||||||||||||||||||
Handling of source DB upgrades | |||||||||||||||||||
Handling of non-logged changes | |||||||||||||||||||
Provisioning | VDB on VDB | ||||||||||||||||||
VDB refresh and rewind | |||||||||||||||||||
Provisioning clustered VDBs | |||||||||||||||||||
VDB migration | |||||||||||||||||||
VDB upgrades outside of Delphix | |||||||||||||||||||
Automated VDB upgrades with Delphix | |||||||||||||||||||
Database config parameters for VDBs | |||||||||||||||||||
Path-mapping | |||||||||||||||||||
V2P | Basic V2P data export | ||||||||||||||||||
V2P over DSP | |||||||||||||||||||
Multi filesystem V2P | |||||||||||||||||||
Resumable V2P |
Data Platform Features
This section describes the data platform-specific features we support for each use case within Delphix.
*Non-multitenant TDE support does not apply to vPDBs.
*Oracle databases can have some tables that are HCC-enabled and some that are not; Delphix can ingest a database with HCC-enabled tables and can successfully provision a VDB. The caveat to this is that attempts to read data from the HCC-enabled tables on a provisioned VDB will fail. This happens because Oracle requires the backing storage to be fully supported for HCC, but uncompressed tables can be used as expected with non-HCC tables. Please note that Oracle only recommends HCC for tables or partitions with little to no DML operations. Another possible solution is creating hook operations to uncompress the HCC-enabled tables/partitions to access the data, this method is outlined in a Delphix Community post.
Oracle
Platform Feature | Oracle | ||||||
---|---|---|---|---|---|---|---|
10g | 11g | 12c | 18c | 19c | |||
dSource Linking | Single Instance | ||||||
CDB with PDB Multi-Tenant | |||||||
Read-Only Oracle Home | |||||||
CDB with Application Container PDB | |||||||
dSource SnapSync | Level based backups | ||||||
SCN based backups | |||||||
Physical Standby | |||||||
Active Dataguard | |||||||
ASM | |||||||
RAC | |||||||
TDE (non-multitenant)* | |||||||
HCC* | |||||||
Exadata | |||||||
dSource LogSync | RAC | ||||||
ASM FS | |||||||
Native FS | |||||||
Physical Standby | |||||||
VDB | Single Instance | ||||||
RAC | |||||||
Read-Only Oracle Home | |||||||
Application Container |
SQL Server
Delphix Feature2019 | SQL Server | ||||||
---|---|---|---|---|---|---|---|
2008 | 2012 | 2016 | 2017 | 2019 | |||
Linking and Syncing | Linking from clustered sources | ||||||
Full and bulk-logged mode support | |||||||
Simple mode support | |||||||
Filestreams | |||||||
Full textcatalogs | |||||||
Availability groups | |||||||
Backup Software | Native backups | ||||||
Litespeed SQL Server backups | |||||||
Red Gate SQL Backup Pro | |||||||
NetBackup | |||||||
Commvault | |||||||
Provisioning | Clustered VDBs | ||||||
Availability Groups | |||||||
Change Data Capture |
SAP ASE
Delphix Feature | SAP ASE | |||||
---|---|---|---|---|---|---|
15.0.3 | 15.5 | 15.7 | 16 | |||
Linking and Syncing | Linking from clustered sources | |||||
Linking from ASE replication server | ||||||
Full mode support | ||||||
Truncate log on checkpoint support | ||||||
Native backups | ||||||
NetBackup | ||||||
Provisioning | Clustered VDBs | |||||
VDB LogSync |