We performed a comparison between Oracle GoldenGate Cloud Service, Spring Cloud Data Flow, and SSIS based on real PeerSpot user reviews.
Find out what your peers are saying about Amazon Web Services (AWS), MuleSoft, Matillion and others in Cloud Data Integration."GoldenGate's best features are the desktop security features."
"Scalability-wise, I rate the solution a ten out of ten."
"GoldenGate can aggregate various data types from different sources."
"This has significantly eased the process of migration from on-premise to cloud. Instead of configuring everything from the ground up, the Oracle GoldenGate Cloud Service has made it seamless to build and render databases in cloud."
"There are a lot of options in Spring Cloud. It's flexible in terms of how we can use it. It's a full infrastructure."
"The most valuable feature is real-time streaming."
"The product is very user-friendly."
"The most valuable features of Spring Cloud Data Flow are the simple programming model, integration, dependency Injection, and ability to do any injection. Additionally, auto-configuration is another important feature because we don't have to configure the database and or set up the boilerplate in the database in every project. The composability is good, we can create small workloads and compose them in any way we like."
"The ability of SSIS to transform and transport data is extremely valuable to me. It allows for intelligent extraction and manipulation of data during the process. Improved error handling would enhance ETL processes further. I haven't directly utilized the data flow components but they seem capable of supporting complex data integration needs."
"The UI is very user-friendly."
"The script component is very powerful, things that you cannot normally do, is feasible through C#."
"You can get data from any data source with SSIS and dump it to any outside source. It is helpful. Getting, extracting, converting, and dumping data doesn't require much effort because we can do everything in the user interface. You drag and drop, then give the required input. It's intuitive."
"Like most Microsoft products, SSIS is user-friendly and easy to use."
"The setup is straightforward. It's very easy to install."
"SSIS integrates well with SQL servers and Microsoft products."
"The data reader is the most valuable feature."
"Oracle is always adding new features. I can't think of anything that's urgent currently."
"More technical documentation is needed, especially in terms of mapping and conversion of data, while integration would also be very helpful."
"The initial setup was a little complex, and we required support from Oracle to complete it."
"Oracle GoldenGate Cloud Service lacks AI. If AI gets introduced in Oracle GoldenGate Cloud Service, it would be much easier to do analysis."
"Some of the features, like the monitoring tools, are not very mature and are still evolving."
"On the tool's online discussion forums, you may get stuck with an issue, making it an area where improvements are required."
"Spring Cloud Data Flow could improve the user interface. We can drag and drop in the application for the configuration and settings, and deploy it right from the UI, without having to run a CI/CD pipeline. However, that does not work with Kubernetes, it only works when we are working with jars as the Spring Cloud Data Flow applications."
"The configurations could be better. Some configurations are a little bit time-consuming in terms of trying to understand using the Spring Cloud documentation."
"SSIS is cumbersome despite its drag-and-drop functionality. For example, let's say I have 50 tables with 30 columns. You need to set a data type for each column and table. That's around 1,500 objects. It gets unwieldy adding validation for every column. Previously, SSIS automatically detected the data type, but I think they removed this feature. It would automatically detect if it's an integer, primary key, or foreign key column. You had fewer problems building the model."
"I would also like to see full integration with our BI because then our full load of data will be available in our organization. They should incorporate an ATL process."
"The high prices attached to the product can be an area of concern where improvements are required."
"It should have other programming languages supported as well from a scripting perspective. Currently, only C# and VB.NET are supported, which limits it to .NET. It should have Java support as well."
"Sometimes when we want to publish to other types of databases it's not easy to publish to those databases. For example, the Jet Database Engine. Before the SSIS supported Jet Database Engine but nowadays it doesn't support the Jet Database Engine. We connect to many databases such as Access database, SparkPros databases and the other types of databases using Jet Database Engines now and SSIS now doesn't seem to support it in our databases."
"In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade."
"Video training would be a helpful addition."
"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."
More Oracle GoldenGate Cloud Service Pricing and Cost Advice →
