We performed a comparison between AWS Database Migration Service 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 initial setup is very straightforward."
"The product's initial setup phase was very easy."
"The solution is instantaneous. We can launch the service and reduce the end number of manpower."
"AWS Database Migration Service is good for smaller workloads and provides compatibility."
"If your infrastructure is already on Amazon, it simply makes the most sense to use a tool officially provided by them as an additional service, rather than having to rely on a third-party solution."
"I am very impressed by the scalability of AWS Database Migration Service."
"The initial setup is simple. Not that much complex."
"I like that I can focus on the logic and I don't have to worry about the administration stuff. AWS handles that for me."
"Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."
"The solution is stable."
"The most important features are it works well and provides self-service BI."
"The workflow features have been very valuable. You can have automated workflows and all the steps are controlled. The workflow functionality of integration services is excellent."
"SSIS integrates well with SQL servers and Microsoft products."
"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."
"It's saved time using visualization descriptions."
"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."
"More endpoints need to be supported by AWS Database Migration Service. There's also a need for more control and transparency on the product, including better technical support."
"What needs improvement in AWS Database Migration Service is that it lacks a log file validation feature. If the solution could provide more details about a particular transaction, that would be helpful. The stability of AWS Database Migration Service for online CDC records also needs to be improved."
"The server has limits on how many can connect to the database."
"The live duplication has a delay of two minutes, which can be an issue."
"There are a set of complexities and challenges when a user wants to integrate AWS products with Microsoft products."
"Database Migration Service could be more integrated. I think that it makes sense to add integration to these functions. For example, AWS Glue has a feature called Orchestrator to create data flows, and that's more straightforward."
"It would be helpful if the bandwidth could be independent of the network or if we could have a dedicated bandwidth for this product."
"As a solution, the better thing is if more platforms come with direct compatibility, like connecting to different data sources. The basic problem I faced the most was while transferring and reading data from Excel. So, one time, I found that all the components I had declared in my scripts were able to take it. And after some patching happens, it is not able to support that. Again, we need to update the version of Excel. So, it's not like a plug-in type place where you have done the solution and are confident that it will work. So, this is an area of improvement."
"I have a tool called ZappySys. I need that tool to cut down on the complexity of SSIS. That tool really helps with a quick turnaround. I can do things quickly, and I can do things accurately. I can get better reporting on errors."
"Performance could be better."
"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."
"We'd like more integration capabilities."
"At one point, we did have to purchase an add-on."
"The performance of this solution is not as good as other tools in the market."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
"We've had issues in terms of the amount of data that is transferred when we are scheduling."
More AWS Database Migration Service Pricing and Cost Advice →
AWS Database Migration Service is ranked 2nd in Cloud Data Integration with 27 reviews while SSIS is ranked 2nd in Data Integration with 69 reviews. AWS Database Migration Service is rated 7.8, while SSIS is rated 7.6. The top reviewer of AWS Database Migration Service writes "A cloud solution for live replication but has stability issues". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". AWS Database Migration Service is most compared with AWS Glue, Oracle GoldenGate, Qlik Replicate, Fivetran and Oracle GoldenGate Cloud Service, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue. See our AWS Database Migration Service 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.
