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."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 simplicity of the solution is great. The solution also offers excellent integration."
"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."
"I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."
"The most valuables features are the relatively short learning curve, and the automation capabilities provided through the BIML add-in for SSDT."
"It's a competent product."
"The most valuable feature of SSIS is that it can handle real complex transformations."
"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 most valuable part of the solution is the ease-of-use and ease of deployment."
"It is a seamless and sophisticated tool."
"The most valuable feature is the integration."
"It is a very robust system."
"It is very stable. It is a market leader, and it has connectors to many of the legacy systems. It also has enterprise cloud connectors."
"Stability-wise, I rate the solution a ten out of ten…On a scale from one to ten, where one is difficult, and ten is easy, I rate the initial setup a nine."
"Good performance and reliability."
"Customer support is very efficient."
"It is easier to use than other technical open-source technologies."
"Workato is low code, intuitive, and easy to use."
"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."
"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."
"It's easy to understand, makes flows and is efficient."
"The most valuable features are easy integration, quick tab to develop, quick tab to market, and interactive integration platform."
"The high prices attached to the product can be an area of concern where improvements are required."
"Options for scaling could be improved."
"Future releases should improve the data lineage, as it currently is not good."
"At one point, we did have to purchase an add-on."
"There are a lot of things that Microsoft could improve in relation to SSIS. One major problem we faced was when attempting to move some Excel files to our SQL Server. The Excel provider has a limitation that prevents importing more than 255 columns from a particular Excel file to the database. This restriction posed a significant issue for us."
"We've had issues in terms of the amount of data that is transferred when we are scheduling."
"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."
"I would like to see better integration with Power BI."
"Though it is a stable product, if we have an issue with the product, it gets difficult, and it gets really difficult to explain the issue to the support team. Also, it takes a long time to get resolved."
"Its price can be improved. For medium enterprises, it is a very expensive tool. In the market, you won't get many resources for this solution. You won't find many developers in the market very easily. The latest version of TIBCO (6.4 or 6.x) is not very stable. It has got many issues. We have raised this with TIBCO, and they are taking a lot of time to come up with a fix, which is making us move away from this product. Some of the performance-tuning aspects are also missing in version 6. They should provide performance-related fixes, which will be helpful for the customers. If you are migrating from the current version to the container-supported version, it is quite expensive. The product has evolved, but it is very pricey. That's one of the challenges. They have provided all the features that are there in other products, but this is a platform upgrade. The platform has completely been changed from 5.x to 6.x, and we can't use the same environment. We can't run both versions on the same server as VM. The development environment is entirely different. In version 5.x, there was a proprietary designer. Now, it has common plug-ins developed on top of Eclipse."
"Improve Business Studio's stability to further minimize development time."
"Could be more user friendly in the development area."
"They don't support out of the box - you have to buy adapters or you have to have the technology."
"There is room for improvement on the learning side."
"The cost of the solution has room for improvement."
"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 would like to see the dashboarding and reporting processes improved."
"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."
"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."
"From the deployment point of view, our customers encounter platform downtime where it does not serve the actual request on the systems."
"It is tedious to make a tailor-fit function."
"The management dashboard in the solution is an area with shortcomings that needs improvement."
"A limitation is that their cloud presence is only in North America and Europe."
