We performed a comparison between SAS Access, SSIS, and webMethods Integration Server based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."The most valuable aspect of the solution is the ease of access to the data in those databases."
"The most valuable part of SAS/ACCESS is what it is made for: connecting to remote systems that are not part of your physical SAS environment."
"The most valuable feature is you have native access to the external databases."
"We like that this solution includes a developer edition, free of charge, to allow for training."
"It is easy to set up. The deployment is also very quick."
"The simplicity of the solution is great. The solution also offers excellent integration."
"I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."
"SSIS' best feature is SFTP connectivity."
"This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language."
"The most valuables features are the relatively short learning curve, and the automation capabilities provided through the BIML add-in for SSDT."
"SSIS' most valuable feature is its reporting services."
"It is a very stable product."
"The most valuable feature of the webMethods Integration Server is the built-in monitoring, auditing, RETS, and SOAP services."
"High throughput and excellent scalability."
"Application integrations are offered out-of-the-box, and that is extremely important to us. This is one of the main use cases that we have for it. It is about 60 to 70 percent of the workload in our application today."
"What I found most valuable in webMethods Integration Server is that it's a strong ESB. It also has strong API modules and portals."
"The most valuable feature of the webMethods Integration Server is its reliability. It has a lot of great documentation from the service providers. Additionally, it is easy to use."
"How simple it is to create new solutions."
"It's a visual tool, so our transformations can be quickly implemented without a lot of fuss. The fact that we have an easy way to expose REST services is also very interesting. It offers the possibility to connect over GMS to synchronize message brokers."
"The solution can provide access to the newer databases that come out sooner."
"I can't really recall any missing feature or general improvement that is needed. We don't really add too many new kinds of databases and therefore our needs are already met."
"The pricing model needs to be reconsidered and adjusted."
"We're in the process of switching to Informatica, and we need to work out data lineage and data profiling and to improve the quality of our data. SSIS, however, is not that compatible with Informatica. We managed to connect it to Informatica Metadata Manager, but we don't get good lineage, so we have to redo all our ETLs using the Informatica process in order to accept the proper data lineage."
"You have to write push down join & lookup SQL to the database yourself via stored procedures or use of the SQL Task to get very high performance. That said, this is a common complaint for nearly all ETL tools on the market and those that offer an alternative such as Informatica offer them at a very expensive add-on price."
"Video training would be a helpful addition."
"We've had issues in terms of the amount of data that is transferred when we are scheduling."
"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
"The solution could improve on integrating with other types of data sources."
"Sometimes, there are compatibility issues with some features. From time to time, I also face issues when trying to migrate. If I misconfigure things when I use Snapshot, the migration will fail.It can take a long time to migrate huge amounts of data, so it would be nice if that could be faster."
"wM SAP Adapter User Guide - Example, like Message Broker setup was unclear, leading to issues during Testing and we had refer the internet forums to understand that there is a Message Broker Cleanup utility and that needs to be setup as well."
"In terms of improvement, it would be better if it adapted quicker to open standards. It took a while for API specification before the last version was available. The spec of version two was rather quick."
"It could be more user-friendly."
"This product is for larger companies. Compared to TIBCO I think webMethods is better in terms of ease of use and support."
"The installation process should be simplified for first time users and be made more user-friendly."
"Rapid application development has to be considered, especially for UI, where user interference is crucial."
"We got the product via a reseller, and the support from the reseller has been less than desirable."
"The UI for the admin console is very old. It hasn't been updated for years and is pretty much the same one that we started with. This is something that could be refreshed and made more modern."
More webMethods Integration Server Pricing and Cost Advice →