We performed a comparison between JumpMind SymmetricDS, Oracle GoldenGate, and SSIS based on real PeerSpot user reviews.
Find out what your peers are saying about NetApp, Fivetran, Dell Technologies and others in Data Replication."It is fully featured. It has allowed me to do everything I wanted to do."
"Ease of installation, maintenance and powerful outputs and supporting Big Data and Cloud environment as well as OGGCS (Oracle Golden Gate Cloud Service)."
"When we are replicating data between similar databases then it is straightforward."
"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."
"I like that the product transforms data and provides real-time applications."
"The most valuable feature is data replication capability."
"They've recently improved the ease of implementation."
"This solution provides us with real-time replication and it does not affect the performance of other operations, which is very important to us."
"The product is reliable for data integrity."
"The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task."
"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."
"Overall, it's a good product."
"Built in reports show package execution and messages. Logging can also be customized so only what is needed is logged. There is also an excellent logging replacement called BiXpress that provides both historical and real-time monitoring which is more efficient and much more robust than the built-in logging capabilities. And none of this requires custom coding to make it useful unlike many other ETL tools."
"The main value of any Microsoft product is the ease of use. You can achieve more with less time. That's what's beneficial for me. With many competitors, you might need to spend more time coming up with a solution because you have to focus on taking care of the product."
"This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language."
"Like most Microsoft products, SSIS is user-friendly and easy to use."
"The script component is very powerful, things that you cannot normally do, is feasible through C#."
"The user interface could improve. We are looking at some cloud-based databases, and I don't think they support that."
"The product lacks some features and it's expensive."
"Regarding improvements, the focus should be on addressing data quality issues and minimizing delays, particularly in Oracle databases. The technical support should be improved as well. Additionally, in terms of features, it would be great if the solution could support APIs. The support is not friendly. They don’t respond on time."
"The main problem of Oracle GoldenGate is that sometimes, the processes get abended. Data consistency is also challenging."
"Oracle GoldenGate's installation is not user-friendly, we had to read a lot of documentation for the setup and configuration."
"What needs improvement in Oracle GoldenGate is the support. Another feature that needs to be improved in the solution is its GUI. It would be useful for programmers or users to be able to work from the GUI, not just from the command line. Simplifying how Oracle GoldenGate is used would also make the solution better."
"It should be easier to integrate this solution with non-Oracle databases, including cloud-based solutions hosted on Azure."
"It would be great if Oracle added some enhanced features or more functionalities to Oracle GoldenGate."
"Lacks the ability to become a full-scale ETL tool."
"We'd like them to develop data exploration more."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
"Sometimes we need to connect to AWS to get additional data sources, so we have to install some external LAN and not a regular RDBMS. We need external tools to connect. It would be great if SSIS included these tools. I'd also like some additional features for row indexing and data conversion."
"The solution could improve on integrating with other types of data sources."
"We've had issues in terms of the amount of data that is transferred when we are scheduling."
"Tuning using this solution requires extensive expertise to improve performance."
"Improvement as per customer requirements."
"It needs more integration tools, so you can connect to different sources."