We performed a comparison between SSIS and Tungsten RPA 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 is better than doing it in some alternative ways. We don't have to worry about so much manual work."
"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 ability of SSIS to transform and transport data is extremely valuable to me. It allows for intelligent extraction and manipulation of data during the process. Improved error handling would enhance ETL processes further. I haven't directly utilized the data flow components but they seem capable of supporting complex data integration needs."
"Overall, it's a good product."
"It's a competent product."
"The most valuable feature of SSIS is that you can take data from other servers which are not MS SQL Server or Oracle."
"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 OCR was quite stable and flexible."
"It is stable and scalable."
"The features that we have found the most valuable are the integration of different third-party support and productivity services."
"The pricing of the solution is quite good."
"The most valuable features are workflow and process automation."
"The most valuable feature of Kofax RPA is the simplicity of automating tasks."
"The ability to script information from websites is most valuable. It also seems to be fairly robust and reasonably easy to manage on a server-based deployment. We have a number of robots operating on the central server."
"It is very simple and easy to learn compared to any other RPA tools such as UiPath, Automation Anywhere and Blue Prism."
"At one point, we did have to purchase an add-on."
"Tuning using this solution requires extensive expertise to improve performance."
"It hangs a lot of the time."
"It's difficult to refactor SSIS. It gets cumbersome to reuse the solution."
"In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade."
"It's a legacy tool, that is nearing the end of its useful life."
"We've had issues in terms of the amount of data that is transferred when we are scheduling."
"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."
"There is really nothing special about the capabilities of this product."
"Its documentation is not widely available on the web. They should work on the availability of its documentation. In Automation Anywhere, there is a feature called Discovery Bot that automatically records the process steps and suggests a possible bot. I am not sure if such a feature is available in Kofax. If it is not available, it will be very good to have this feature. "
"The product has some constraints and performance issues."
"The solution needs to be scalable."
"The scalability has room for improvement."
"The product needs more AI capabilities."
"This product has room for improvement in support of aviation. The interface could be improved in the next release."
"The process discovery could be a bit better."
SSIS is ranked 2nd in Data Integration with 69 reviews while Tungsten RPA is ranked 12th in Robotic Process Automation (RPA) with 24 reviews. SSIS is rated 7.6, while Tungsten RPA is rated 7.4. The top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". On the other hand, the top reviewer of Tungsten RPA writes "A stable product that provides end-to-end solutions for different business problems". SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue, whereas Tungsten RPA is most compared with UiPath, Microsoft Power Automate, Blue Prism, Automation Anywhere (AA) and SAS Data Management. See our SSIS vs. Tungsten RPA report.
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.