The Delphix Data Platform: Data Virtualization
What is Delphix?
•Delphix is software that runs as a VM on Vmware, manages storage, Clones source Databases, pulls in changes from source databases.
•It ingests data from heterogeneous data sources and delivers lightweight virtual copies to users
•Compresses data stored on Delphix and orchestrates access to the data sharing duplicate blocks between multiple clones and keeping modified blocks private to the clones who made the changes.
•From the source data on Delphix one can spin up clones in a few minutes for almost no storage overhead.
Delphix Logical Flow :
Use Cases of Delphix :
•Speed up development projects as Development environments depend on having copies of production databases and Delphix allows provisioning in a few minutes with almost no storage overhead by sharing duplicate blocks among all the copies.
•Provide backup and recovery protection eliminating long resource-heavy weekly backups
•Eliminate ETL windows and Reporting database refresh
•One can give all the members of a development team all their own private copies of the database giving them full copies, thus eliminating bottlenecks caused by sharing a single copy and avoiding bugs caused by using subsets.
•Provision lightweight virtual database copies in minutes at scale
•Replicate data from production to non-production environments at scale: either on-premises or in the cloud for multiple instances
•Automated masking capability of the Delphix Dynamic Data Platform represents an automated approach to protecting non-production environments, replacing confidential information such as social security numbers, patient records, and credit card information with fictitious, yet realistic data.
•Manage virtual databases with the refresh, rollback, and snapshot function
•By doing efficient backups, Delphix frees up networks over the weekends because they no longer have to do full copies on the weekend.
•Can tag and branch database versions enabling "data control" for databases as one would do source control for code.
•Fast database deployments due to Delphix database virtualization technology.
•High performance results through shared block caching in Delphix memory
•Reduced costs through compression, block mapping, and other Delphix core capabilities
•Delphix achieves a great reduction in disk usage by only saving identical blocks to disk once
How does Delphix work?
•Install Delfix VM Image in any OS ex, VM Ware
•Register a source database machine in Delphix by giving the credentials.
•Link Data Source in Delfix to perform Full backup by RMAN APIs
•Mask data automatically
•Incremental refresh: Schedule Sources Changes(Time Window) to be backed up by RMAN Apis.
•Purge Old Data
Delphix Data Sources :
Supports structured, unstructured, SQL, NoSQL, and cloud-native data sources such as
•MySQL
•PostgreSQL
• Amazon Web Services RDS
• MongoDB to z/OS
• Oracle
•SQL Server
• SAP ASE
• IBM DB2
• SAP Hana etc.
Delphix Customers :
•Walmart
•Wells Fargo
• Cisco
•cable provider: Comcast
•Ebay
•New York Life Insurance
•Intel
•Molina Healthcare etc.
Delphix’s User Base :
Very well articulated and help beginners alot.