We performed a comparison between SSIS, TIBCO BusinessWorks, and Unifi based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."SSIS' best feature is SFTP connectivity."
"The workflow features have been very valuable. You can have automated workflows and all the steps are controlled. The workflow functionality of integration services is excellent."
"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."
"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."
"SSIS integrates well with SQL servers and Microsoft products."
"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."
"In SSIS, the scope is not only to handle ETL challenges, but it will allow us to do so many other tasks, such as DBA activities, scripting, calling any .exe or scripts, etc."
"The solution is easy to use and developer friendly."
"I work in operations, so I value BusinessWorks' performance the most."
"It is user friendly, it's not complex."
"The most valuable feature is the integration."
"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."
"The solution is stable. We haven't had any serious technical issues."
"The most valuable features are the stability and the time to market."
"One of the most valuable features is data transformation. We have some legacy systems which are in old technology, like SOAP, whereas the new ones are in REST. So we use BusinessWorks to transform data from one format to another, from SOAP to REST."
"Good TIBCO BusinessWorks features are the admin console and the ability to roll back to the previous version."
"It's easy to manage and support the user, our guests, and our customers if they have a problem."
"The controller makes it easy to control everything from one platform. The management is easy."
"The creation of the measure in the DAC's model could be improved."
"You have to write push down join & lookup SQL to the database yourself via stored procedures or use of the SQL Task to get very high performance. That said, this is a common complaint for nearly all ETL tools on the market and those that offer an alternative such as Informatica offer them at a very expensive add-on price."
"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."
"Video training would be a helpful addition."
"At one point, we did have to purchase an add-on."
"There is connectivity with other databases, however, this is the most significant issue that has to be addressed."
"The solution could improve on integrating with other types of data sources."
"There were some issues when we tried to connect it to data storage. It was a connection issue."
"The initial setup is not easy."
"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."
"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."
"Could be more user friendly in the development area."
"Technical support is average. It's not the best."
"The Business Studio tool can be improved, which is the tool for designing the processes. Improving the Business Studio tool will make this solution more stable. It has a steep learning curve, and it is pretty tough to learn."
"The cost of this product is too expensive for smaller companies or those with a small number of integrations."
"There are not many plugins available to integrate the databases. We have to write it in Java and integrate it. The developers should have more knowledge. These are the three main aspects that they could improve."
"It's stable, but it depends on the office and location."
"There are issues with certain Apple devices."
