We performed a comparison between SSIS and webMethods Integration Server based on real PeerSpot user reviews.
Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better."
"SSIS' best feature is SFTP connectivity."
"Data Flows are the main component we use. These can range from a simple source to sink ETL, to many source to many sink dataflows."
"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 most valuable feature of SSIS is that it can handle real complex transformations."
"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."
"The performance is better than doing it in some alternative ways. We don't have to worry about so much manual work."
"The most valuable feature of SSIS is that you can take data from other servers which are not MS SQL Server or Oracle."
"The Software AG Designer has been great. It's very intuitive."
"When it comes to the user interface, I'm already really used to it. I cannot say anything against it. For me, it's easy to use."
"The synchronous and asynchronous messaging system the solution provides is very good."
"The development is very fast. If you know what you're doing, you can develop something very easily and very fast."
"webMethods Integration Server is an easy-to-use solution and does not require a lot of coding."
"The MFT component of webMethods, for example, is easy to set up and convenient to use. It handles files very efficiently and it is easy to automate tasks with complex schedules. Monitoring is centralized to MWS which can be used to monitor other products as well (Trading Networks, BPM, MFT, etc.)"
"I like the stability of the webMethods Integration Server."
"The stability is good."
"We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."
"It would be nice if you could run SSIS on other environments besides Windows."
"It hangs a lot of the time."
"The interface could use improvement, as well as the administrative tools. Jobs fail from time to time for different reasons. It's not a problem with Microsoft, or SSIS itself. The problems are external, but to find the problems and analyze them it takes too much time."
"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."
"When I compare Talend and SSIS, Talend provides more features. With Talend, we can handle a large volume of data. Talend is usually used to treat a large volume of data, which makes it better than SSIS on the data side. Talend also has a very good Talend Management Console to schedule the jobs and do other things. It can also be easily connected to version control tools such as GitHub or SVN. The last time I used SSIS, it was connected through TSS for the Windows Console version. I am not sure it has been improved or not. If it is not improved, Microsoft should improve it. They should change the product to provide another console."
"Microsoft's technical support has decreased in quality over the last few years, becoming less responsive and tending to pass problems on instead of solving them."
"There are a lot of things that Microsoft could improve in relation to SSIS. One major problem we faced was when attempting to move some Excel files to our SQL Server. The Excel provider has a limitation that prevents importing more than 255 columns from a particular Excel file to the database. This restriction posed a significant issue for us."
"Need to see more API portal features like monetizing APIs and private cloud readiness."
"In terms of scale, I would give it a four out of 10."
"The price should be reduced to make it more affordable."
"The solution has big instances when deployed under microservices or in a containerized platform. They need to improve that so that it is competitive with other integration solutions, like Redis and Kafka. Deployments under microservices with those solutions are much more lightweight, in the size of the runtime itself, compared with Software AG."
"For code version control, you need to use some external software."
"I'd like to see the admin portal for managing the integration server go up a level, to have more capabilities and to be given a more modern web interface."
"The interface needs some work. It is not very user-friendly."
"This is a great solution and the vendor could improve the marketing of the solution to be able to reach more clients."
More webMethods Integration Server Pricing and Cost Advice →
SSIS is ranked 2nd in Data Integration with 69 reviews while webMethods Integration Server is ranked 3rd in Enterprise Service Bus (ESB) with 60 reviews. SSIS is rated 7.6, while webMethods Integration Server is rated 8.0. The top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". On the other hand, the top reviewer of webMethods Integration Server writes "Event-driven with lots of helpful formats, but minimal learning resources available". SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue, whereas webMethods Integration Server is most compared with IBM Integration Bus, webMethods.io Integration, Mule ESB, TIBCO BusinessWorks and Boomi AtomSphere Integration. See our SSIS vs. webMethods Integration Server report.
We monitor all 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.