Compare Oracle GoldenGate vs. Pentaho Data Integration

Cancel
You must select at least 2 products to compare!
Most Helpful Review
Find out what your peers are saying about Oracle GoldenGate vs. Pentaho Data Integration and other solutions. Updated: July 2021.
521,690 professionals have used our research since 2012.
Quotes From Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros
"When we are replicating data between similar databases then it is straightforward.""The initial setup is straightforward. It doesn't take too much time or effort to implement the solution.""This is a powerful solution provided by one of the most respected companies in the computer industry.""The most valuable feature is data replication capability.""The CDC feature is interesting.""They've recently improved the ease of implementation.""GoldenGate can connect and collect data from multiple sources, such as SQL Server.""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."

More Oracle GoldenGate Pros »

"The solution has a free to use community version.""The amount of data that it loads and processes is good.""Pentaho Data Integration is quite simple to learn, and there is a lot of information available online.""It's my understanding that the product can scale."

More Pentaho Data Integration Pros »

Cons
"The process of transforming the data between two different databases is inefficient and needs to be improved.""The solution, in general, should be easier to use, with less need to perform workarounds within the system.""Technical support for Oracle products needs to be more efficient (at least locally in Egypt).""It should be easier to integrate this solution with non-Oracle databases, including cloud-based solutions hosted on Azure.""We struggle with memory. It's limited. However, it may be because of our unique business case and how we use it that it's limiting for us.""The solution is quite costly, and if they could reduce their pricing, it would be more economical to implement.""I would like to see the interface more graphical and easier to use.""Troubleshooting issues is not always the easiest. It should be easier to troubleshoot. Their support can also be improved. They don't read your problem statement and waste a lot of time. GoldenGate for big data is actually a separate license. It is sort of a separate product, but it might fall underneath your GoldenGate category. If we're talking about big data, its interaction with big data sources is poorly documented."

More Oracle GoldenGate Cons »

"It's not very stable, at least not in the case of the community edition. I'm working with the community edition right now and I think perhaps it is because of that it is not very stable, it causes the system to sometimes hang. I'm not sure if this is the case for pair tiers.""I would like to see improvements made for real-time data processing.""I'm still in the very recent stage concerning Pentaho Data Integration, but it can't really handle what I describe as "extreme data processing" i.e. when there is a huge amount of data to process. That is one area where Pentaho is still lacking.""The product needs more plugins."

More Pentaho Data Integration Cons »

Pricing and Cost Advice
"Pricing is based on anual licensing with additional costs for support packages.""The price of this solution is good.""We have an enterprise license for it. It might be for three years or so. I'm not aware of any additional costs to the standard licensing fee."

More Oracle GoldenGate Pricing and Cost Advice »

"The price of the regular version is not reasonable and it should be lower.""Sometimes we provide the licenses or the customer can procure their own licenses. Previously, we had an enterprise license. Currently, we are on a community license as this is adequate for our needs."

More Pentaho Data Integration Pricing and Cost Advice »

report
Use our free recommendation engine to learn which Data Integration Tools solutions are best for your needs.
521,690 professionals have used our research since 2012.
Answers from the Community
RajneeshShukla
author avatarAThiré
User

There are two products I know about
* TimeXtender : Microsoft based, Transformation logic is quiet good and can easily be extended with T-SQL , Has a semantic layer that generates metat data for cubes . price approx 40K$, works with tables
. Attunity (Bought by Qlik) : technology agnostic , nice web interface , expensive > 100K€. Works with transaction logs

There are many other pure ETL tools
* ERWIN has a nice one ,

author avatarKaroly Krokovay
User

Hi Rajneesh,
yes here is the feature comparison between the community and enterprise edition : https://www.hitachivantara.com/en-us/pdf/brochure/leverage-open-source-benefits-with-assurance-of-hitachi-overview.pdf

And a short description of the community edition: https://www.predictiveanalyticstoday.com/pentaho-community-edition/

And the download link: https://community.hitachivantara.com/s/article/downloads

You can ask more from the great community: https://forums.pentaho.com/

Regards
Károly

author avatarKaroly Krokovay
User

We have experiences only in Pentaho Data Integrator (open source competitor of the Oracle Data Integrator).
But OLAP exporting wasn't in our scope until now.

author avatarStefan Schäfer
User

We usually use Talend.
Look here: https://community.talend.com/t5/Design-and-Development/The-way-from-OLTP-to-OLAP/td-p/116719

author avatarPhil Wilkins (Capgemini)
Consultant

Depends upon the technologies being used. If you're using Oracle for both OLTP and OLAP then you'll get a lot of value from an Oracle solution.


The other question is how up to date do you want your OLAP DB to be? Goldengate is a good answer if you're looking to minimize latency, but it can be expensive. ODI is less expensive but better suited to bulkier data sets.  If an Oracle product wasn't the option I'd probably consider something like Informatica.

