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."You can get data from any data source with SSIS and dump it to any outside source. It is helpful. Getting, extracting, converting, and dumping data doesn't require much effort because we can do everything in the user interface. You drag and drop, then give the required input. It's intuitive."
"The product's deployment phase is easy."
"It's saved time using visualization descriptions."
"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."
"SSIS' best feature is SFTP connectivity."
"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."
"The most valuable features of this solution are the fast insert and fuzzy logic matching."
"Currently, I find the configuration part quite valuable, where you can easily configure things."
"WSO2's analytics capability is good, considering the ELC support they provide."
"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."
"The solution's technical support is very knowledgeable."
"The solution has two main parts: integration and transformation. It's very user-friendly and easy to understand for everyone."
"The productivity is the most valuable feature. It is very easy to write remediations."
"It was mostly easy to set up the product."
"The installation process is easy."
"In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade."
"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."
"Improvement as per customer requirements."
"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."
"We'd like more integration capabilities."
"Options for scaling could be improved."
"The solution could improve on integrating with other types of data sources."
"SSIS doesn't have a very good user interface, but if you can work with it, it'll provide you with almost all of the functionality."
"The administration side is complex and could use significant improvements to enhance the solution's functionality."
"The server is very specific and it is very difficult to get experience with it."
"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 customization can be a bit difficult."
"WSO2 libraries are not mature enough. For example, if you want to integrate with Kafka using its Kafka library, it often has many bugs."
"If I have to buy software, then it becomes expensive for me."
"The integration capabilities need to be improved."
"I would like to see better documentation for the open-source version."
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.