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."The performance and stability are good."
"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 most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."
"Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."
"The performance is good."
"It has good data integration and good processes."
"It has the ability to be deployed into the cloud through Data Factory, and run completely as a software as a service in the cloud."
"It is easy to set up the solution."
"The productivity is the most valuable feature. It is very easy to write remediations."
"WSO2's analytics capability is good, considering the ELC support they provide."
"The learning curve for this solution is very good."
"The customer service executives are very responsive."
"The drag-and-drop features for connectors are very valuable."
"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 stability is excellent."
"I like the user-friendly system and development of the service-oriented architecture."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
"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."
"There were some issues when we tried to connect it to data storage. It was a connection issue."
"I come from a coding background and this tool is graphically based. Sometimes I think it's cumbersome to do mapping graphically. If there was a way to provide a simple script, it would be helpful and make it easier to use."
"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."
"The security could be improved, as it is more important in our context."
"Sometimes when we want to publish to other types of databases it's not easy to publish to those databases. For example, the Jet Database Engine. Before the SSIS supported Jet Database Engine but nowadays it doesn't support the Jet Database Engine. We connect to many databases such as Access database, SparkPros databases and the other types of databases using Jet Database Engines now and SSIS now doesn't seem to support it in our databases."
"Future releases should improve the data lineage, as it currently is not good."
"You cannot include the validation of XPath."
"The administration side is complex and could use significant improvements to enhance the solution's functionality."
"The micro integrator should be improved. There is room for enhancement considering alternative integration components."
"They should introduce better pricing for small companies."
"If I have to buy software, then it becomes expensive for me."
"I would like to see better documentation for the open-source version."
"In my opinion, the administration model and interface, of Carbon, are lacking in terms of its features and user experience."
"The server is very specific and it is very difficult to get experience with it."
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 Oracle Service Bus, Red Hat Fuse, IBM Integration Bus, webMethods Integration Server and Mule ESB. 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.