We performed a comparison between SSIS and TIBCO BusinessWorks 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."It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better."
"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."
"It is easy to set up. The deployment is also very quick."
"SSIS' best feature is SFTP connectivity."
"The main value of any Microsoft product is the ease of use. You can achieve more with less time. That's what's beneficial for me. With many competitors, you might need to spend more time coming up with a solution because you have to focus on taking care of the product."
"The most important features are it works well and provides self-service BI."
"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."
"It has good data integration and good processes."
"The most valuable feature is the integration."
"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."
"It is user friendly, it's not complex."
"The OSGI console is available to debug different issues and get low level informations on the applications development, like bundle, dependencies, etc."
"One of the most valuable features is that it's a simple development. It takes a short time to get services to work."
"The most valuable feature is the low-code platform."
"The ability to link to different technologies is valuable to us."
"BusinessWorks reduces development time, helping developers to focus on business logic."
"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."
"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."
"Improvement as per customer requirements."
"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."
"I would like to see better technical documentation because many times information is missing."
"Options for scaling could be improved."
"We have issues with SSIS connectors while extracting data from Excel sources."
"The solution could improve by having quicker release updates."
"The communication protocols could be improved."
"The cost of this product is too expensive for smaller companies or those with a small number of integrations."
"There are multiple plugins which increase the number of product installations."
"The initial setup is not easy."
"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."
"The container-based image is too large and this makes auto-scaling difficult."
"There is room for improvement on the learning side."
"The cost has room for improvement."
SSIS is ranked 2nd in Data Integration with 69 reviews while TIBCO BusinessWorks is ranked 18th in Data Integration with 23 reviews. SSIS is rated 7.6, while TIBCO BusinessWorks is rated 8.0. The top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". On the other hand, the top reviewer of TIBCO BusinessWorks writes "Reliable integration solution with robust communication capabilities and good scalability". SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue, whereas TIBCO BusinessWorks is most compared with webMethods Integration Server, Mule Anypoint Platform, Spring Cloud Data Flow, Confluent and Azure Data Factory. See our SSIS vs. TIBCO BusinessWorks report.
See our list of best Data Integration vendors.
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.
