Delphix vs Oracle GoldenGate comparison

Delphix is a software company that specializes in data virtualization and data management solutions. The company's primary product is the Delphix Dynamic Data Platform, which enables organizations to streamline data operations and accelerate application development.

Delphix focuses on solving data challenges faced by enterprises, such as data provisioning, data masking, data integration, and data versioning. The platform works by creating virtual copies of data, known as "data pods," which are lightweight and can be easily accessed and shared across various environments, such as development, testing, and analytics.

Delphix Features:

• Data Virtualization: Create virtual data copies without physical copies, reducing storage needs.
• Data Masking: Secure sensitive data with realistic yet fictional information for privacy and compliance.
• Data Integration: Streamline data integration and provisioning across various sources and platforms.
• Data Versioning: Manage multiple data versions for rollbacks, comparisons, and compliance.
• Self-Service Data Management: Empower users to access and refresh data copies independently, boosting productivity.
• DataOps Automation: Automate data operations for faster application development and streamlined workflows.

Delphix is used by organizations across various industries, including financial services, healthcare, retail, and technology, to accelerate software development, improve data security, and enhance data management practices.

Delphix Benefits:

• Data agility: Rapid provisioning of virtual data copies speeds up application development.
• Storage efficiency: Lightweight virtual copies reduce storage needs and infrastructure costs.
• Data security and compliance: Robust data masking ensures privacy and regulatory compliance.
• Enhanced collaboration: Simultaneous access to data promotes teamwork and knowledge sharing.
• Faster data integration: Seamless integration with various sources improves accessibility and insights.
• Improved data governance: Centralized control enforces consistency and supports compliance.
• Reduced risk and resilience: Data versioning allows easy rollbacks and recovery.
• Operational efficiency: Automation streamlines processes and improves resource allocation.
• Cost savings: Optimized storage and streamlined workflows lead to reduced expenses.

Reviews from Real Users

PeerSpot user, Product Owner & Scrum master at a financial services firm, says that "Delphix's data distribution is powerful. It's easy to distribute data with this solution. The main advantage of Delphix is that it generates copies of data."

Niaz Aziz, Projects Team Lead at Azeemi Technologies, states that Delphix “Has good scalability and works efficiently for data visualization”

Another PeerSpot user, DevOps ERP Engineer at a tech services company, writes that Delphix has “Excellent working environment, with continuous updates and affordable pricing”

Oracle GoldenGate is a real-time data integration and database replication solution. It can detect data events and route them across networks at very low latencies and integrates well with 100s of combinations of non-Oracle databases, data stores, and clouds.

Oracle GoldenGate Features

Oracle GoldenGate has many valuable key features, including:

• Simple to use web interface
• Fast and easy installation or provisioning
• Command line access via AdminClient that can run anywhere
• RESTful APIs for DevOps
• Offers built-in monitoring but also can be easily adapted to roll your own monitoring
• APIs are protected by Cross Site Request Forgery (CSRF) authentication.

Oracle GoldenGate Benefits

Some of the benefits of using Oracle GoldenGate include:

• Oracle GoldenGate is deeply integrated with the Oracle Database (logging, redo, backup and recovery layer, security, administration, data guard, data vault, autonomous database etc.).
  
  
• It is the most stable, performant, and reliable CDC / replication solution for Oracle.
  
  
• High performance: Oracle GoldenGate is capable of sub-second latency for data movement. featuring low impact capture, routing, transformation, and delivery of transactional data.
  
  
• GoldenGate is the only CDC / replication tool that keeps pace with new and emerging innovations (security, features, data types, etc) in the core Oracle Database.
  
  
• The solution supports a wide range of use cases, from conventional OLTP data replication and high availability to data lake ingestion or multi-cloud ingestion, SaaS application replication, and messaging replication.
• GoldenGate is the only CDC / replication technology certified for Exadata, Exadata Cloud Service, and Exadata Cloud at Customer.
  
  
• For fault-tolerance, GoldenGate has its own mechanism to keep track of how much work is completed and how much is pending. This mechanism is independent of any database and ensures, with the help of automatic gap-resolution, that no data loss occurs.
  
  
• GoldenGate uses its own proprietary format files for keeping the committed data coming from the source database, making it independently functional irrespective of the database in use.
  
  
• To maintain the performance and consistency, only committed data is sent. Uncommitted data is captured by GoldenGate, but is discarded after receiving a Rollback.
  
  
• With GoldenGate, data sending is in “near real time,” which reduces the possibility of latency.

Reviews from Real Users

Below are some reviews and helpful feedback written by Oracle GoldenGate users.

PeerSpot user Steve-J., Cloud Migration Software Consultant - UK & EMEA at 1PLACE, says, "What I have found the most valuable about GoldenGate is that it does real-time and no-downtime migrations. Its migrations are fast. There are not many tools like it on the marketplace."

Pinak S., Senior Manager of System and Database at ESL, mentions, “We like how in GoldenGate the heterogeneous database is supported. Sometimes the client actually needs a schedule and needs to ensure the state of databases for reporting purposes. With that in mind, we have been able to configure GoldenGate for certain schema. The solution is quite stable. They've recently improved the ease of implementation.”

A Database Administrator at a manufacturing company explains, "It moves the data as you set it up, and it works. I am also very impressed with its stability and scalability. It is not super feature-rich, but the new releases have more functionality. It recently had more native integrations with Oracle Database. If you are using it against an Oracle database, it has a lot more functionality."

An Oracle ERP DBA Consultant - Oracle Super Cluster T5-8 Admin at a government comments, "GoldenGate can connect and collect data from multiple sources, such as SQL Server."