Oracle GoldenGate vs SnapLogic comparison

Read 22 SnapLogic reviews

3,248 Views
2,142 Comparison Views

86% willing to recommend

Oracle GoldenGate

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between Oracle GoldenGate and SnapLogic based on real PeerSpot user reviews.

Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.

To learn more, read our detailed Oracle GoldenGate vs. SnapLogic Report (Updated: October 2024).

Oracle GoldenGate vs. SnapLogic

Download the complete report

Helped 814,649 peers since 2012

Categories and Ranking

Oracle GoldenGate

Ranking in Data Integration

8th

Average Rating

8.2

Number of Reviews

Ranking in other categories

No ranking in other categories

SnapLogic

Ranking in Data Integration

24th

Average Rating

7.8

Number of Reviews

Ranking in other categories

Process Automation (16th), Cloud Data Integration (13th), Integration Platform as a Service (iPaaS) (10th)

Featured Reviews

Vijay Manoharan

IT Technical Specialist at a healthcare company with 10,001+ employees

Mar 7, 2024

Performs real-time replication without data loss, but we cannot do much automation

The setup with the classic GoldenGate architecture was easy. Oracle has now moved to Microservices Architecture. It is a real pain. There are a lot of new things we have to learn. I rate the ease of setup of the classic architecture a seven out of ten. For Microservices, I rate the ease of setup a three out of ten. The deployment takes a couple of hours. We need one system administrator to deploy the tool. We need to maintain the tool. We are a team of four people. We need at least three people for maintenance. The time taken for maintenance depends on how big the environment is. We spend a lot of time on maintenance because our environment is big.

Read full review

Selva Dhoom

Technical Manager at a tech services company with 11-50 employees

Jun 30, 2022

Automates manual activities and has helpful documentation that allows users to self-study

What could be improved in SnapLogic is that it was not capable in terms of processing a large number of datasets, but at that point, SnapLogic was evolving. It didn't give a lot of Snaps. I heard recently there are a lot of Snaps getting added and the solution was being enhanced, particularly to connect different data sources. When I was working with SnapLogic six months to one year back, I faced the issue of it not being capable of handling a huge volume of datasets or didn't have much of Snaps, and that was the drawback. If there is any large number of data sets, that's based on or depends on your configuration. If it is a huge volume of data, other traditional ETL tools such as Informatica and Talend can process millions and billions of records, while in SnapLogic, the Snaplex fails or it returns an error in terms of processing that huge volume of data. Informatica, Talend, or any other ETL tool can run for hours in terms of jobs, while SnapLogic jobs fail when the threshold is reached. SnapLogic isn't able to withstand processing, but I don't know if that's still an issue at present, because the solution is getting enhanced and it's been more than six months to one year since I last worked with SnapLogic. There are now a lot of Snaps getting added to the solution, and if it can overcome the limitations I mentioned, SnapLogic could be the go-to tool because currently, it's not being used as much in organizations. It's being used comparatively less compared to other retail tools.

Read full review

Quotes from Members

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

Pros

"You can put data together from a few databases into one database or the other way, from one database into several. It transforms data in real-time."

"Many of the features of Oracle GoldenGate are valuable. We use Oracle databases and this tool is from Oracle, making it have superior compatibility."

"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."

"GoldenGate can connect and collect data from multiple sources, such as SQL Server."

"You can use Oracle GoldenGate as a DR for your system."

"The platform's most helpful features are its speed and its guarantee of data replication from one database to another."

"It works best with Oracle."

"The live application feature is most valuable. The solution is stable. I rate it a seven out of ten."

More Oracle GoldenGate pros

"SnapLogic is a great platform for establishing integrations among various systems or patterns by using any kind of interface. If something is not supported by predefined snaps – snaps are connectors in SnapLogic – you can create them (custom snaps) or write a script."

"SnapLogic is more user-friendly than Boomi in terms of debugging. You can move the mouse to a place, and it will record and show the data easily."

"The feature I found most valuable in SnapLogic is low-code development. Low-code development has been very useful for simple processes, which is required for business users such as extracting details from a file or getting things reported by calling your web service. Calling your web service also becomes easier with SnapLogic because of the snaps available, so if you have the documentation, you can call an API. You don't have to write all those clients to call an API, so that is another feature I found very easy in SnapLogic. Configuring and managing all the file systems also become very handy with the solution."

