What users are saying about
35 Ratings
Top Rated
207 Ratings
35 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 7.7 out of 100
Top Rated
207 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.5 out of 100

Likelihood to Recommend

Apache Solr

Solr spins up nicely and works effectively for small enterprise environments providing helpful mechanisms for fuzzy searches and facetted searching. For larger enterprises with complex business solutions you'll find the need to hire an expert Solr engineer to optimize the powerful platform to your needs.Internationalization is tricky with Solr and many hosting solutions may limit you to a latin character set.
Peter Feddo | TrustRadius Reviewer

Oracle GoldenGate

Oracle [GoldenGate] is well suited for data replication where real-time results are important, such as data reporting. There is potential to have the users query the replicated database, which can have separate resources set up to be compressed or using lower performing or cheaper resources. As mentioned, columns with LOBs can become a headache, as they will need to be synchronized in their own group many times. Tables containing data in CHAR, VARCHAR, NUMBER, DATE, or other non-LOB columns, however, are able to be replicated quite seamlessly.[Oracle GoldenGate] does provide a way to review errors that are encountered, so that is a positive if their is scrutiny around data integrity.
Chris Oros | TrustRadius Reviewer

Feature Rating Comparison

Data Source Connection

Apache Solr
Oracle GoldenGate
8.3
Connect to traditional data sources
Apache Solr
Oracle GoldenGate
9.1
Connecto to Big Data and NoSQL
Apache Solr
Oracle GoldenGate
7.6

Data Transformations

Apache Solr
Oracle GoldenGate
8.1
Simple transformations
Apache Solr
Oracle GoldenGate
9.2
Complex transformations
Apache Solr
Oracle GoldenGate
7.1

Data Modeling

Apache Solr
Oracle GoldenGate
7.8
Data model creation
Apache Solr
Oracle GoldenGate
8.6
Metadata management
Apache Solr
Oracle GoldenGate
8.0
Business rules and workflow
Apache Solr
Oracle GoldenGate
8.1
Collaboration
Apache Solr
Oracle GoldenGate
7.8
Testing and debugging
Apache Solr
Oracle GoldenGate
7.0
feature 1
Apache Solr
Oracle GoldenGate
7.1

Data Governance

Apache Solr
Oracle GoldenGate
7.9
Integration with data quality tools
Apache Solr
Oracle GoldenGate
7.7
Integration with MDM tools
Apache Solr
Oracle GoldenGate
8.1

Pros

Apache Solr

  • Easy to get started with Apache Solr. Whether it is tackling a setup issue or trying to learn some of the more advanced features, there are plenty of resources to help you out and get you going.
  • Performance. Apache Solr allows for a lot of custom tuning (if needed) and provides great out of the box performance for searching on large data sets.
  • Maintenance. After setting up Solr in a production environment there are plenty of tools provided to help you maintain and update your application. Apache Solr comes with great fault tolerance built in and has proven to be very reliable.
Anonymous | TrustRadius Reviewer

Oracle GoldenGate

  • 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.
Anonymous | TrustRadius Reviewer

Cons

Apache Solr

  • These examples are due to the way we use Apache Solr. I think we have had the same problems with other NoSQL databases (but perhaps not the same solution). High data volumes of data and a lot of users were the causes.
  • We have lot of classifications and lot of data for each classification. This gave us several problems:
  • First: We couldn't keep all our data in Solr. Then we have all data in our MySQL DB and searching data in Solr. So we need to be sure to update and match the 2 databases in the same time.
  • Second: We needed several load balanced Solr databases.
  • Third: We needed to update all the databases and keep old data status.
  • If I don't speak about problems due to our lack of experience, the main Solr problem came from frequency of updates vs validation of several database. We encountered several locks due to this (our ops team didn't want to use real clustering, so all DB weren't updated). Problem messages were not always clear and we several days to understand the problems.
Philippe Kozak | TrustRadius Reviewer

Oracle GoldenGate

  • 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.
Anonymous | TrustRadius Reviewer

Likelihood to Renew

Apache Solr

No score
No answers yet
No answers on this topic

Oracle GoldenGate

