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."It is a stable solution...It is a scalable solution."
"The most valuable feature of the solution is that orchestration and development capabilities are easier with the tool."
"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."
"It is easy to set up the product."
"SSIS' most valuable feature is its reporting services."
"It has good data integration and good processes."
"It is easy to set up. The deployment is also very quick."
"The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task."
"It has the ability to be deployed into the cloud through Data Factory, and run completely as a software as a service in the cloud."
"It is also easy to learn and user-friendly. Microsoft is also good in terms of technical support. They have built a large community all over the world."
"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 user-defined functions have shortcomings in AWS Data Pipeline."
"The performance of this solution is not as good as other tools in the market."
"It would be nice if you could run SSIS on other environments besides Windows."
"It's difficult to refactor SSIS. It gets cumbersome to reuse the solution."
"Future releases should improve the data lineage, as it currently is not good."
"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."
"Video training would be a helpful addition."
"We'd like them to develop data exploration more."
"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, AWS Glue, Oracle Data Integrator (ODI), FME 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.