We performed a comparison between AWS Data Pipeline [EOL] and SSIS based on real PeerSpot user reviews.
Find out in this report how the two Cloud Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The most valuable feature of the solution is that orchestration and development capabilities are easier with the tool."
"It is a stable solution...It is a scalable solution."
"It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."
"The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task."
"The most valuables features are the relatively short learning curve, and the automation capabilities provided through the BIML add-in for SSDT."
"It's already very user-friendly and has a good dashboard."
"In SSIS, the scope is not only to handle ETL challenges, but it will allow us to do so many other tasks, such as DBA activities, scripting, calling any .exe or scripts, etc."
"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."
"The most valuable thing is that it is easy to connect with Microsoft tools. In Europe, particularly in France, a lot of companies use Excel, SQL Server, and other Microsoft tools, and it is easier to connect SSIS with Microsoft tools than other products."
"The performance and stability are good."
"The user-defined functions have shortcomings in AWS Data Pipeline."
"It's almost semi-automatic because you must review and approve code push, which works well. Still, we had many problems getting there during the deployment process, but we got there."
"The solution could improve on integrating with other types of data sources."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
"We'd like them to develop data exploration more."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
"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."
"I come from a coding background and this tool is graphically based. Sometimes I think it's cumbersome to do mapping graphically. If there was a way to provide a simple script, it would be helpful and make it easier to use."
"We would like the solution to be expanded so that it is available for other platforms than just Microsoft."
"I would like to see better technical documentation because many times information is missing."
AWS Data Pipeline [EOL] doesn't meet the minimum requirements to be ranked in Cloud Data Integration with 2 reviews while SSIS is ranked 2nd in Data Integration with 69 reviews. AWS Data Pipeline [EOL] is rated 8.0, while SSIS is rated 7.6. The top reviewer of AWS Data Pipeline [EOL] writes "A tool with great orchestration and development capabilities but needs to improve its user-defined functions". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". AWS Data Pipeline [EOL] is most compared with AWS Database Migration Service, Oracle Data Integrator (ODI), FME, AWS Glue and Perspectium DataSync, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue. See our AWS Data Pipeline [EOL] vs. SSIS report.
See our list of best Cloud Data Integration vendors.
We monitor all Cloud 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.