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 most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."
"The most valuable feature of SSIS is that it can handle real complex transformations."
"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 performance is better than doing it in some alternative ways. We don't have to worry about so much manual work."
"The initial setup of this solution is very straightforward."
"The data reader is the most valuable feature."
"Built in reports show package execution and messages. Logging can also be customized so only what is needed is logged. There is also an excellent logging replacement called BiXpress that provides both historical and real-time monitoring which is more efficient and much more robust than the built-in logging capabilities. And none of this requires custom coding to make it useful unlike many other ETL tools."
"Like most Microsoft products, SSIS is user-friendly and easy to use."
"This is a stable platform and we did not encounter any big problems."
"The OCR was quite stable and flexible."
"Provides valuable tools working in integration with RPA tools."
"Kofax handles UIs via the browser well. If it's not possible, they have other features like modeling screen scrapes, etc."
"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."
"The most valuable feature is the robotic process."
"The features that we have found the most valuable are the integration of different third-party support and productivity services."
"I would like to see more standard components out of the box, such as SFTP, and Data Compression components."
"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."
"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."
"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."
"SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc."
"At one point, we did have to purchase an add-on."
"Microsoft should offer an on-premises support warranty for those using that deployment. They seem to be withdrawing from on-premises options."
"Options for scaling could be improved."
"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. "
"I'd like to see a recording function and a more simple interface."
"The product needs more AI capabilities."
"The technical support must be improved."
"The solution could use some AI integrated features."
"This product has room for improvement in support of aviation. The interface could be improved in the next release."
"I would like to see them further enhance the OCR, specifically in the multi-language support."
"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 Tungsten TotalAgility. 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.