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."SSIS is an easy way to do data integration from various data sources. It doesn't matter whether it's a database, flat files, XML, or Web API. It can talk to the and join them all together."
"The most important features are it works well and provides self-service BI."
"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."
"The performance is better than doing it in some alternative ways. We don't have to worry about so much manual work."
"It has a drag and drop feature that makes it easy to use. It has a good user experience because it takes into account your most-used tools and they're lined up nicely so you can just drag and drop without looking too far. It also integrates nicely with Microsoft."
"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."
"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."
"The solution is easy to use and developer friendly."
"The product provides end-to-end solutions for different business problems."
"The OCR was quite stable and flexible."
"The flexibility to use already-developed components is really good. You can use it for Excel-related operations and other things."
"The product saves time and resources."
"Provides valuable tools working in integration with RPA tools."
"This is a stable platform and we did not encounter any big problems."
"Kofax RPA's best feature is its high success percentage in picking up information from documents, especially where the DPI is really low."
"Kofax handles UIs via the browser well. If it's not possible, they have other features like modeling screen scrapes, etc."
"We've had issues in terms of the amount of data that is transferred when we are scheduling."
"I would like to see better integration with Power BI."
"Microsoft's technical support has decreased in quality over the last few years, becoming less responsive and tending to pass problems on instead of solving them."
"We purchase an add on called task factory primarily to allow bulk delete, update and upsert capability. I'd like to see this be part of the standard package."
"SSIS is cumbersome despite its drag-and-drop functionality. For example, let's say I have 50 tables with 30 columns. You need to set a data type for each column and table. That's around 1,500 objects. It gets unwieldy adding validation for every column. Previously, SSIS automatically detected the data type, but I think they removed this feature. It would automatically detect if it's an integer, primary key, or foreign key column. You had fewer problems building the model."
"Future releases should improve the data lineage, as it currently is not good."
"There is connectivity with other databases, however, this is the most significant issue that has to be addressed."
"The performance of SSIS could improve when comparing it to Oracle Database."
"There is really nothing special about the capabilities of this product."
"The product should improve desktop automation, which is hard to configure. It needs to have custom connectors. It is the only advantage that Microsoft Power Platform has over Kofax RPA. It has more than 800 custom connectors."
"Kofax RPA could improve web-based automation and there should be a choice of what browser we can use, such as Google Chrome, instead of an inbuilt browser from Kofax RPA. Additionally, Kofax RPA is missing an orchestrator that other solutions have, such as UiPath."
"The process discovery could be a bit better."
"Exception handling needs to be improved."
"It needs a free training portal for anybody on the internet to use so that they can get an idea of what the possibilities are."
"I would like to see them further enhance the OCR, specifically in the multi-language support."
"Kofax RPA needs to improve integration with SAP and Microsoft. The professional services offered by the tool's team is below par. Its licensing needs to be more modular."
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.