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."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."
"We like that this solution includes a developer edition, free of charge, to allow for training."
"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 main value of any Microsoft product is the ease of use. You can achieve more with less time. That's what's beneficial for me. With many competitors, you might need to spend more time coming up with a solution because you have to focus on taking care of the product."
"The initial setup of this solution is very straightforward."
"This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language."
"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."
"Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."
"The drag and drop functionality is quite good."
"The most valuable feature of Kofax RPA is the simplicity of automating tasks."
"Kofax handles UIs via the browser well. If it's not possible, they have other features like modeling screen scrapes, etc."
"Provides valuable tools working in integration with RPA tools."
"It is stable and scalable."
"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."
"The solution is scalable."
"The best part of Kofax is that they have a whole concept. It's one product, but also has extra elements that can be integrated."
"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."
"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."
"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."
"The solution could improve on integrating with other types of data sources."
"The high prices attached to the product can be an area of concern where improvements are required."
"The performance of this solution is not as good as other tools in the market."
"It should have other programming languages supported as well from a scripting perspective. Currently, only C# and VB.NET are supported, which limits it to .NET. It should have Java support as well."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
"Kofax RPA's UI could be more user-friendly."
"The solution needs to be scalable."
"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. "
"This product has room for improvement in support of aviation. The interface could be improved in the next release."
"We are on version 10.6, and the current version seems to be 11. Kofax is cycling the capabilities of the product very quickly. One of the difficulties has been to actually keep up with the capabilities as they've evolved. On the one hand, it is good that the product is getting better, but on the other hand, it is difficult to implement the best way with a product that is evolving constantly."
"The solution could use some AI integrated features."
"The process discovery could be a bit better."
"The product needs more AI capabilities."
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.