Apache Spark vs. Oracle GoldenGate

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Apache Spark
Score 8.7 out of 10
N/A
N/AN/A
Oracle GoldenGate
Score 8.2 out of 10
N/A
Oracle GoldenGate is database management software for data integration, and availability support for heterogeneous databases.
$250
Per License
Pricing
Apache SparkOracle GoldenGate
Editions & Modules
No answers on this topic
Data Integration
$250.00
Per License
Offerings
Pricing Offerings
Apache SparkOracle GoldenGate
Free Trial
NoYes
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional Details
More Pricing Information
Community Pulse
Apache SparkOracle GoldenGate
Top Pros
Top Cons
Best Alternatives
Apache SparkOracle GoldenGate
Small Businesses

No answers on this topic

Hornetsecurity VM Backup
Hornetsecurity VM Backup
Score 8.6 out of 10
Medium-sized Companies
Cloudera Manager
Cloudera Manager
Score 9.7 out of 10
Rubrik
Rubrik
Score 8.8 out of 10
Enterprises
IBM Analytics Engine
IBM Analytics Engine
Score 8.9 out of 10
Rubrik
Rubrik
Score 8.8 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Apache SparkOracle GoldenGate
Likelihood to Recommend
9.9
(24 ratings)
9.1
(41 ratings)
Likelihood to Renew
10.0
(1 ratings)
9.2
(3 ratings)
Usability
10.0
(3 ratings)
8.6
(3 ratings)
Availability
-
(0 ratings)
10.0
(1 ratings)
Performance
-
(0 ratings)
9.0
(1 ratings)
Support Rating
8.7
(4 ratings)
8.8
(3 ratings)
In-Person Training
-
(0 ratings)
10.0
(1 ratings)
Online Training
-
(0 ratings)
10.0
(1 ratings)
Implementation Rating
-
(0 ratings)
8.6
(3 ratings)
Configurability
-
(0 ratings)
9.0
(1 ratings)
Ease of integration
-
(0 ratings)
10.0
(1 ratings)
Product Scalability
-
(0 ratings)
10.0
(1 ratings)
Vendor post-sale
-
(0 ratings)
10.0
(1 ratings)
Vendor pre-sale
-
(0 ratings)
10.0
(1 ratings)
User Testimonials
Apache SparkOracle GoldenGate
Likelihood to Recommend
Apache
Well suited: To most of the local run of datasets and non-prod systems - scalability is not a problem at all. Including data from multiple types of data sources is an added advantage. MLlib is a decently nice built-in library that can be used for most of the ML tasks. Less appropriate: We had to work on a RecSys where the music dataset that we used was around 300+Gb in size. We faced memory-based issues. Few times we also got memory errors. Also the MLlib library does not have support for advanced analytics and deep-learning frameworks support. Understanding the internals of the working of Apache Spark for beginners is highly not possible.
Read full review
Oracle
I think it's a great product. We apply Oracle GoldenGate to several use cases in our organization. 1. Business Continuity Planning, 2. Query Offloading through data replication to a reporting instance of our data, 3. looking into data transformations to help support various queries for different teams within the business.
Read full review
Pros
Apache
  • Apache Spark makes processing very large data sets possible. It handles these data sets in a fairly quick manner.
  • Apache Spark does a fairly good job implementing machine learning models for larger data sets.
  • Apache Spark seems to be a rapidly advancing software, with the new features making the software ever more straight-forward to use.
Read full review
Oracle
  • As the product under the Oracle umbrella, it perfectly and natively supports the Oracle database very well.
  • For the standard scenario and use cases, the configuration is straight-forward (in our case uni-direction copy from source to target).
  • It is robust and the performance meets our SLA, even for a large amount of data volume.
  • The error report is not only detailed but hits the right points, so trouble shooting is easy.
Read full review
Cons
Apache
  • Memory management. Very weak on that.
  • PySpark not as robust as scala with spark.
  • spark master HA is needed. Not as HA as it should be.
  • Locality should not be a necessity, but does help improvement. But would prefer no locality
Read full review
Oracle
  • The earlier versions of Golden Gate were complex to use as there was no front end. All that works was the command line.
  • The cost of the product can be a detriment to most companies.
  • The product has been augmented over the years and has so many features that it can be overwhelming.
