We performed a comparison between SSIS, TIBCO BusinessWorks, and Workato based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."We like that this solution includes a developer edition, free of charge, to allow for training."
"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."
"It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."
"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."
"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
"The initial setup of this solution is very straightforward."
"The data reader is the most valuable feature."
"SSIS integrates well with SQL servers and Microsoft products."
"The OSGI console is available to debug different issues and get low level informations on the applications development, like bundle, dependencies, etc."
"The ability to link to different technologies is valuable to us."
"It is user friendly, it's not complex."
"Good TIBCO BusinessWorks features are the admin console and the ability to roll back to the previous version."
"The high availability, tolerance, and load balancing features are top-notch. Its scalability features are also pretty cool."
"It is a very robust system."
"The most valuable part of the solution is the ease-of-use and ease of deployment."
"The solution is very scalable. It can handle a lot. We have encryption plus integration servers running on that platform currently."
"It is very easy to use. It takes complex workloads away, and it provides very smooth integration. It has got a lot of out-of-the-box connectors. It has got a lot of out-of-the-box APIs, which makes it really easy to integrate with applications for different use cases, whether it is in finance, HR, or customer operations. It is by far our favorite integration product."
"It is easier to use than other technical open-source technologies."
"It's easy to understand, makes flows and is efficient."
"Their automation and workflows are very strong, and you can build the workflows very easily and quickly."
"Stability-wise, I rate the solution a ten out of ten."
"Workato is low code, intuitive, and easy to use."
"The most valuable features are easy integration, quick tab to develop, quick tab to market, and interactive integration platform."
"The performance of SSIS could improve when comparing it to Oracle Database."
"We would like the solution to be expanded so that it is available for other platforms than just Microsoft."
"It would be nice if you could run SSIS on other environments besides Windows."
"The solution could improve on integrating with other types of data sources."
"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."
"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."
"It's a legacy tool, that is nearing the end of its useful life."
"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."
"There are multiple plugins which increase the number of product installations."
"A possible improvement could be to give the capability to use different profiles for each AppNode when an application is deployed on an AppSpace."
"I'd like to see a new cloud approach in the next release. They need to work on integrations, stability and management issues on their cloud platform."
"Improve Business Studio's stability to further minimize development time."
"Cloud fitness is lacking"
"The communication protocols could be improved."
"This solution's cloud could be improved. I don't know whether it was because we didn't have the internal expertise or if it was the product itself, but since they came later—I think only two or three years into the cloud—after many other iPaaS that had been in the cloud for longer, I feel that maybe they haven't matured in terms of the cloud."
"They don't support out of the box - you have to buy adapters or you have to have the technology."
"It is tedious to make a tailor-fit function."
"I would like to see the dashboarding and reporting processes improved."
"The management dashboard in the solution is an area with shortcomings that needs improvement."
"Workato's Extract, transform, and load (ETL) and extract, load, and transform (ELT) are not very strong and could be improved for very complex transformations."
"The only minor drawback would be if there was a UI at the front of it, for apps and for a portal as well, it would make it really easy. It would be really useful if there were more apps capabilities."
"From the deployment point of view, our customers encounter platform downtime where it does not serve the actual request on the systems."
"A limitation is that their cloud presence is only in North America and Europe."