"It is a scalable solution."

"The solution could improve its API management."

"By using snaps instead of functions in code, you can see the building blocks of the integration visually. This helps a lot."

"The solutions ability to connect "snaps" or components to the graphic user interface is very intuitive, prevents errors, and makes implementations easy."

"I found SnapLogic valuable and what I found most valuable about it was its ETL feature. I also found its automation feature valuable. It can be used for automating manual activities. It can be used as a middleware for certain transactional data processing and minimal datasets and ETL activities."

More SnapLogic pros

Cons

"Some issues regarding stability need to be resolved."

"The front-end management isn't very good."

"The solution sometimes has issues with long transactions and replication delays. Its pricing needs improvement."

"The problem with GoldenGate is it is very complex to use. You need heavyweight skills to use it."

"It's stable but you have to know how to maintain it. That's why it's not 10 out of 10 for me. There are some bugs, there are some issues here and there. All of a sudden your process is not working and you have to figure out why, and sometimes it's not so clear."

"The solution is quite costly, and if they could reduce their pricing, it would be more economical to implement."

"Monitoring must be a bit more enhanced."

"It is not a very stable tool, and you need to monitor it perfectly."

More Oracle GoldenGate cons

"We'd like there to be more ways for users to get more comfortable and have more experience with the solution to make it easier to use."

"What could be improved in SnapLogic is that it was not capable in terms of processing a large number of datasets, but at that point, SnapLogic was evolving. It didn't give a lot of Snaps. I heard recently there are a lot of Snaps getting added and the solution was being enhanced, particularly to connect different data sources. When I was working with SnapLogic six months to one year back, I faced the issue of it not being capable of handling a huge volume of datasets or didn't have much of Snaps, and that was the drawback. If there is any large number of data sets, that's based on or depends on your configuration. If it is a huge volume of data, other traditional ETL tools such as Informatica and Talend can process millions and billions of records, while in SnapLogic, the Snaplex fails or it returns an error in terms of processing that huge volume of data. Informatica, Talend, or any other ETL tool can run for hours in terms of jobs, while SnapLogic jobs fail when the threshold is reached. SnapLogic isn't able to withstand processing, but I don't know if that's still an issue at present, because the solution is getting enhanced and it's been more than six months to one year since I last worked with SnapLogic. There are now a lot of Snaps getting added to the solution, and if it can overcome the limitations I mentioned, SnapLogic could be the go-to tool because currently, it's not being used as much in organizations. It's being used comparatively less compared to other retail tools."

"The biggest issue we have faced in our company with SnapLogic is regarding the EDI format"

"SnapLogic doesn't provide any on-premises software, so users have only cloud-based software to use."

"SnapLogic sits somewhere in the middle. It doesn’t offer enough easy canned integrations for its users like some of the easier to use integration apps."

"It needs some more snaps. I would like to see some of the features be changed in some of the snaps."

"I would like to see more performance-related dashboards, ones that display the cost of a pipeline, for instance. Also, it would be helpful to have management dashboards for overseeing pipelines and connections."

"One area for improvement in SnapLogic is the transparency in the flow of data. It needs to have more transparency. Right now, users only have a preview option at the end of any job flow, so at the end of any Snap Pack, there is a data preview option that lets you review the data and see how it's moving. What would make the solution better is more debugging and more access to change data from the preview panel or more functionality in terms of the preview option."

More SnapLogic cons

Pricing and Cost Advice

"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."

"The solution is highly-priced."

"Its price can be better. It is a bit crazy, and its licensing is very difficult to understand. I would rate it one out of five in terms of pricing. There don't seem to be any additional costs."

"The solution would be costly for a small organization."

"Pricing is based on anual licensing with additional costs for support packages."

"We have purchased corporate licensing to use Oracle GoldenGate."

"The tool is a bit expensive."

"Oracle GoldenGate is a high-priced solution because it follows the core-based pricing model versus the software-based pricing model of other solutions."

More Oracle GoldenGate pricing and cost advice