Read full review
Likelihood to Renew
Apache
Capacity of computing data in cluster and fast speed.
Read full review
Oracle
Oracle GoldenGate is a core part of our business.
Read full review
Usability
Apache
The only thing I dislike about spark's usability is the learning curve, there are many actions and transformations, however, its wide-range of uses for ETL processing, facility to integrate and it's multi-language support make this library a powerhouse for your data science solutions. It has especially aided us with its lightning-fast processing times.
Read full review
Oracle
Once set up, it's very easy to use and keep running, it's getting to that point that can make it cumbersome to some. Also, depending on the data that you want to replicate, the configuration files can become quite cumbersome to maintain. Learning curve can be high for some who are not as experienced with databases and transactions.
Read full review
Reliability and Availability
Apache
No answers on this topic
Oracle
Oracle GoldenGate has only gone down for us when the data being sent was bad.
Read full review
Performance
Apache
No answers on this topic
Oracle
Oracle GoldenGate's performance is great for our use cases. Your mileage may vary.
Read full review
Support Rating
Apache
1. It integrates very well with scala or python. 2. It's very easy to understand SQL interoperability. 3. Apache is way faster than the other competitive technologies. 4. The support from the Apache community is very huge for Spark. 5. Execution times are faster as compared to others. 6. There are a large number of forums available for Apache Spark. 7. The code availability for Apache Spark is simpler and easy to gain access to. 8. Many organizations use Apache Spark, so many solutions are available for existing applications.
Read full review
Oracle
Oracle Support for Oracle GoldenGate has been quite responsive and quite helpful in the few situations where we've needed it. Furthermore, the documentation on Oracle GoldenGate is so good that we often do not need to contact support with issues as the fix is already documented and able to be run by us without needing to open a ticket.
Read full review
In-Person Training
Apache
No answers on this topic
Oracle
We've had Oracle consultants come as well for training days to talk about new features, parts of Oracle GoldenGate we may not be using and things of that nature. The consultants they send are great as they're very knowledgeable about all things Oracle GoldenGate and great resources for any questions or concerns you may have with the product.
Read full review
Online Training
Apache
No answers on this topic
Oracle
We used Oracle University for our Oracle Golden Gate Training and it was top notch. We were able to turn our whole DBA team to Oracle GoldenGate newbies to Oracle GoldenGate troubleshooting experts in a matter of a few days, while this obviously did not come cheap, the company felt that it was worth the investment.
Read full review
Implementation Rating
Apache
No answers on this topic
Oracle
If Oracle GoldenGate is new to your organization, expose as many DBAs as possible to it. Having your whole team fluent in it will overcome early operational hurdles and allow it to more quickly become an accepted and supported part of your supported platform for your team that will enable the business to use it to its fullest.
Read full review
Alternatives Considered
Apache
All the above systems work quite well on big data transformations whereas Spark really shines with its bigger API support and its ability to read from and write to multiple data sources. Using Spark one can easily switch between declarative versus imperative versus functional type programming easily based on the situation. Also it doesn't need special data ingestion or indexing pre-processing like Presto. Combining it with Jupyter Notebooks (https://github.com/jupyter-incubator/sparkmagic), one can develop the Spark code in an interactive manner in Scala or Python
Read full review
Oracle
We use Oracle Data Guard as a backup tool, but not for data replication. Data Guard is not suited for real-time data replication in our non-normalized reporting database nor for the database we are using for our upgrade project, as Data Guard is not able to transform data and is not able to synchronize data into different schemas, which is necessary for our project. Additionally, our project database is on Oracle 12g not 11i: I am not 100% sure Data Guard is able to replicate from 11i to 12g
Read full review
Scalability
Apache
No answers on this topic
Oracle
Have never had any issues with scaling Oracle GoldenGate itself, however Oracle GoldenGate Monitor does have scaling issues, but with Oracle GoldenGate now able to be monitored by Oracle Enterprise Manager, this is no longer an issue, in my opinion.
Read full review
Return on Investment
Apache
  • Faster turn around on feature development, we have seen a noticeable improvement in our agile development since using Spark.
  • Easy adoption, having multiple departments use the same underlying technology even if the use cases are very different allows for more commonality amongst applications which definitely makes the operations team happy.
  • Performance, we have been able to make some applications run over 20x faster since switching to Spark. This has saved us time, headaches, and operating costs.
Read full review
Oracle
  • In earlier versions, DDL support was limited as well as the need of primary key constraints in the source tables. This made me create partitions, sub-partitions, truncatations and perform other operations upon they are performed in source systems and I need to discuss with source system administrators and need to convince them to let them create primary keys for replicated tables.
  • But both issues are solved now.
  • Installation is straightforward, easy.
  • Deployed everything within Oracle Data Integrator.
  • Developing 1000 of ODI interfaces for loading into Operational Data Store took not more than 100 man/days. But, adding them to Golden Gate is taking not more than 5 man/days.
  • Management Pack and VeriData are additional packs for your management and data verification needs.
Read full review
ScreenShots