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 is easy to set up the product."
"There are many good features in this solution including the data fields, database integration, support for SQL views, and the lookups for matching information."
"The debugging capabilities are great, particularly during data flow execution. You can look into the data and see what's going on in the pipeline."
"It is easy to set up the solution."
"The solution is stable."
"The most valuable thing is that it is easy to connect with Microsoft tools. In Europe, particularly in France, a lot of companies use Excel, SQL Server, and other Microsoft tools, and it is easier to connect SSIS with Microsoft tools than other products."
"The performance and stability are good."
"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."
"WSO2's analytics capability is good, considering the ELC support they provide."
"It's a consolidated product. It works and it does its job pretty well."
"The solution's customer service is good."
"The learning curve for this solution is very good."
"The customer service executives are very responsive."
"I like the user-friendly system and development of the service-oriented architecture."
"The solution has two main parts: integration and transformation. It's very user-friendly and easy to understand for everyone."
"In my opinion, the most valuable aspect of this solution is its extensive range of adaptors and connectors. This feature holds significant importance and provides great value to users."
"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."
"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."
"It would be nice if you could run SSIS on other environments besides Windows."
"Improving the login procedure would make our reporting easier on monitoring our ETL processes."
"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."
"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."
"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."
"SSIS can improve by the minimum code requirements in stored procedures and exporting data is difficult. They could make it easier, it should be as easy as it is to import data."
"The setup can be difficult for those not familiar with the solution."
"The product's price is an area of concern where improvements are required."
"I would like to see them bring back a feature, from earlier versions, that was very useful in debugging and finding issues."
"WSO2 libraries are not mature enough. For example, if you want to integrate with Kafka using its Kafka library, it often has many bugs."
"There are a lot of security settings that when you apply you have to re-apply again every time you modify a setting. It is something that really needs to be enhanced."
"The integration capabilities need to be improved."
"I would like to see better documentation for the open-source version."
"They should introduce better pricing for small companies."
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, IBM Integration Bus, Oracle Service 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.