We performed a comparison between SSIS and WSO2 Enterprise Integrator 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 has good data integration and good processes."
"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."
"I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."
"The technical support is very good."
"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."
"It has a drag and drop feature that makes it easy to use. It has a good user experience because it takes into account your most-used tools and they're lined up nicely so you can just drag and drop without looking too far. It also integrates nicely with Microsoft."
"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 solution basically conforms to our standards."
"It's a very complete product. It allows us to network security and add more layers of security to the system."
"The solution's customer service is good."
"The productivity is the most valuable feature. It is very easy to write remediations."
"The installation process is easy."
"Currently, I find the configuration part quite valuable, where you can easily configure things."
"The customer service executives are very responsive."
"The drag-and-drop features for connectors are very valuable."
"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."
"There is connectivity with other databases, however, this is the most significant issue that has to be addressed."
"There were some issues when we tried to connect it to data storage. It was a connection issue."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
"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."
"The security could be improved, as it is more important in our context."
"I would also like to see full integration with our BI because then our full load of data will be available in our organization. They should incorporate an ATL process."
"The administration side is complex and could use significant improvements to enhance the solution's functionality."
"I would like to see them bring back a feature, from earlier versions, that was very useful in debugging and finding issues."
"If I have to buy software, then it becomes expensive for me."
"In my opinion, the administration model and interface, of Carbon, are lacking in terms of its features and user experience."
"They should introduce better pricing for small companies."
"You cannot include the validation of XPath."
"The integration capabilities need to be improved."
"One of the reasons that we are looking for a replacement is their way of defining integration. The language of the XML structures that I use to describe the integrations are not that standard, and it's not easy to find people who are familiar with this approach."
SSIS is ranked 2nd in Data Integration with 69 reviews while WSO2 Enterprise Integrator is ranked 19th in Data Integration with 18 reviews. SSIS is rated 7.6, while WSO2 Enterprise Integrator is rated 7.6. The top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". On the other hand, the top reviewer of WSO2 Enterprise Integrator writes "Consolidated, reliable, and has responsive technical support". SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue, whereas WSO2 Enterprise Integrator is most compared with Red Hat Fuse, Oracle Service Bus, IBM Integration Bus and webMethods Integration Server. See our SSIS vs. WSO2 Enterprise Integrator report.
See our list of best Data Integration vendors.
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.