"SnapLogic is not expensive. It's reasonably priced."

"SnapLogic's price is high compared to the other tools available in the market."

"The pricing is okay."

"They have pricing/usage tiers that are easy to move up or down."

"By scaling the solution incrementally the cost is controlled and more beneficial to the client."

"The cost with SnapLogic is an annual license and better than Informatica."

"I used the free trial."

"The license model is based on consumption."

More SnapLogic pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Data Integration solutions are best for your needs.

See recommendations

814,649 professionals have used our research since 2012.

Comparison Review

it_user99375

Database Administrator at a tech services company with 51-200 employees

Mar 31, 2014

Oracle GoldenGate vs. Oracle Active Dataguard

As an Oracle DBA, while working upon high availability of your database you may stumble upon various Oracle strategic capabilities that fall into categories of Oracle Replication. Oracle provides various technologies for replication like GoldenGate, streams, and Active Dataguard. Replication…

Read full review

Top Industries

By visitors reading reviews

Financial Services Firm

22%

Computer Software Company

13%

Manufacturing Company

Government

Financial Services Firm

23%

Manufacturing Company

11%

Computer Software Company

10%

Real Estate/Law Firm

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

Questions from the Community

What do you like most about Oracle GoldenGate?

The product is reliable for data integrity.

What is your experience regarding pricing and costs for Oracle GoldenGate?

The product is expensive. Due to the high cost, we are considering alternative solutions.

What needs improvement with Oracle GoldenGate?

The solution sometimes has issues with long transactions and replication delays. Its pricing needs improvement.

What do you like most about SnapLogic?

Despite having no prior experience in SnapLogic, we managed to build, test, and prepare it for release in just three hours, handling heavy data efficiently.

What needs improvement with SnapLogic?

The biggest issue we have faced in our company with SnapLogic is regarding the EDI format. For instance, suppose if 20 EDIs are shortlisted then SnapLogic will convert and provide only those specif...

What is your primary use case for SnapLogic?

In our company, we used the solution to build a SnapLogic pipeline in a non-production environment. Presently, our company is releasing it to the production environment. We have used SnapLogic in o...

AWS Database Migration Service vs Oracle GoldenGate

Comparisons

Compared 18% of the time

Qlik Replicate vs Oracle GoldenGate

Compared 12% of the time

Quest SharePlex vs Oracle GoldenGate

Compared 7% of the time

Azure Data Factory vs Oracle GoldenGate

Compared 7% of the time

Fivetran vs Oracle GoldenGate

Compared 6% of the time

More Oracle GoldenGate Competitors

AWS Glue vs SnapLogic

Compared 14% of the time

IBM InfoSphere DataStage vs SnapLogic

Compared 11% of the time

Azure Data Factory vs SnapLogic

Compared 10% of the time

Informatica Intelligent Data Management Cloud (IDMC) vs SnapLogic

Compared 7% of the time

Alteryx Designer vs SnapLogic

Compared 7% of the time

More SnapLogic Competitors

Product Reports

Oracle GoldenGate

Download Oracle GoldenGate product report

Download SnapLogic product report

Also Known As

GoldenGate

DataFlow

Learn More

Oracle

Overview

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."

The SnapLogic Intelligent Integration Platform uses AI-powered workflows to automate all stages of IT integration projects – design, development, deployment, and maintenance – whether on-premises, in the cloud, or in hybrid environments. The platform’s easy-to-use, self-service interface enables both expert and citizen integrators to manage all application integration, data integration, API management, B2B integration, and data engineering projects on a single, scalable platform. With SnapLogic, organizations can connect all of their enterprise systems quickly and easily to automate business processes, accelerate analytics, and drive transformation.

Sample Customers

Japan Exchange Group, Daewoo E&C, Herbalife, Starwood Hotels & Resorts, Canon, Turk Telekom

Adobe, ADP, BlackBerry, Bonobos, Box, Capital One, Dannon, Eero, Endo, Gensler, HCL, HP, Grovo, HIS, iRobot, Leica, Merck, Sans, Target, Verizon, Vodafone, Yelp, Yahoo!

Oracle GoldenGate vs. SnapLogic