Oracle GoldenGate and StreamSets are prominent in the data integration and replication software category. StreamSets appears to have the upper hand when it comes to ease of use and affordability, while Oracle GoldenGate excels in features and performance.
Features: Oracle GoldenGate offers real-time data replication, robust change data capture, and seamless integration with Oracle environments. It supports large dataset transformations quickly and integrates well with cloud platforms. StreamSets provides a user-friendly setup, eliminating the need for coding expertise. It features a wide range of connectors, effective data drift management, and supports both batch and streaming ETL tasks.
Room for Improvement: Oracle GoldenGate could enhance user-friendliness, simplify non-Oracle database integration, and reevaluate its pricing structure. It faces challenges with complex setups, DDL replication, and high licensing fees. StreamSets needs to improve its interface, memory management, and bolster security. Better monitoring, logging, and documentation would enhance usability across deployments.
Ease of Deployment and Customer Service: Oracle GoldenGate offers versatile deployment, including on-premises and hybrid cloud options, though its setup is complex. Customer service feedback is mixed, indicating inconsistent support and response times. StreamSets is praised for public and hybrid cloud deployment flexibility and effective customer service, addressing issues promptly. However, its pricing and support models need clarification for some users.
Pricing and ROI: Oracle GoldenGate's core-based pricing is viewed as expensive but offers substantial ROI for intensive projects, particularly in large environments by reducing downtime. StreamSets attracts smaller enterprises with free community versions and diverse pricing plans, although commercial versions can be costly. Both solutions provide significant ROI when aligned with enterprise goals, with GoldenGate noted for efficient downtime and cost reductions.
The support team responds quickly, providing feedback which we then implement.
IBM technical support sometimes transfers tickets between different teams due to shift changes, which can be frustrating.
It effectively manages larger databases, such as those of 15 terabytes and above.
Oracle GoldenGate is quite stable.
The configuration process could be made simpler.
For Oracle GoldenGate, customers face challenges with patching, the latest updates, and encountering bugs.
It would be beneficial if StreamSets addressed any potential memory leak issues to prevent unnecessary upgrades.
The list price is high, and the price can sometimes seem expensive if the appropriate discount is not applied.
The pricing of Oracle GoldenGate is quite high.
The ability to sync data in real time is a key feature I rely on.
Active Data Guard is an important feature for disaster recovery site applications.
It allows a hybrid installation approach, rather than being completely cloud-based or on-premises.
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:
Oracle GoldenGate Benefits
Some of the benefits of using Oracle GoldenGate include:
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."
StreamSets is a data integration platform that enables organizations to efficiently move and process data across various systems. It offers a user-friendly interface for designing, deploying, and managing data pipelines, allowing users to easily connect to various data sources and destinations. StreamSets also provides real-time monitoring and alerting capabilities, ensuring that data is flowing smoothly and any issues are quickly addressed.
We monitor all Data Integration 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.