Oracle GoldenGate 9.2
Based on 3 answers
Oracle GoldenGate is a core part of our business.
Michael Grayson | TrustRadius Reviewer

Usability

Apache Solr

No score
No answers yet
No answers on this topic

Oracle GoldenGate

Oracle GoldenGate 8.6
Based on 3 answers
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.
Michael Grayson | TrustRadius Reviewer

Reliability and Availability

Apache Solr

No score
No answers yet
No answers on this topic

Oracle GoldenGate

Oracle GoldenGate 10.0
Based on 1 answer
Oracle GoldenGate has only gone down for us when the data being sent was bad.
Michael Grayson | TrustRadius Reviewer

Performance

Apache Solr

No score
No answers yet
No answers on this topic

Oracle GoldenGate

Oracle GoldenGate 9.0
Based on 1 answer
Oracle GoldenGate's performance is great for our use cases. Your mileage may vary.
Michael Grayson | TrustRadius Reviewer

Support Rating

Apache Solr

No score
No answers yet
No answers on this topic

Oracle GoldenGate

Oracle GoldenGate 8.8
Based on 3 answers
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.
Michael Grayson | TrustRadius Reviewer

In-Person Training

Apache Solr

No score
No answers yet
No answers on this topic

Oracle GoldenGate

Oracle GoldenGate 10.0
Based on 1 answer
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.
Michael Grayson | TrustRadius Reviewer

Online Training

Apache Solr

No score
No answers yet
No answers on this topic

Oracle GoldenGate

Oracle GoldenGate 10.0
Based on 1 answer
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.
Michael Grayson | TrustRadius Reviewer

Implementation Rating

Apache Solr

No score
No answers yet
No answers on this topic

Oracle GoldenGate

Oracle GoldenGate 8.6
Based on 3 answers
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.
Michael Grayson | TrustRadius Reviewer

Alternatives Considered

Apache Solr

We have considering AWS search and Elastic search but decide to go with Solr as we need high speed and flexible query, and so far it meets all our requirement so we still continue with Solr.
trang nguyen | TrustRadius Reviewer

Oracle GoldenGate

We tried at the first time using data replication from the storage, but [it did] not always work like we wanted because you need to reconstruct your databases and configuration. And if you [did] not present the LUNs in the same order or you missed an alias you can lose the data. So for that reason we pick[ed] Oracle GoldenGate.
Alejandro Pineda | TrustRadius Reviewer

Scalability

Apache Solr

No score
No answers yet
No answers on this topic

Oracle GoldenGate

Oracle GoldenGate 10.0
Based on 1 answer
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.
Michael Grayson | TrustRadius Reviewer

Return on Investment

Apache Solr

  • It's enabled us to deliver fast, relevant search results on our new website. The site is still in beta and being actively developed so our complete ROI is still unknown.
  • It integrates very well with Drupal so it has saved us from having to develop a custom solution.
Richard Davies | TrustRadius Reviewer

Oracle GoldenGate

  • 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.
Gurcan Orhan | TrustRadius Reviewer

Pricing Details

Apache Solr

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Apache Solr Editions & Modules

Additional Pricing Details

Oracle GoldenGate

General

Free Trial
Yes
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Oracle GoldenGate Editions & Modules

Edition
Data Integration$250.001
  1. Per License
Additional Pricing Details

Rating Summary

Likelihood to Recommend

Apache Solr
7.6
Oracle GoldenGate
8.3

Likelihood to Renew

Apache Solr
Oracle GoldenGate
9.2

Usability

Apache Solr
Oracle GoldenGate
8.6

Reliability and Availability

Apache Solr
Oracle GoldenGate
10.0

Performance

Apache Solr
Oracle GoldenGate
9.0

Support Rating

Apache Solr
Oracle GoldenGate
8.8

In-Person Training

Apache Solr
Oracle GoldenGate
10.0

Online Training

Apache Solr
Oracle GoldenGate
10.0

Implementation Rating

Apache Solr
Oracle GoldenGate
8.6

Scalability

Apache Solr
Oracle GoldenGate
10.0

Add comparison