author avatarRajneeshShukla
Real User

Hi Karoly, Thanks for your input. community: https://forums.pentaho.com/ is not allowing new registrations for new users. I guess they accept queries from customers only and not from any one. Do you know any other forum, community, SMEs contacts who can help on queries?

author avatarRajneeshShukla
Real User

Hi Karoly,

Thanks for your response !!!
Is Pentaho Data Integrator available as freeware/open source tool? Does it come in basic, standard and enterprise editions flavors?

It integrates data from various heterogeneous systems like multiple variety of databases (SQL server, Oracle, DB2 etc), files (XML, XLS, CSV, text etc)? Targets can be any type of DB , file etc.?

What all flavors available like Basic, Standard, Enterprise editions? All editions are free/ open source?

Thanks,
Rajneesh

author avatarRajneeshShukla
Real User

Hi AThire ,
Thanks for your response, I am looking for open source tools.

Regards,
Rajneesh

Questions from the Community
Top Answer: Depends upon the technologies being used. If you're using Oracle for both OLTP and OLAP then you'll get a lot of value from an Oracle solution. The other question is how up to date do you want your… more »
Top Answer: 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… more »
Top Answer: We have an enterprise license for it. It might be for three years or so. I'm not aware of any additional costs to the standard licensing fee.
Top Answer: Hi Rajneesh, yes here is the feature comparison between the community and enterprise edition :… more »
Top Answer: Pentaho Data Integration is quite simple to learn, and there is a lot of information available online.
Top Answer: Sometimes we provide the licenses or the customer can procure their own licenses. Previously, we had an enterprise license. Currently, we are on a community license as this is adequate for our needs.
Ranking
8th
Views
18,645
Comparisons
11,050
Reviews
9
Average Words per Review
607
Rating
8.0
16th
Views
9,073
Comparisons
7,460
Reviews
3
Average Words per Review
652
Rating
7.7
Popular Comparisons
Also Known As
GoldenGate
Kettle
Learn More
Overview
Oracle GoldenGate is a comprehensive software package for real-time data integration and replication in heterogeneous IT environments. The product set enables high availability solutions, real-time data integration, transactional change data capture, data replication, transformations, and verification between operational and analytical enterprise systems.

Pentaho data integration prepares and blends data to create a complete picture of your business that drives actionable insights. The complete data integration platform delivers accurate, "analytics ready" data to end users from any source. With visual tools to eliminate coding and complexity, Pentaho puts big data and all data sources at the fingertips of business and IT users alike.

Offer
Learn more about Oracle GoldenGate
Learn more about Pentaho Data Integration
Sample Customers
Japan Exchange Group, Daewoo E&C, Herbalife, Starwood Hotels & Resorts, Canon, Turk Telekom
66Controls, Providential Revenue Agency of Ro Negro, NOAA Information Systems, Swiss Real Estate Institute
Top Industries
REVIEWERS
Healthcare Company18%
Manufacturing Company9%
Government9%
Non Profit9%
VISITORS READING REVIEWS
Computer Software Company37%
Comms Service Provider14%
Financial Services Firm8%
Media Company7%
REVIEWERS
Comms Service Provider15%
Healthcare Company15%
Financial Services Firm15%
Computer Software Company15%
VISITORS READING REVIEWS
Computer Software Company28%
Comms Service Provider20%
Financial Services Firm8%
Government7%
Company Size
REVIEWERS
Small Business42%
Midsize Enterprise17%
Large Enterprise42%
REVIEWERS
Small Business28%
Midsize Enterprise24%
Large Enterprise48%
Find out what your peers are saying about Oracle GoldenGate vs. Pentaho Data Integration and other solutions. Updated: July 2021.
521,690 professionals have used our research since 2012.

Oracle GoldenGate is ranked 8th in Data Integration Tools with 8 reviews while Pentaho Data Integration is ranked 16th in Data Integration Tools with 4 reviews. Oracle GoldenGate is rated 7.8, while Pentaho Data Integration is rated 7.8. The top reviewer of Oracle GoldenGate writes "Powerful solution that centralizes our data and has a user-friendly interface ". On the other hand, the top reviewer of Pentaho Data Integration writes "Free to use, easy to set up, and has a great metadata injection feature". Oracle GoldenGate is most compared with AWS Database Migration Service, Oracle Data Integrator (ODI), Qlik Replicate, Quest SharePlex and Azure Data Factory, whereas Pentaho Data Integration is most compared with Talend Open Studio, SSIS, Informatica PowerCenter, Oracle Data Integrator (ODI) and FME. See our Oracle GoldenGate vs. Pentaho Data Integration report.

See our list of best Data Integration Tools vendors and best Cloud Data Integration vendors.

We monitor all Data Integration Tools reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.